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.
€ 120.00
120.0
EUR
€ 120.00
| Responsible | Virginie Tijtgat |
|---|---|
| Last Update | 06/02/2026 |
| Members | 16 |
-
Downloads2Lessons ·
-
NL_Cursus_Excel - Level 2
-
NL_Oefenbestanden
-
-
1. Introduction1Lessons ·
-
1.1. Introduction
-
-
2. Managing workbooks8Lessons ·
-
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 data3Lessons ·
-
3.1. Filling cells based on existing data
-
3.2. Formatting and validating data
-
3.3. Conditional formatting
-
-
4. Advanced formulas5Lessons ·
-
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. Macros6Lessons ·
-
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 tables7Lessons ·
-
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 known fields
-
6.7. Data formatting
-
-
7. Advanced charts3Lessons ·
-
7.1. Double-axis graphs
-
7.2. Charts with additional features
-
7.3. Pivot charts
-