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.