Boost your resume with a Microsoft Excel Certification. Our program offers three courses, private training, the Specialist Exam fee with free retake, lifetime access to Excel video courses, and free exam proctoring.
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