Sleeper: How Do I Get My Own Forum Here???

[mdmackillop]

just left of the 1 key along the top row of numbers

or Shift + # on a UK keyboard.

[peterwmartin]

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

[Bob Phillips]

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.

[peterwmartin]

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.

[malik641]

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

[Jacob Hilderbrand]

Ill go ahead and make an SQL forum under the help section.

[malik641]

Thanks Jake