Microsoft Excel 365 Apps MO-210 — Lesson 2: Data, Tables, and Formulas

Topics Covered

• cell references
• core functions
• tables and structured references
• sorting and filtering

Practical Activity

• Document the scenario, assumptions, stakeholders, and expected business or technical outcome.
• Complete a guided configuration, analysis, or design exercise aligned to the lesson topics.
• Record validation evidence, risks, dependencies, and corrective actions.
• Summarize the result in a reusable implementation or operating note.

Validation Checklist

• Requirements and assumptions are clearly documented.
• The selected Microsoft features or services match the scenario.
• Security, governance, and operational impacts are considered.
• The final result includes evidence and actionable next steps.

Lesson Outcome

Learners can explain and apply data, tables, and formulas within a realistic Excel 365 skills aligned to MO-210 scenario.