$500.00 – $750.00
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.
Description
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)Â
Note:
If the number of participants does not reach 10, the money will be returned to you, as we cannot start with fewer participants.
Additional information
| OPT | With Certification, Only Instructional |
|---|
Related products
-
Excel Associate Course
$500.00 – $750.00 Select options This product has multiple variants. The options may be chosen on the product page -
Formula & Functions Deep Dive
-
Excel Consulting
$50.00 – $450.00 Select options This product has multiple variants. The options may be chosen on the product page -
Excel Consulting
Select options This product has multiple variants. The options may be chosen on the product page