Advanced Charts & PivotTables

This module is where your Excel work becomes presentation-grade and decision-ready. The MO-211 exam expects you to go beyond "insert a chart" and prove you can choose the right visualization, tune it for clarity, and build interactive summaries using PivotTables and PivotCharts.

You'll master advanced chart types that test both your technical control and your data storytelling—especially dual-axis (secondary axis) visuals and modern statistical/relationship charts like Box & Whisker, Histogram, Waterfall, Funnel, Combo, and Sunburst. You'll also learn Sparklines for inline cell-level visualization and Trendlines for forecast and pattern analysis.

Then we shift into Excel's analytical powerhouse: PivotTables. You'll learn how to construct them properly, refine field layouts, add slicers and timelines for interactive filtering, group data into meaningful buckets, create calculated fields, and tune Value Field Settings to express insights as running totals, percentages, ranks, and more. Finally, you'll turn those PivotTables into PivotCharts, style them consistently, and drill into the underlying details when a number looks suspicious or needs explanation.

By the end of this module, you won't just "make charts"—you'll build interactive dashboards and analytical reports that look like they came out of a finance or BI team.

✅ What You Must Be Able To Do (Exam Lens)

Advanced Charts

• Build and correctly label dual-axis charts (secondary axis).
• Create and modify: Box & Whisker, Combo, Funnel, Histogram (Pareto), Sunburst, Waterfall.
• Insert and format Sparklines (Line / Column / Win-Loss).
• Add Trendlines with forecast and R² display.

PivotTables

• Create PivotTables from ranges and Tables; refine field layout quickly.
• Add slicers and timelines, group data, add calculated fields.
• Configure Value Field Settings and Show Values As.
• Use Show Details and GETPIVOTDATA.

PivotCharts

• Create, style, adjust options, and drill into details confidently.