MO-210: Microsoft Excel - Revision Guide

The MO-210 certification is the new certification for Excel. Microsoft says that this certification demonstrates that you have the skills needed to get the most out of Excel by earning a Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) certification.

This is for you if you are preparing for the MO-210 certification, or want to see how your skills compare with the Microsoft certification.

We will quickly revise the following - we'll spend an average of about 40 seconds on each topic:

Manage worksheets and workbooks. This comprises of:

• Import data into workbooks

• Navigate within workbooks

• Format worksheets and workbooks

• Prepare workbooks for collaboration and distribution

Manage data cells and ranges. This comprises of:

• Manipulate data in worksheets

• Format cells and ranges

• Define and reference named ranges

• Summarize data visually

Manage tables and table data. This comprises of:

• Create and format tables

• Modify tables

• Filter and sort table data

Perform operations by using formulas and functions. This comprises of:

• insert references

• calculate and transform data format and

• modify text

Manage charts. This comprises of:

• create charts

• modify charts

• format charts

Once you have completed the course, you will see how your knowledge of Microsoft Excel compares with the official MO-210 exam. If you are confident in your skills, then you could even take the official Microsoft MO-210 exam, which gives you the "Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)" certificate. This would look good on your CV or resume.

It is also the first stage to you getting the "Microsoft Office Specialist: Associate (Microsoft 365 Apps)" certification.