Mastering Excel Data Visualization: Static Charts & Graphs

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

Created by : Rated :4.3 560 views

Last Updated: 2023-03-20 08:03:55 English Course Type: Self Learning

Understand of USES and BEST PRACTICES of 23+ charts in Excel 2019+ / Office 365.
Build 23+ Excel real-world projects from scratch to help you become a data viz rockstar.
Master powerful practical tips and tools to better communicate and concise message through your Excel charts.
Learn how to make eye-catching Excel charts and better visualization through advanced customization techniques like adding informative titles, axes, data labels, meaningful colors, graphics/images, etc.

Data visualization transfers data into insight through charts or graphs. It makes it easier to identify trends and patters instead of looking at large data sets in a spreadsheet/tabular.

When it comes to visualization tools, Excel offers a great number of built-in charts as its ease of use and flexibility. Anyone with access to that spreadsheet can create various type of charts/graphs in a meaningful way. Excel allows users to generate a char in few clicks and enable them to customize that chart easily such as adding title, axes, labels, colors, etc.

This course provides you a laser-focused, 100% comprehensive understanding of 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 23 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 for all course demos 23+ charts step-by-step instruction documents
23+ Excel exercise filesYearly course update (I’ll add new chart types and techniques every year)
Certificate of completion
And more…

Well, let’s dive in together to master Excel data visualization, static charts & graphs.

Cheers,

-Datariel (Data visualization & Analytics training school)

----------------------------

-Microsoft Excel (version 2016 + or Office 365 for PC)
-Basic Excel experience and knowledge are required
-Data Samples (you can download from this course)
-Access to an Internet Connection (to access some excel features)

-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 is looking to find best Excel chart course with hands-on demo exercise files and support documents.

Section 1 : Let's get started 1 Lectures 00:01:00
Lecture 1 :
Introduction Preview
Section 2 : Column Chart 4 Lectures 00:08:43
Lecture 1 :
Intro_Column Chart
Lecture 2 :
Column Chart
Lecture 3 :
Handout_Column Chart
Lecture 4 :
Exercise_Column Chart
Section 3 : Bar Chart 4 Lectures 00:09:21
Lecture 1 :
Intro_Bar Chart
Lecture 2 :
Bar Chart
Lecture 3 :
Handout_Bar Chart
Lecture 4 :
Exercise_Bar Chart
Section 4 : Line Chart 4 Lectures 00:11:55
Lecture 1 :
Intro_Line Chart
Lecture 2 :
Line Chart
Lecture 3 :
Handout_Line Chart
Lecture 4 :
Exercise_Line Chart
Section 5 : Pie Chart 4 Lectures 00:08:21
Lecture 1 :
Intro_Pie Chart
Lecture 2 :
Pie Chart
Lecture 3 :
Handout_Pie Chart
Lecture 4 :
Exercise_Pie Chart
Section 6 : Waterfall Chart 4 Lectures 00:06:14
Lecture 1 :
Intro_Waterfall Chart
Lecture 2 :
Waterfall Chart
Lecture 3 :
Handout_Waterfall Chart
Lecture 4 :
Exercise_Waterfall Chart
Section 7 : Candlestick Chart 4 Lectures 00:08:08
Lecture 1 :
Intro_Candlestick Chart
Lecture 2 :
Candlestick Chart
Lecture 3 :
Handout_Candlestick Chart
Lecture 4 :
Exercise_Candlestick Chart
Section 8 : Area Chart 4 Lectures 00:08:14
Lecture 1 :
Intro_Area Chart
Lecture 2 :
Area Chart
Lecture 3 :
Handout_Area Chart
Lecture 4 :
Exercise_Area Chart
Section 9 : Scatter Plot 4 Lectures 00:07:22
Lecture 1 :
Intro_Scatter Plot
Lecture 2 :
Scatter Plot
Lecture 3 :
Handout_Scatter Plot
Lecture 4 :
Exercise_Scatter Plot
Section 10 : Bubble Chart 4 Lectures 00:10:22
Lecture 1 :
Intro_Bubble Chart
Lecture 2 :
Bubble Chart
Lecture 3 :
Handout_Bubble Chart
Lecture 4 :
Exercise_Bubble Chart
Section 11 : Treemap Chart 4 Lectures 00:06:19
Lecture 1 :
Treemap Chart
Lecture 2 :
Intro_Treemap Chart
Lecture 3 :
Handout_Treemap Chart
Lecture 4 :
Exercise_Treemap Chart
Section 12 : Sunburst Chart 4 Lectures 00:07:25
Lecture 1 :
Sunburst Chart
Lecture 2 :
Intro_Sunburst Chart
Lecture 3 :
Handout_Sunburst Chart
Lecture 4 :
Exercise_Surburst Chart
Section 13 : Radar Chart 4 Lectures 00:09:00
Lecture 1 :
Radar Chart
Lecture 2 :
Intro_Radar Chart
Lecture 3 :
Handout_Radar Chart
Lecture 4 :
Exercise_Radar Chart
Section 14 : Lollipop Chart 4 Lectures 00:10:39
Lecture 1 :
Lollipop Chart
Lecture 2 :
Intro_Lollipop Chart
Lecture 3 :
Handout_Lollipop Chart
Lecture 4 :
Exercise_Lollipop Chart
Section 15 : Dumbbell Chart 4 Lectures 00:14:09
Lecture 1 :
Dumbbell Chart
Lecture 2 :
Intro_Dumbbell Chart
Lecture 3 :
Handout_Dumbbell Chart
Lecture 4 :
Exercise_Dumbbell Chart
Section 16 : Box & Whisker Plot 4 Lectures 00:05:30
Lecture 1 :
Box & Whisker Plot
Lecture 2 :
Intro_Box & Whisker Plot
Lecture 3 :
Handout_Box & Whisker Plot
Lecture 4 :
Exercise_Box & Whisker Plot
Section 17 : Histogram 4 Lectures 00:06:50
Lecture 1 :
Histogram
Lecture 2 :
Intro_Histogram
Lecture 3 :
Handout_Histogram
Lecture 4 :
Exercise_Histogram
Section 18 : Pareto Chart 4 Lectures 00:08:05
Lecture 1 :
Pareto Chart
Lecture 2 :
Intro_Pareto Chart
Lecture 3 :
Handout_Pareto Chart
Lecture 4 :
Exercise_Pareto Chart
Section 19 : Funnel Chart 4 Lectures 00:11:24
Lecture 1 :
Funnel Chart
Lecture 2 :
Intro_Funnel Chart
Lecture 3 :
Handout_Funnel Chart
Lecture 4 :
Exercise_Funnel Chart
Section 20 : Sparkline Chart 4 Lectures 00:06:32
Lecture 1 :
Sparklines
Lecture 2 :
Intro_Sparklines
Lecture 3 :
Handout_Sparklines
Lecture 4 :
Exercise_Sparklines
Section 21 : Heatmap Chart 4 Lectures 00:03:12
Lecture 1 :
Heatmap Chart
Lecture 2 :
Intro_Heatmap Chart
Lecture 3 :
Handout_Heatmap Chart
Lecture 4 :
Exercise_Heatmap Chart
Section 22 : 3-D Surface Chart 4 Lectures 00:05:27
Lecture 1 :
3-D Surface Chart
Lecture 2 :
Intro_3-D Surface Chart
Lecture 3 :
Handout_3-D Surface Chart
Lecture 4 :
Exercise_3-D Surface Chart
Section 23 : Contour Chart 4 Lectures 00:04:31
Lecture 1 :
Contour Chart
Lecture 2 :
Intro_Contour Chart
Lecture 3 :
Handout_Contour Chart
Lecture 4 :
Exercise_Contour Chart
Section 24 : Tornado Chart 4 Lectures 00:11:51
Lecture 1 :
Tornado Chart
Lecture 2 :
Intro_Tornado Chart
Lecture 3 :
Handout_Tornado Chart
Lecture 4 :
Exercise_Tornado Chart
Section 25 : Combo Chart 4 Lectures 00:10:26
Lecture 1 :
Combo Chart
Lecture 2 :
Intro_Combo Chart
Lecture 3 :
Handout_Combo Chart
Lecture 4 :
Exercise_Combo Chart
Section 26 : Conclusion 1 Lectures 00:01:00
Lecture 1 :
Wrap-up & Thanks

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

DataRiel Academy,

560 Course Views

1 Courses

DataRiel is an online training center focusing on Data Visualization. Our goal is to help individuals and businesses present data in an effective way. 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.