Study guide

MO-210 study guide

Read a lesson, then practice the ideas you want to remember.

Lessons

  1. COUNT, COUNTA, and COUNTBLANK — Free Study Guide 2026
  2. Conditional Operations with IF — Free Study Guide 2026
  3. SORT and UNIQUE Functions — Free Microsoft Excel Guide 2026
  4. SUM, AVERAGE, MIN, and MAX — Free Microsoft Excel Guide 2026
  5. Create Chart Sheets — Free Microsoft Excel Guide 2026
  6. Create Charts from Data — Free Microsoft Excel Guide 2026
  7. Create Excel Tables from Cell Ranges — Free Study Guide 2026
  8. Add or Remove Table Rows and Columns — Free Study Guide 2026
  9. Apply Table Styles and Convert Tables to Ran
  10. Merge, Alignment, Orientation, Indentation,
  11. Number Formats, Format Painter, Format Cells
  12. Cell Styles, Clear Formatting, Group Workshe
  13. Print Area, Export Formats, Print Settings,
  14. Quick Access Toolbar, Views, Freeze Panes, P
  15. Page Setup, Headers, Footers, Row Height & C
  16. Relative, Absolute, and Mixed References
  17. Structured References in Tables — Free Study Guide 2026
  18. Insert and Remove Hyperlinks — Free Microsoft Excel Guide 2026
  19. Import Data from Online Sources — Free Study Guide 2026
  20. Import Data from Text Files — Free Microsoft Excel Guide 2026
  21. Search and Navigate to Named Cells, Ranges,
  22. About the MO-210 Exam — Free Microsoft Excel Guide 2026
  23. Performance-Based Exam Strategy — Free Study Guide 2026
  24. Insert and Delete Rows, Columns, and Cells
  25. Paste Special and Auto Fill — Free Microsoft Excel Guide 2026
  26. Generate Numeric Data with RANDBETWEEN and S
  27. Add and Modify Chart Elements — Free Study Guide 2026
  28. Chart Layouts, Styles, and Alternative Text
  29. Add Data Series and Switch Rows/Columns
  30. Apply and Remove Conditional Formatting
  31. Define and Reference Named Ranges — Free Study Guide 2026
  32. Insert and Manage Sparklines — Free Microsoft Excel Guide 2026
  33. Filter Table Records — Free Microsoft Excel Guide 2026
  34. Sort Data by Multiple Columns — Free Study Guide 2026
  35. Configure Table Style Options — Free Study Guide 2026
  36. Insert and Configure Total Rows — Free Study Guide 2026
  37. UPPER, LOWER, LEN, CONCAT, and TEXTJOIN
  38. LEFT, RIGHT, and MID — Free Microsoft Excel Guide 2026