Skip to Content
Startpagina └Excel | Excel Expert (MO-211 prep)
Excel | Excel Expert (MO-211 prep)

Excel | Excel Expert (MO-211 prep)

This course covers the expert features of Excel and everything you need to know to pass the MO-201 or MO-211 Microsoft Excel Expert exam.


€ 160.00
160.0 EUR € 160.00
€ 160.00
Buy Now
Add to Cart
Responsible Virginie Tijtgat
Last Update 30/07/2026
Completion Time 4 hours 22 minutes
Members 28
  • 1. Introduction
    1Lessons · 3 mins
    • 1.1. Introduction
  • 2. Managing workbooks
    8Lessons · 51 mins
    • 2.1. Working with versions
    • 2.2. Securing workbooks
    • 2.3. Sharing
    • 2.4. Configuration formula options
    • 2.5. Comments
    • 2.6. Notes
    • 2.7. Managing language options
    • 2.8. Reference data in other workbooks
  • 3. Managing and formatting data
    3Lessons · 46 mins
    • 3.1. Filling cells based on existing data
    • 3.2. Formatting and validating data
    • 3.3. Conditional formatting
  • 4. Advanced formulas
    5Lessons · 1 hr 29 mins
    • 4.1. Logical operations
    • 4.2. Searching for data with functions
    • 4.3. Date and time functions
    • 4.4. Data analysis
    • 4.5. Debugging formulas
  • 5. Macros
    6Lessons · 20 mins
    • 5.1. What are macros?
    • 5.2. Saving an Excel file with macros
    • 5.3. Recording and using a macro
    • 5.4. Editing a macro
    • 5.5. Copying a macro to another workbook
    • 5.6. Enabling macros
  • 6. Pivot tables
    7Lessons · 27 mins
    • 6.1. Creating a pivot table
    • 6.2. Zones in a pivot table
    • 6.3. Changing fields and options
    • 6.4. Making slicers
    • 6.5. Consolidating pivot table data
    • 6.6. Inserting calculated fields
    • 6.7. Data formatting
  • 7. Advanced charts
    3Lessons · 26 mins
    • 7.1. Double-axis graphs
    • 7.2. Charts with additional features
    • 7.3. Pivot charts
  • Downloads
    6Lessons ·
    • NL_Cursus_Excel - Level 2
    • NL_Oefenbestanden
    • EN_Course_Excel Expert
    • EN_Practice files
    • FR_Cours_Excel Expert
    • FR_Fichier d'exercices