Course curriculum

  • 1

    Welcome to the course!

  • 2

    Visualization best practices

  • 3

    Excel charting principles and advice

  • 4

    Charting tools and techniques

    • Line chart

    • Two Data Sets

    • Area Chart

    • Logarithmic Scale

    • Column Chart Part 1

    • Column Chart Part 2 - Highlight Top Column Dynamically

    • Bar Chart

    • Combo Chart using Secondary Axis

    • Pie Chart

    • Doughnut Chart

    • Progress Doughnut

    • In-cell Charts Sparkline

    • Top and Bottom Ranking

    • Grade Distribution

    • Target vs Actual vs Variance Chart

    • Median Chart

    • Bullet Chart

    • Scatter

    • Bubble

    • Bubble

    • Waterfall Chart

    • Treemap

    • Sunburst

    • Histogram

    • Pareto

  • 5

    Create the dashboard

    • Part 1 - Introduction

    • Part 2 - Create Pivot Reports

    • Part 3 - Continue with Pivot Reports

    • Part 4 - Create Pivot Charts

    • Part 5 - Create the Dashboard

    • Part 6 - Add Slicers and Make it Dynamic

  • 6

    Congratulations....

    • Congratulations