MO-210 Preparation Details
Preparing for the MO-210 Microsoft Excel (Microsoft 365 Apps) exam? Don’t know where to start? This post is the MO-210 Certificate Study Guide (with links to each exam objective).
I have curated a list of articles from Microsoft documentation for each objective of the MO-210 exam. Please share the post within your circles so it helps them to prepare for the exam.
Exam Voucher for MO-210 with 1 Retake
Get 40% OFF with the combo
MO-210 Microsoft Excel Study Material
| Udemy | MO-210 prep: Microsoft Excel |
| Practice Test | Azure Administrator Practice Test |
Manage worksheets and workbooks (25–30%)
Import data into workbooks
Import data from text files
Text/CSV connector (Power Query) (Microsoft Learn)
Import or export text (.txt or .csv) files
Import data from online sources
Power Query Web connector (Microsoft Learn)
Extract data from a web page by example (Power Query) (Microsoft Learn)
Navigate within workbooks
Search for data within a workbook
Excel – Using Find & Replace (GCFGlobal/Kolibri)
How to find and replace a value (Exceljet)
Navigate to named cells, ranges, or workbook elements
Named ranges in Excel (Exceljet)
Insert and remove hyperlinks
Insert a hyperlink in Excel (YouTube)
Removing hyperlinks in Excel (Journal of Accountancy)
Format worksheets and workbooks
Modify page setup
Excel page setup: margins, headers, orientation (YouTube)
Defining page setup options (GCFGlobal/Kolibri)
Adjust row height and column width
How to change column widths in Excel (Exceljet)
How to change row heights in Excel (Exceljet)
Customize headers and footers
Excel header and footer: how to add, change and remove (Ablebits)
Headers and footers via Page Setup (GCFGlobal/Kolibri)
Customize options and views
Freezing panes and view options (GCFGlobal/Kolibri)
Excel Easy (Excel basics and examples)
Manage the Quick Access toolbar
Quickly customize the Quick Access Toolbar (YouTube)
Microsoft Excel Quick Access Toolbar (YourOnline.Training)
Display and modify worksheets in different views
Page Layout view and commands in Excel (YouTube)
Workbook views overview (GCFGlobal/Kolibri)
Freeze worksheet rows and columns
Freeze panes (GCFGlobal/Kolibri)
Freeze panes in Excel (Excel Easy)
Change window views
Freeze panes and split / view options (GCFGlobal/Kolibri)
Previewing Excel print layout (Page Layout view) (YouTube)
Modify built-in workbook properties
Properties – Excel workbooks (BetterSolutions)
Set advanced file properties in Excel workbooks (YouTube)
Display formulas
Show formulas in Excel (Excel Easy)
Excel shows formula, not result (Show Formulas mode) (Exceljet)
Prepare workbooks for collaboration and distribution
Set a print area
Set a header, footer and print area in an Excel worksheet (Wise Owl)
How to set the print area in Excel (YouTube)
Save and export workbooks in alternative file formats
Excel Easy (File basics and saving concepts)
Excel training library (CustomGuide)
Configure print settings
Excel page layout and printing (YouTube)
Page setup options for printing (GCFGlobal/Kolibri)
Inspect workbooks and correct issues
Inspect a workbook (Document Inspector / accessibility) (CustomGuide)
Remove hidden data in Microsoft Excel (Marquette University IT)
Manage comments and notes
Keep notes on Excel formulas and macros (Contextures)
Excel training library (Comments/notes topics) (CustomGuide)
Manage data cells and ranges (25–30%)
Manipulate data in worksheets
Paste data by using special paste options
Excel keyboard shortcuts (includes Paste Special) (Exceljet)
Excel training library (Paste Special topics) (CustomGuide)
Fill cells by using Auto Fill
Basic tips for working with data (includes fill handle concepts) (GCFGlobal/Kolibri)
Excel Easy (AutoFill-related examples) (Excel Easy)
Insert and delete multiple columns or rows
Shortcuts to insert/delete rows and columns (Exceljet)
Excel shortcuts (insert/delete rows/columns) (Exceljet)
Insert and delete cells
Insert/delete cells via Insert/Delete dialog (Exceljet)
Excel shortcuts (insert/delete cells) (Exceljet)
Generate numeric data by using RANDBETWEEN() and SEQUENCE()
Excel RANDBETWEEN function (Exceljet)
Excel SEQUENCE function (Exceljet)
Format cells and ranges
Merge and unmerge cells
Merge cells in Excel (Excel Easy)
How to merge cells in Excel (CustomGuide)
Modify cell alignment, orientation, and indentation
Excel Easy (Alignment/orientation basics and examples) (Excel Easy)
Excel training library (Alignment topics) (CustomGuide)
Format cells by using Format Painter
Excel shortcuts (formatting workflow helpers) (Exceljet)
Wrap text within cells
Wrap text in Excel (Excel Easy)
Wrap text in Excel guide (GeeksforGeeks)
Apply number formats
Excel Easy (Number formatting examples) (Excel Easy)
Excel training library (Number formats topics) (CustomGuide)
Apply cell formats from the Format Cells dialog box
Excel Easy (Format Cells dialog examples) (Excel Easy)
Excel training library (Format Cells dialog) (CustomGuide)
Apply cell styles
Excel Easy (Cell styles and formatting examples) (Excel Easy)
Excel training library (Styles topics) (CustomGuide)
Clear cell formatting
Excel Easy (Clear formats basics) (Excel Easy)
Excel training library (Clear formatting topics) (CustomGuide)
Format multiple worksheets by grouping
Excel Easy (Working with multiple sheets) (Excel Easy)
Excel training library (Group sheets topics) (CustomGuide)
Define and reference named ranges
Define a named range
Named ranges in Excel (Exceljet)
Named range (definition and examples) (Exceljet)
Reference a named range
Named range (using names in formulas) (Exceljet)
Name Manager (managing and updating names) (Exceljet)
Summarize data visually
Insert Sparklines
Customize sparklines (includes inserting/removing concepts) (Pryor)
Conditional formatting and sparklines overview (YouTube)
Apply built-in conditional formatting
Conditional formatting in Excel (Excel Easy)
Excel conditional formatting tutorial (Ablebits)
Remove conditional formatting
Manage conditional formatting rules (edit/delete/clear) (Excel Easy)
How to delete conditional formatting rules (Exceljet)
Manage tables and table data (10–15%)
Create and format tables
Create Excel tables from cell ranges
Create tables in Excel (Excel Easy)
Excel tables (deep dive) (Exceljet)
Apply table styles
How to apply a table style (Exceljet)
Excel tables (styles and design options) (Exceljet)
Convert tables to cell ranges
Excel tables (convert/remove table features) (Exceljet)
Tables (working with and removing table features) (Excel Easy)
Modify tables
Add or remove table rows and columns
Excel tables (adding rows/columns behavior) (Exceljet)
Tables (adding/removing rows/columns) (Excel Easy)
Configure table style options
Table style options (banded rows, header row, total row) (Excel Easy)
How to apply a table style (Exceljet)
Insert and configure total rows
Total row in Excel tables (Excel Easy)
How to add and configure a totals row (Exceljet)
Filter and sort table data
Filter records
Filtering data (GCFGlobal/Kolibri)
Use AutoFilter to sort and filter Excel data (Global TS)
Sort data by multiple columns
Sorting data (GCFGlobal/Kolibri)
Find & Select basics (includes sorting entry points) (Excel Easy)
Perform operations by using formulas and functions (15–20%)
Insert references
Insert relative, absolute, and mixed references
Shortcuts for formulas (includes relative/absolute reference tips) (Exceljet)
Formulas and functions in Excel (Excel Easy)
Use structured references in formulas
Structured reference (Exceljet)
Introduction to structured references (Exceljet)
Calculate and transform data
Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
Excel functions reference (Exceljet)
Formulas and functions overview (Excel Easy)
Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
Excel functions reference (Exceljet)
Excel formulas examples (Exceljet)
Perform conditional operations by using the IF() function
IF formula examples (Exceljet)
Sort data by using the SORT() function
Excel SORT function (Exceljet)
SORT formula examples (Exceljet)
Get unique values by using the UNIQUE() function
Excel UNIQUE function (Exceljet)
UNIQUE formula examples (Exceljet)
Format and modify text
Format text by using RIGHT(), LEFT(), and MID() functions
Excel functions reference (RIGHT/LEFT/MID) (Exceljet)
Text formula examples (Exceljet)
Format text by using UPPER(), LOWER(), and LEN() functions
Excel functions reference (UPPER/LOWER/LEN) (Exceljet)
Text cleanup examples (Exceljet)
Format text by using the CONCAT() and TEXTJOIN() functions
Excel TEXTJOIN function (Exceljet)
Excel CONCAT function (Exceljet)
Manage charts (15–20%)
Create charts
Create charts
How to create a chart or graph in Excel (Microsoft) (YouTube)
Excel chart examples and steps (Exceljet)
Create chart sheets
Core charts training (includes chart sheets workflows) (Exceljet)
Excel chart examples (use cases for chart sheets) (Exceljet)
Modify charts
Add data series to charts
Core charts training (series editing topics) (Exceljet)
How to add chart elements and edit charts (YouTube)
Switch between rows and columns in source data
Core charts training (source data orientation) (Exceljet)
Chart examples (adjusting data sources) (Exceljet)
Add and modify chart elements
How to add and remove chart elements (Exceljet)
Chart elements and layouts (Exceljet)
Format charts
Apply chart layouts
Chart elements and layouts (Exceljet)
Core charts training (layout and formatting lessons) (Exceljet)
Apply chart styles
Chart colors and styles (Exceljet)
Core charts training (styling lessons) (Exceljet)
Add alternative text to charts for accessibility
Accessibility checker and related fixes (CustomGuide)
Inspect and fix Excel documents (accessibility checks) (ADA Nevada PDF)
This brings us to the end of the MO-210 Microsoft Excel (Microsoft 365 Apps) Study Guide.
What do you think? Let me know in the comments section if I have missed out on anything. Also, I love to hear from you about how your preparation is going on!
In case you are preparing for other Azure certification exams, check out the Azure study guide for those exams.
Follow Me to Receive Updates on the MO-210 Exam
Want to be notified as soon as I post? Subscribe to the RSS feed / leave your email address in the subscribe section. Share the article to your social networks with the links below so it can benefit others.