Description
The Microsoft Excel Expert Course is a designed to deepen knowledge, expand opportunity and go deep into topics that are essential for those who use Excel almost daily. Throught this 17 week experience we will facilitate advanced learning around pillars of advanced Excel competency: Advanced Workbook options & settings, basic macros, advanced data formatting, creating advanced formulas & functions and advanced data visualizations.
This course is structured around the objectives Microsoft sets for certification as an Excel Expert. For students that meet the qualifications, Create My Excel can administer testing and Excel Expert certification on behalf of Microsoft.
Sessions Overview:
Advanced Workbook Options & Settings (Sessions 1 – 3)
- Setting up and copying Basic Macros
- Advanced workbook set ups for collaboration
- Using and configuring language options
Advanced Data Management (Sessions 4 – 6)
- Using advanced series & fill options
- Advanced data validation
- Advanced conditional formatting
Advanced Formulas & Functions (Sessions 7 – 12)
- Comprehensive use of logical functions
- Comprehensive use of look up functions
- Advanced time & date functions
- Survey of financial formulas
- Use built in data analysis tools
- Troubleshooting errors
Advanced Built in Data Visualization (Sessions 12 – 14)
- Advanced charts & graphs
- Effectively using & modifying Pivot Tables
Certification Preparation (Sessions 15 – 17)
Use discount code “BrionHurley” to save 10% OFF
