Mastering Excel Data Visualization: Static Charts & Graphs

Focused View

DataRiel Academy

3:05:12

127 View

1. Introduction

1. Introduction.mp4

01:00

2. Column Chart

1. Intro_Column Chart.mp4

02:48

2. Column Chart.mp4

05:11

3.1 Handout_Column Chart.pdf

3. Handout_Column Chart.html

4.1 Exercise_Column Chart.xlsx

4. Exercise_Column Chart.html

3. Bar Chart

1. Intro_Bar Chart.mp4

02:55

2. Bar Chart.mp4

05:52

3.1 Handout_Bar Chart.pdf

3. Handout_Bar Chart.html

4.1 Exercise_Bar Chart.xlsx

4. Exercise_Bar Chart.html

4. Line Chart

1. Intro_Line Chart.mp4

03:10

2. Line Chart.mp4

07:58

3.1 Handout_Line Chart.pdf

3. Handout_Line Chart.html

4.1 Exercise_Line Chart.xlsx

4. Exercise_Line Chart.html

5. Pie Chart

1. Intro_Pie Chart.mp4

02:57

2. Pie Chart.mp4

04:44

3.1 Handout_Pie Chart.pdf

3. Handout_Pie Chart.html

4.1 Exercise_Pie Chart.xlsx

4. Exercise_Pie Chart.html

6. Waterfall Chart

1. Intro_Waterfall Chart.mp4

02:25

2. Waterfall Chart.mp4

03:11

3.1 Handout_Waterfall Chart.pdf

3. Handout_Waterfall Chart.html

4.1 Exercise_Waterfall Chart.xlsx

4. Exercise_Waterfall Chart.html

7. Candlestick Chart

1. Intro_Candlestick Chart.mp4

03:00

2. Candlestick Chart.mp4

04:33

3.1 Handout_Candlestick Chart.pdf

3. Handout_Candlestick Chart.html

4.1 Exercise-Candlestick Chart.xlsx

4. Exercise_Candlestick Chart.html

8. Area Chart

1. Intro_Area Chart.mp4

03:05

2. Area Chart.mp4

04:32

3.1 Handout_Area Chart.pdf

3. Handout_Area Chart.html

4.1 Exercise_Area Chart.xlsx

4. Exercise_Area Chart.html

9. Scatter Plot

1. Intro_Scatter Plot.mp4

02:51

2. Scatter Plot.mp4

04:14

3.1 Handout_Scatter Plot.pdf

3. Handout_Scatter Plot.html

4.1 Exercise_Scatter Plot.xlsx

4. Exercise_Scatter Plot.html

10. Bubble Chart

1. Intro_Bubble Chart.mp4

03:15

2. Bubble Chart.mp4

06:21

3.1 Handout_Bubble Chart.pdf

3. Handout_Bubble Chart.html

4.1 Exercise_Bubble Chart.xlsx

4. Exercise_Bubble Chart.html

11. Treemap Chart

1. Intro_Treemap Chart.mp4

02:42

2. Treemap Chart.mp4

03:15

3.1 Handout_Treemap Chart.pdf

3. Handout_Treemap Chart.html

4.1 Exercise-Treemap Chart.xlsx

4. Exercise_Treemap Chart.html

12. Sunburst Chart

1. Intro_Sunburst Chart.mp4

02:50

2. Sunburst Chart.mp4

04:07

3.1 Handout_Sunburst.pdf

3. Handout_Sunburst Chart.html

4.1 Exercise_Sunburst Chart.xlsx

4. Exercise_Sunburst Chart.html

13. Radar Chart

1. Intro_Radar Chart.mp4

02:58

2. Radar Chart.mp4

05:39

3.1 Handout_Radar Chart.pdf

3. Handout_Radar Chart.html

4.1 Exercise_Radar Chart.xlsx

4. Exercise_Radar Chart.html

14. Lollipop Chart

1. Intro_Lollipop Chart.mp4

03:15

2. Lollipop Chart.mp4

07:07

3.1 Handout_Lollipop Chart.pdf

3. Handout_Lollipop Chart.html

4.1 Exercise_Lollipop Chart.xlsx

4. Exercise_Lollipop Chart.html

15. Dumbbell Chart

1. Intro_Dumbbell Chart.mp4

02:41

2. Dumbbell Chart.mp4

10:32

3.1 Handout_Dumbbell Chart.pdf

3. Handout_Dumbbell Chart.html

4.1 Exercise_Dumbbell Chart.xlsx

4. Exercise_Dumbbell Chart.html

16. Box & Whisker Plot

1. Intro_Box & Whisker Chart.mp4

03:15

2. Box & Whisker Plot.mp4

01:52

3.1 Handout_Box & Whisker Plot.pdf

3. Handout_Box & Whisker Plot.html

4.1 Exercise_Box & Whisker Plot.xlsx

4. Exercise_Box & Whisker Plot.html

17. Histogram

1. Intro_Histogram.mp4

02:45

2. Histogram.mp4

03:38

3.1 Handout_Histogram.pdf

3. Handout_Histogram.html

4.1 Exercise_Histogram.xlsx

4. Exercise_Histogram.html

18. Funnel Chart

1. Intro_Funnel Chart.mp4

04:05

2. Funnel Chart.mp4

06:33

3.1 Handout_Funnel Chart.pdf

3. Handout_Funnel Chart.html

4.1 Exercise_Funnel Chart.xlsx

4. Exercise_Funnel Chart.html

19. Sparkline Chart

1. Intro_Sparklines.mp4

02:00

2. Sparklines.mp4

03:36

3.1 Handout_Sparklines.pdf

3. Handout_Sparklines.html

4.1 Exercise_Sparklines.xlsx

4. Exercise_Sparklines.html

20. Heatmap Chart

1. Intro_Heatmap Chart.mp4

02:57

2. Heatmap Chart.mp4

03:58

3.1 Handout_Heat Map.pdf

3. Handout_Heatmap Chart.html

4.1 Exercise_Heatmap Chart.xlsx

4. Exercise_Heatmap Chart.html

21. 3-D Surface Chart

1. Intro_3-D Surface Chart.mp4

02:32

2. 3-D Surface Chart.mp4

02:39

3.1 Handount_3-D Surface Chart.pdf

3. Handout_3-D Surface Chart.html

4.1 Exercise_3-D Surface Chart.xlsx

4. Exercise_3-D Surface Chart.html

22. Contour Chart

1. Intro_Contour Chart.mp4

02:05

2. Contour Chart.mp4

02:06

3.1 Handout_Contour Chart.pdf

3. Handout_Contour Chart.html

4.1 Exercise_Contour Chart.xlsx

4. Execise_Contour Chart.html

23. Tornado Chart

1. Intro_Tornado Chart.mp4

02:52

2. Tornado Chart.mp4

08:12

3.1 Handout_Tornado Chart.pdf

3. Handout_Tornado Chart.html

4.1 Exercise_Tornado Chart.xlsx

4. Exercise_Tornado Chart.html

24. Combo Chart

1. Intro_Combo Chart.mp4

02:54

2. Combo Chart.mp4

07:05

3.1 Handout_Combo Chart.pdf

3. Handout_Combo Chart.html

4.1 Exercise_Combo Chart.xlsx

4. Exercise_Combo Chart.html

25. Conclusion

1. Conclusion.mp4

01:00

Description

Master 22+ Excel charts/graphs from A to Z with hand-on demos exercises (Excel 2016, 2019, 2021, Microsoft 365/online)

What You'll Learn?

Understand of USES and BEST PRACTICES of 22+ charts in Excel 2019+ (or Microsoft 365)
Master powerful practical tips and tools to better communicate and concise message through your Excel charts
Build 22+ Excel real-world projects from scratch to help you become a data viz rockstar.
Learn how to make eye-catching Excel charts and better visualization through advanced customization techniques like adding titles, axes, data labels

Who is this for?

Anyone who wants to learn how to create effective and beautiful charts/graphs in Excel.

Excel users who want to expand their portfolio and experiences to impress their employers.

Professionals who are looking to explore more about data analytics and visual presentation in Excel.

Students who want to master data visualization skills with Excel.

Learners who are looking to find best Excel chart course with hands-on demo exercise files and support documents.

More details

Description
Data visualization transfers data into insight through charts or graphs. It makes it easier to identify trends and patterns instead of looking at large data sets in a spreadsheet/tabular.
When it comes to visualization tools, Excel offers a significant number of built-in charts for its ease of use and flexibility. Anyone with access to that spreadsheet can create various types of charts/graphs in a meaningful way. Excel allows users to generate a chart in just a few clicks and enable them to customize that chart easily such as adding titles, axes, labels, colors, etc.
This course provides you with a laser-focused, 100% comprehensive understanding of the latest Excel visualization tools. Iâ€™ll help you take all of the basic Excel visualization techniques and apply them in real-world applications. From there, weâ€™ll explore over 22 different chart types available in Excel 2019(version 2016 and Microsoft 365 are also available) such as:

Column chart
Bar chart
Line chart
Pie chart
Waterfall chart
Candlestick chart
Area chart
Scatter plot
Bubble chart
Treemap chart
Sunburst chart
Radar chart
Lollipop chart
Dumbbell chart
Box & Whisker plot
Histogram
Pareto chart
Funnel chart
Sparkline chart
Heatmap chart
3-D surface chart
Contour chart
Tornado chart
Combo chart
And moreâ€¦
In each lesson, youâ€™ll begin with a solid knowledge of the uses and best practices of a chart, course expectations, and steps-by-steps instruction through interactive hands-on demos and exercises. To guarantee you get a 100% understanding of the course, Iâ€™ve included course handouts of all chart types in the tutorial to walk you through every single step from start to finish. You canâ€™t find these demos material elsewhere, except in this course.
What youâ€™ll get from this course:
Full lifetime access to all course demos
22+ charts step-by-step instruction documents
22+ Excel exercise files
Yearly course update (Iâ€™ll add new chart types and techniques every year)
Certificate of completion
And moreâ€¦
Letâ€™s dive together to Master Excel Data Visualization: Static Charts & Graphs.
Cheers,
-Datariel (BI Analytics Training Center)
--------------------------
Update History:
-November 15, 2022: officially launched the course.

Who this course is for:
Anyone who wants to learn how to create effective and beautiful charts/graphs in Excel.
Excel users who want to expand their portfolio and experiences to impress their employers.
Professionals who are looking to explore more about data analytics and visual presentation in Excel.
Students who want to master data visualization skills with Excel.
Learners who are looking to find best Excel chart course with hands-on demo exercise files and support documents.

User Reviews

Rating

average 0

Total votes0

Focused display

DataRiel is an online training center focusing on Business Intelligence Analytics. Our goal is to help businesses & organizations grow sustainably using data. We provide well-designed and good-quality courses which are reliable, affordable, practical, productive, and fun. Learning is for everyone, and data is everywhere.Learning new skills is endless. Think of DataRiel as your personal instructor and mentor, helping you navigate the learning process and excel in the skills you need with the best experiences.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.