or Shift + # on a UK keyboard.Quote:
Originally Posted by Brandtrock
Printable View
or Shift + # on a UK keyboard.Quote:
Originally Posted by Brandtrock
Thanks MD that made it alot easier.
I started VBA after doing some work in Access. I am now looking at excel itself. Have looked at VBA in excel and not so much excel itself. You and Xld have shown me some functions. Can you point me in the direction of a web site or book that explains functions? I have looked at some of the help files in excel however would like some better explenations.
Cheers
The problem is that Excel is so many things, functions/formulae, charting, pivot tables, filtering, data avalidation, conditional formatting, et al. Any book that attempts the whole range is just scratching the surface, but here are a few web sites on different aspects:
Data Validation
http://www.contextures.com/xlDataVal01.html
Pivot tables
http://www.contextures.com/xlPivot01.html
http://www.peltiertech.com/Excel/Pivots/pivottables.htm
Charting
http://www.andypope.info/charts.htm
http://peltiertech.com/Excel/Charts/index.html
Conditional Formatting
http://www.contextures.com/xlCondFormat01.html
http://www.xldynamic.com/source/xld.CF.html
Most of these functions above are driven by, or benefit from, applied formulae. That is the hardest to get, and there is only one book IMO worth anything, and that is Walk's book. Not great IMO, but better than anything else. Formulae is a subject best learned by a good course or mentoring in my view, but a good course is hard to come by.
Thanks again xld and Md.
Between you, you have given me so much to look at. I need to go study, I had better cut my visits to the forum for a couple of days. And go and learn some stuff.
So, I'd like a forum :)
Forum Name: SQL Server
Forum Description: Post here for questions on SQL Server, VBA and SQL, and the like
Ill go ahead and make an SQL forum under the help section.
Thanks Jake :thumb