Course curriculum
-
1
Welcome to the course!
- Instructor bio - John Bura
- Key pointers for this program
- Joining the Alumni Community
-
2
Introduction to the Course
- Segment - 01 - Introduction to the Course
- Segment - 02 - Why should you learn about Charts and Data Visualization
- Segment - 03 - Introduction of the Instructor
- Segment - 04 - Course Requirements (what software, experience)
-
3
Charts and Basics
- Segment - 05 - What will we learn in this section
- Segment - 06 - Main Principles and Chart Visualization Impact
- Segment - 07 - Choosing the Correct Chart
- Segment - 08 - Communicate with the End User
- Segment - 09 - Section Summary
- Segment - 10 - Challenge
-
4
Excel Chart Tools
- Segment - 12 - Chart Design
- Segment - 13 - Working with Chart Formats
- Segment - 14 - Chart Types
- Segment - 15 - Primary and Secondary Axis
- Segment - 15A
- Segment - 16 - Chart Templates
- Segment - 17 - Section Summary
- Segment - 18 - Challenge
-
5
Working with Basic Excel Charts & Graphs
- Segment - 19 - What will we learn in this section
- Segment - 20 - Excel Column Charts
- Segment - 21 - Column Charts Challenge
- Segment - 22 - Excel Bar Charts
- Segment - 23 - Excel Bar Charts 1
- Segment - 24 - Bar Charts Challenge
- Segment - 25 - Excel Line Charts
- Segment - 26 - Line Charts Challenge
- Segment - 27 - Excel Pie Charts
- Segment - 28 - Pie Charts Challenge
- Segment - 29 - Excel Area Charts
- Segment - 30 - Area Charts Challenge
- Segment - 31 - Excel Scatter Charts
- Segment - 32 - Scatter Charts Challenge
- Segment - 33 - Excel Bubble Charts
- Segment - 34 - Bubble Charts Challenge
- Segment - 35 - Excel Stock Charts
- Segment - 36 - Stock Charts Challenge
- Segment - 37 - Excel Surface Charts
- Segment - 38 - Surface Charts Challenge
- Segment - 39 - Excel Radar Charts
- Segment - 40 - Radar Charts Challenge
- Segment - 41 - Excel Treemap Charts
- Segment - 42 - Treemap Charts Challenge
- Segment - 43 - Excel Sunburst Charts
- Segment - 44 - Sunburn Charts Challenge
- Segment - 45 - Excel Histogram and Pareto Charts
- Segment - 46 - Histogram and Pareto Charts Challenge
- Segment - 47 - Excel Waterfall Charts
- Segment - 48 - Waterfall Charts Challenge
- Segment - 49 - Excel Box & Whisker Charts
- Segment - 51 - Excel Sparklines
- Segment - 52 - Sparklines Challenge
- Segment - 53 - Excel Color Scales
- Segment - 54 - Color Scales Challenge
- Segment - 55 - Excel 3D Map
- Segment - 56 - 3D Map Challenge
- Segment - 57 - Section Summary
-
6
Excel Advanced Data Visualization
- Segment - 58 - What will we learn in this section
- Segment - 59 - Data Visualization with Pivot Chart and Slicers
- Segment - 60 - Data Visualization with Pivot Chart and Slicers Challenge
- Segment - 61 - Create Break Even Chart
- Segment - 62 - Challenge Create Break Even Chart
- Segment - 63 - Rating Star Chart
- Segment - 64 - Challenge Rating Star Chart
- Segment - 65 - Drop Down Menu for Chart
- Segment - 66 - Challenge Drop Down Menu for Chart
- Segment - 67 - Risk Score Chart
- Segment - 68 - Risk Score Chart Challenge
- Segment - 69 - Dynamic Chart Update
- Segment - 70 - Challenge Dynamic Chart Update
- Segment - 71 - Section Summary
-
7
Conclusion
- Segment - 72 - Course Summary and Next Steps