Introduction
  • Introduction
  • Chart Types - Which chart should I use?
  • Chart Types - Which chart should I use?
  • Chart Types
  • Course Datasets
General Tools
  • Excel Basic Tools - Insert Tab
  • Our First Chart - Pie Charts
  • Excel Basic Tools - Design Tab
  • Excel Basic Tools - Chart Buttons
  • Chart Axes
  • Exercise - Editing Tools
Chart Types in Detail
  • Pie of a Pie Chart
  • Doughnut Charts
  • Scatterplots
  • Bubble Charts
  • Line Charts
  • Area Charts
  • Exercise - Lynx Trappings
  • Column or Bar Charts - Paired Data
  • Dynamic Charts with Tables
Bonus Lectures: New Chart Types in Excel 2016
  • Introduction to New Charts
  • Statistical Charts 1: Histogram
  • Histogram - alternative method
  • Statistical Charts 2: Pareto Chart
  • Pareto Chart - alternative method
  • Statistical Charts 3: Box and Whisker Plot
  • Hierarchical Charts 1: Treemap
  • Hierarchical Charts 2: Sunburst
  • Which one should I choose? Treemap vs. Sunburst
  • Finance: Waterfall Chart
  • Waterfall Chart - alternative method