MICROSOFT EXCEL III: ADVANCED COURSE

Use the power of Excel for decision making, analysis, auditing & error trapping 

Prerequisites for this expert level course: Excel 1 and 2 and/or experience and daily use. Excel 3, a 12-hour course, covers:

Logical and lookup functions for decision making and reference

Advanced formulas for auditing, error-trapping and arrays

Special functions—date and time, text, and more

Importing and exporting external data and cleaning it up for use: removing duplicate entries, non-printing characters, extra spaces, inconsistent capitalization, etc.

Using Excel to manage list-based and tabula data

The Analysis Toolpak

Recording and running macros and creating forms

Download flyer.