Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Excel training reference manual
Resolved · Low Priority · Version Standard
John has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course
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
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
|
Excel tip:Stop Formula Returning A "#DIV/0" ErrorIf a formula returns a #DIV/0 error message there is a way to avoid such results. |
We'll call during UK business hours
Server loaded in 0.07 secs.