ExamFinch.com My Study

Study guide

MO-211 study guide

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

Practice this exam

Lessons

  1. Advanced Filtering with Complex Criteria Ran
  2. Formula-Based Conditional Formatting & Logic
  3. Data Bars, Color Scales, Icon Sets, & Rule H
  4. Advanced Fill Series — Free Microsoft Excel Expert Guide 2026
  5. Dynamic Sequence & Random Data Generation
  6. Flash Fill Patterns & Text Extraction Techni
  7. Formula Optimization & Variable Assignment w
  8. Classic Matrix & Two-Way Lookups: INDEX & MA
  9. Modern Lookups with XLOOKUP & XMATCH — Free Study Guide 2026
  10. Distribution & Multi-Axis Charts: Box & Whis
  11. Hierarchy & Financial Visualizations: Waterf
  12. Statistical Visualizations: Histograms & Par
  13. Custom Number Formatting Syntax & Masking Ru
  14. Data Validation Criteria & Custom Formula Ru
  15. Validation Input Messages, Error Alerts, & D
  16. Summarizing Multiple Ranges with the Consoli
  17. Financial Modeling Functions: PMT, NPER, & F
  18. What-If Analysis: Goal Seek & Scenario Manag
  19. Data Grouping, Ungrouping, & Multi-Level Out
  20. Duplicate Record Removal & Text-to-Columns C
  21. Subtotal Insertion & Summary Function Calcul
  22. Business Date Calculations: WORKDAY, NETWORK
  23. Current Date, Time, & Day-of-Week Functions:
  24. Error Handling & Formula Auditing Tools
  25. Modern Text Extraction & Array Splitting: TE
  26. Array Filtering & Extraction: FILTER Functio
  27. Deduplication & Sequence Arrays: UNIQUE & Ar
  28. Multi-Level Sorting: SORT & SORTBY Functions
  29. Compound Boolean Logic: AND, OR, NOT, & XOR
  30. Multi-Criteria Aggregations: SUMIFS, COUNTIF
  31. Nested IF, IFS, & SWITCH Logical Structures
  32. Macro Storage, Shortcut Assignment, & Form C
  33. Managing & Modifying VBA Code in the Visual
  34. Recording Macros with Absolute vs. Relative
  35. External Data Referencing & Cross-Workbook F
  36. Macro Security, Portability, & Workbook Dist
  37. Workbook Versioning, AutoRecover, & File Pro
  38. MO-211 Exam Structure, Scoring, & Performanc
  39. Excel Environment & Microsoft 365 Architectu
  40. Field Summarization, Number Formatting, & Cu
  41. PivotTable Data Architecture, Layouts, & Sty
  42. Value Display Modes: % of Total, Running Tot
  43. Calculated Fields & Calculated Items in Pivo
  44. Date & Numeric Field Grouping Strategies
  45. Slicers, Timelines, Report Connections, & Pi
  46. Formula Calculation Options & Iterative Calc
  47. Cell Locking, Range Permissions, & Worksheet
  48. Workbook Structure Protection & Editing Rest