Exam Preparation: MS Office Specialist (MOS) Excel 365 Expert (MO-211) («MO211»)

• Understanding the relevant formulas and functions to pass the Microsoft Office Specialist (MOS) Excel 365 Expert (MO-211) exam
• Knowing tips and tricks for a successful MOS exam

In this course, you will learn the skills necessary to successfully pass the MOS Excel 365 Expert (MO-211) exam:

1 Managing workbook options and settings

• Managing workbooks
• Preparing workbooks for collaboration

2 Managing and formatting data

• Filling cells based on existing data (including Flash Fill, Fill Series and RANDARRAY())
• Formatting and validating data
• Applying advanced conditional formatting and filtering

3 Creating advanced formulas and macros

• Performing logical operations in formulas (including nested functions with IF(), IFS(), FIRSTVALUE(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), NOT(), and LET())
• Look up data using functions (including XLOOKUP(), VLOOKUP(), HLOOKUP(), MATCH(), and INDEX())
• Using advanced date and time functions (including NOW(), TODAY(), WEEKDAY(), and WORKDAY())
• Performing data analysis (including consolidate, goal seek and scenario manager, AND(), IF(), ZZR(), RMZ(), FILTER() and SORTBY())
• Troubleshooting formulas
• Creating and modifying simple macros

4 Managing advanced charts and tables

• Creating and modifying advanced charts (including box plots, combo charts, funnel charts, histograms, sunburst charts and waterfall charts)
• Creating and modifying pivot tables
• Creating and modifying pivot charts

This part-time course comprises 4.5 practical course days with an experienced trainer. You will learn the necessary formulas, functions and work steps to successfully pass the ‘MOS Excel 365 Expert (MO-211)’ exam.

Between course days, you will reinforce what you have learned through targeted exercises. The time required for this varies depending on your prior knowledge, but is usually 3 to 8 hours per week.

On the last day of the course, there will be an exam workshop. Here you will familiarise yourself with typical exam questions, clarify any open points and then take the official MOS exam.

You work regularly with Microsoft Excel and would like to deepen your data management and analysis skills. You would also like to reinforce your newly acquired knowledge and skills with an internationally recognised Microsoft Excel certification and open up new career opportunities.

This course requires certain prior knowledge and prerequisites; please check the requirements (below) to ensure that this course is suitable for you.

• You have passed the Microsoft Office Specialist (MOS) Excel 365 (MO-210) associate exam
• You work regularly with Microsoft Excel (ideally already with Microsoft Excel 365)

We recommend attending the following course in preparation:

This course prepares you for the Microsoft Office Specialist (MOS) Excel 365 Expert (MO-211) exam. The exam fee is included in the course price.

You can take the exam at one of our authorised test centers on the last day of the course.

Please note that MOS exams cannot be taken at home or in any other private setting.