Part 2 Excel 201 Advanced
Microsoft requires 48 skills to be mastered for certification. Click on the PDF below or look at the table below.
Domain Number And Name |
Tasks |
Domain 1: Manage Workbook Options & Settings |
11 |
Domain 2: Manage & Format Data |
10 |
Domain 3: Create Advanced Formulas & Macros |
15 |
Domain 4: Create Advanced Charts & Tables |
12 |
Certiport/GMetrix has taken the Microsoft requirements and considered that Excel has many formulas and functions and transformed the requirements in to 71 trained tasks that you will do when signed in to GMetrix. I have made videos to assist you with the 71 tasks in the GMetrix training. There are hyperlinks to each domain and the video training in the box below.
Excel 201 Domain 1: Manage Workbook Options & Settings
MO-201 Excel 2019 Expert Domain 1: Manage Workbook Options & Settings |
Tasks |
3 |
|
6 |
|
9 |
Excel 201 Domain 2: Manage & Format Data
MO-201 Excel 2019 Expert Domain 2: Manage & Format Data |
Tasks |
2 |
|
6 |
|
3 |
|
11 |
Excel 201 Domain 3: Create Advanced Formulas and Macros
MO-201 Excel 2019 Expert Domain 3: Create Advanced Formulas & Macros |
Tasks |
14 |
|
14 |
|
5 |
|
33 |
Excel 201 Domain 4: Manage Advanced Charts & Tables
MO-201 Excel 2019 Expert Domain 4: Manage Advanced Charts & Tables |
Tasks |
8 |
|
10 |
|
18 |