Tabellab
Excel Beginner

Excel Charts & Data Visualization

Column, bar, line, pie, stacked, combo, scatter, histogram and waterfall charts plus conditional formatting and sparklines: 10 hands-on labs, every chart checked by the Coach.

10 lessons 10 labs 2.7 h Certificate

The first 2 lessons are free — no account needed.

About this course

An Excel charts course where you build every chart yourself and the coach checks it: chart type, data range, titles, axes and sort order. You learn which chart answers which question, then make column and bar, line and area, pie and doughnut, stacked and 100% stacked charts, combo charts with a secondary axis, scatter plots with trendlines, histograms and waterfall charts, and finish with conditional formatting, sparklines and a mini dashboard. The first two labs are free.

Lessons

  1. Choosing the Right Chart: Column, Line, Pie or Bar?Lab14 minFree
  2. Column & Bar Charts Done Right: Sorted, Labelled, TitledLab15 minFree
  3. Line & Area Charts for Trends: Two Years, One AxisLab15 min Pro
  4. Pie & Doughnut Charts: When They Work (and When They Don't)Lab14 min Pro
  5. Stacked & 100% Stacked Charts: Composition Over TimeLab16 min Pro
  6. Combo Charts & the Secondary Axis: Revenue and Margin TogetherLab16 min Pro
  7. Scatter Plots & Trendlines: Does Warm Weather Sell Cold Brew?Lab16 min Pro
  8. Histograms & Distributions: How Big Is a Typical Order?Lab17 min Pro
  9. Waterfall Charts: The Bridge From Last Year's Profit to This Year'sLab17 min Pro
  10. Conditional Formatting, Sparklines & a Mini DashboardLab20 min Pro