Advanced Topics In Excel Training Class


January 26, 2008 – 7:06 pm by JP

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


If you enjoyed this page, share it!
    StumbleUpon Technorati Digg Google del.icio.us MisterWong TwitThis

Print This Post Print This Post  |  Email This Post Email This Post  |  rss Subscribe to Posts Feed  |  rss Subscribe to Comments

Filed Under: Excel, Formulas, Tutorial, VBA
Tags: , ,

  1. One Response to “Advanced Topics In Excel Training Class”:

  2. 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

    By mary on Jan 27, 2008 at 2:48 am

Post a Comment


Certain comments (including first-time comments) are subject to moderation and will not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, you need to escape those characters. To post VBA code in your comment, use [VBA] tags, like this: [VBA]Code goes here[/VBA].





Subscribe without commenting

Keep Reading:

Browse Posts:


« Formatting Zip+4 Codes || Counting Unique Occurrences in an Excel Spreadsheet »