Advanced Topics In Excel Training Class
January 26, 2008 • JP • No Comments • Rate This Article
• Links to this article
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
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
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