Advanced Topics In Excel Training Class
January 26, 2008 @ 7:06 PM by JP • 1 views • No Comments »
My offer to teach Excel training classes at my office has been accepted. The class is tentatively titled "Advanced Topics in Excel" and will cover the following topics (among others TBD). I will also be including code and formulas from this site.
Counting/Filtering:
SUMPRODUCT, COUNTIF, SUMIF
Working with dates:
INT/MOD
Text functions:
RIGHT, LEFT, MID
Misc functions:
HYPERLINK
And of course, Macros.
The class will debut sometime after March. So far I have been spending about 4 hours per day (straight) writing course material. There will also be an Outlook training class for which I will also write the curriculum.
I swore never to write tutorials, but I will post the class material to the site once it is completed.
TTFN,
JP
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: Formatting Zip+4 Codes
Next Post: Counting Unique Occurrences in an Excel Spreadsheet
I'm looking forward to the tutorials and will be looking out for them. I work a lot with Excel and I'm accustomed to a lot of the features, but I'm by no means a power user, and the topics you'll be covering should advance my knowledge quite significantly I think.
mary