About this Course

48,593 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level

We expect that you have some background with Excel. You can move around the interface and create basic formulas.

Approx. 18 hours to complete
English

Skills you will gain

Microsoft ExcelData Visualization (DataViz)
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level

We expect that you have some background with Excel. You can move around the interface and create basic formulas.

Approx. 18 hours to complete
English

Offered by

Placeholder

Macquarie University

Syllabus - What you will learn from this course

Week
1

Week 1

1 hour to complete

Welcome and critical information

1 hour to complete
1 video (Total 3 min), 3 readings
1 video
3 readings
Welcome to Data Visualization in Excel 15m
Course goals and weekly learning objectives10m
Important information about versions and regions10m
3 hours to complete

Data Visualizations using Conditional Formatting, Sparklines and Number Formats

3 hours to complete
6 videos (Total 49 min), 4 readings, 5 quizzes
6 videos
Trend-based conditional formats6m
Value-based conditional formats7m
Macros for interactive visualizations9m
Visualizations with Sparklines and Shapes10m
Custom number formats9m
4 readings
Read me before you start: Quizzes and Navigation10m
Download the Week 1 workbooks5m
Week 1 Practice Challenge30m
Week 1 Toolbox10m
5 practice exercises
Trend-based conditional formats10m
Value-based conditional formats10m
Macros for interactive visualizations10m
Visualizations with Sparklines and Shapes10m
Custom number formats10m
Week
2

Week 2

3 hours to complete

Mastering charting techniques

3 hours to complete
6 videos (Total 51 min), 3 readings, 6 quizzes
6 videos
Charting techniques9m
Pies and doughnuts9m
Line charts and trendlines9m
Area charts8m
Scatter and bubble charts10m
3 readings
Download the Week 2 workbooks5m
Week 2 Practice Challenge30m
Week 2 Toolbox10m
6 practice exercises
Charting techniques10m
Pies and doughnuts10m
Line charts and trendlines10m
Area charts10m
Scatter and bubble charts10m
Test your skills: Weeks 1 and 245m
Week
3

Week 3

3 hours to complete

Specialized charts

3 hours to complete
6 videos (Total 49 min), 3 readings, 5 quizzes
6 videos
Hierarchy charts 7m
Waterfall and funnel charts6m
Geospatial charts7m
Custom chart techniques - population charts9m
Creative chart techniques - gauge charts13m
3 readings
Download the Week 3 workbooks5m
Week 3 Practice Challenge30m
Week 3 Toolbox10m
5 practice exercises
Hierarchy charts 10m
Waterfall and funnel charts10m
Geospatial charts 10m
Custom chart techniques - population charts10m
Creative chart techniques - gauge charts10m
Week
4

Week 4

4 hours to complete

Create an Interactive Dashboard Using Pivot Charts and Slicers

4 hours to complete
7 videos (Total 68 min), 3 readings, 7 quizzes
7 videos
Summarise data with PivotTables10m
Customise PivotTables10m
Group and sort pivot data10m
Filter pivot data8m
Perform calculations in pivots11m
PivotCharts and other visualizations10m
3 readings
Download the Week 4 workbooks5m
Week 4 Practice Challenge30m
Week 4 Toolbox10m
7 practice exercises
Summarise data with PivotTables10m
Customise PivotTables10m
Group and sort pivot data10m
Filter pivot data10m
Perform calculations in pivots10m
PivotCharts and other visualizations10m
Test your skills: Weeks 3 and 445m

Reviews

TOP REVIEWS FROM DATA VISUALIZATION IN EXCEL

View all reviews

Frequently Asked Questions

More questions? Visit the Learner Help Center.