Study guide
MO-210 study guide
Read a lesson, then practice the ideas you want to remember.
Lessons
- COUNT, COUNTA, and COUNTBLANK — Free Study Guide 2026
- Conditional Operations with IF — Free Study Guide 2026
- SORT and UNIQUE Functions — Free Microsoft Excel Guide 2026
- SUM, AVERAGE, MIN, and MAX — Free Microsoft Excel Guide 2026
- Create Chart Sheets — Free Microsoft Excel Guide 2026
- Create Charts from Data — Free Microsoft Excel Guide 2026
- Create Excel Tables from Cell Ranges — Free Study Guide 2026
- Add or Remove Table Rows and Columns — Free Study Guide 2026
- Apply Table Styles and Convert Tables to Ran
- Merge, Alignment, Orientation, Indentation,
- Number Formats, Format Painter, Format Cells
- Cell Styles, Clear Formatting, Group Workshe
- Print Area, Export Formats, Print Settings,
- Quick Access Toolbar, Views, Freeze Panes, P
- Page Setup, Headers, Footers, Row Height & C
- Relative, Absolute, and Mixed References
- Structured References in Tables — Free Study Guide 2026
- Insert and Remove Hyperlinks — Free Microsoft Excel Guide 2026
- Import Data from Online Sources — Free Study Guide 2026
- Import Data from Text Files — Free Microsoft Excel Guide 2026
- Search and Navigate to Named Cells, Ranges,
- About the MO-210 Exam — Free Microsoft Excel Guide 2026
- Performance-Based Exam Strategy — Free Study Guide 2026
- Insert and Delete Rows, Columns, and Cells
- Paste Special and Auto Fill — Free Microsoft Excel Guide 2026
- Generate Numeric Data with RANDBETWEEN and S
- Add and Modify Chart Elements — Free Study Guide 2026
- Chart Layouts, Styles, and Alternative Text
- Add Data Series and Switch Rows/Columns
- Apply and Remove Conditional Formatting
- Define and Reference Named Ranges — Free Study Guide 2026
- Insert and Manage Sparklines — Free Microsoft Excel Guide 2026
- Filter Table Records — Free Microsoft Excel Guide 2026
- Sort Data by Multiple Columns — Free Study Guide 2026
- Configure Table Style Options — Free Study Guide 2026
- Insert and Configure Total Rows — Free Study Guide 2026
- UPPER, LOWER, LEN, CONCAT, and TEXTJOIN
- LEFT, RIGHT, and MID — Free Microsoft Excel Guide 2026