Prepare for the Microsoft Excel exam and become an Excel expert with our certification program. Learn formulas, functions, Pivot Tables, charts, and more through group classes, private training, and an exam with a free retake.
Overview
Syllabus
- Excel Level I: Fundamentals
- Learn how to use functions to speed up your workflow
- Add formatting and other visual effects
- Turn data into visual charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management
- Excel Level II: Intermediate
- Learn to split and join text, add data validation, and named ranges
- Use database functions and logical statements
- Create Pivot Tables to quickly summarize large databases
- Create advanced combo charts from multiple charts
- Excel Level III: Advanced
- Cell management including cell locking, auditing, and hot keys
- Special formatting for calculating dates
- Use advanced functions and advanced analytical toolsÂ
- Record macros and relative reference macros for ad hoc reporting
Taught by
Brian McClain, Mourad Kattan, Adebayo Norman, and Garfield Stinvil
