Advanced Excel training reference manual

The UK's most regular instructor-led training courses.
Training information: excel+training · Excel training courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

John has attended:
Excel Advanced course

by - delegate John [2 posts] (2008 Mar 19 Wed, 17:14) Reply

I attended the Advanced Excel on 18th March in Southwark.

Some of the most useful things covered (for me) were SUMIF, SUBTOTAL and Database Functions.

I can see no support for these in the Course Reference Manual, supplied on CD.

John Whitehead
WaterAid

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Advanced Excel training reference manual

by - trainer Amanda diamond contributer [1217 posts] (2008 Mar 20 Thu, 15:17) Reply

Hi John

Please find attached some notes on the Database functions and using subtotals.

For SUMIF I would like to refer you to the following page, which has a good explanation with accompanying screenshots (there are also a lot of good Excel tips on this site as well):
http://www.contextures.com/xlFunctions01.html#SumIf

Kind regards
Amanda

Attached files...

Excel Advanced topics.doc

· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Identifying Suitable Candidates For VBA For Excel Training
· Tap the Power of Recorded Macros with MS Excel Courses
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Microsoft Excel Training: Essential for Today's Employees

Please browse our web site to find out more about
excel+training and other Microsoft training courses.

Excel tip:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips