A message from the instructor
FREE PREVIEWOverview - Microsoft Office Specialist Certifications
FREE PREVIEWExcel Expert Exam Format
How to prepare for the exam
Excel Workshop files
Exam Objectives: Excel Expert Exam MO-201 skills measured
Presentation file
Overview on Manage workbook options and settings domain
FREE PREVIEWReference data in other workbooks
Manage workbook versions
Protect Worksheet and Workbook
Formula Calculation
Use and configure language options
Overview on Manage and format data domain
FREE PREVIEWFlash Fill
Advanced Fill Options
Custom Formats
Data Validation
Subtotal Group Ungroup
Remove Duplicates and Advanced Filtering
Conditional Formatting
Rules Formulas
Overview on Create advanced formulas and macros domain
FREE PREVIEWAND_OR_NOT functions
IF_IFS functions
SWITCH function
One and Two Logical Operations
VLOOKUP_HLOOKUP
INDEX_MATCH functions
TODAY NOW functions
WEEKDAY function
WORKDAY function
Consolidation
Scenario Manager
Goal Seek
NPER PMT functions
Troubleshooting Formulas
Create and Copy Macro
Overview on Manage advanced charts and tables domain
FREE PREVIEWDual axis combo chart
Box and Whisker chart
Funnel chart
Histogram chart
Map chart
Sunburst chart
Waterfall chart
Pivot Tables - Part1
Pivot Tables - Part2
Pivot Chart
Practice Test Instructions
Practice Test Solution
Final Exam
Course Evaluation تقييم الدورة
Congrats! Conclusion