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:
  • StumbleUpon
  • Technorati
  • Digg
  • Google
  • del.icio.us
  • MisterWong

Print This Post Print This Post  |  Email This Post Email This Post  |  Permalink  |  Subscribe to this feed Subscribe now!

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

This post has 32 views since January 26, 2008 – 7:06 pm.
  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

Post a Comment

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 »