Become proficient in Microsoft Excel and go from beginner to pro with our hands-on Excel Bootcamp. Learn functions, formulas, Pivot Tables, macros, and time-saving techniques to conquer all the key skills needed to excel in Excel.
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