Data Visualization in Excel All Excel Charts and Graphs

25+ Excel charts and graphs – Data Visualization in Microsoft Excel – visualizing data with Excel 2007- Excel 2019
Data Visualization in Excel All Excel Charts and Graphs
File Size :
2.17 GB
Total length :
4h 24m

Category

Instructor

Start-Tech Academy

Language

Last update

12/2023

Ratings

4.4/5

Data Visualization in Excel All Excel Charts and Graphs

What you’ll learn

Learn the techniques to communicate clear and concise message through your charts
Learn how to create 25+ chart types in Excel
Learn by Doing. Course comes with numerous exerises sheets to practice learnt concepts
Master the art of creating impactful Excel charts
Get familiar with all the elements of charts in Excel
Become proficient in using powerful tools such as pivot tables and pivot charts
Master newly introduced chart types such as sunburst, treemap and waterfall chart
Learn how to create cool infographics to represent data

Data Visualization in Excel All Excel Charts and Graphs

Requirements

You will need a PC with any version of Excel installed in it
Basic understanding of Excel operations like opening, closing and saving a file

Description

What are the chart types I will learn in this course?Excel offers the following major chart types. All of these are covered in this course    Column Chart    Line Chart    Pie Chart    Doughnut Chart    Bar Chart    Area Chart    XY (Scatter) Chart    Bubble Chart    Stock Chart    Surface Chart    Radar Chart    Combo Chart    Pivot Chart    SparklinesAnd many other creative ones :)How are charts useful in Excel?A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier.What are the benefits of using charts in Excel?Excel charts allow spreadsheet administrators to create visualizations of data sets. By highlighting a set of data within an Excel spreadsheet and feeding it into the charting tool, users can easily create various types of charts in which the data is displayed in a graphical way.This course will answer all the questions that would pop up while you set to visualize your data using Excel charts such as:How do you make Excel charts look better?How do you format a chart in Excel?What are the different elements of charts?How do I make those awesome infographics that I see in fancy magazines and TV reports?How do I create a comparison chart in Excel?What is the best chart to use for comparison?And many more…How is this course different from other resources available online?Most courses cover only teach how to draw different types of charts in Excel. The main point is missed. The main point of creating a chart is that you want to convey a message or tell a story using the chart. In this course, once you have learnt all the charting tools, you will also learn how you should create a chart. How you can highlight your message and avoid clutter in the chart, so that when your audience looks at the chart, the message is clearly conveyed to them.

Overview

Section 1: Introduction and basics

Lecture 1 Welcome to the Course!

Lecture 2 Why are charts used?

Lecture 3 Course Resources

Lecture 4 This is a milestone!

Lecture 5 Categories of messages that can be conveyed

Lecture 6 Elements of charts

Lecture 7 The Easy way of creating charts

Section 2: Most important Charts & Best practices

Lecture 8 Bar and column charts

Lecture 9 Formating charts

Lecture 10 Exercise 1: Bar and Column Charts

Lecture 11 Best Practices: Bar Chart

Lecture 12 Line Charts

Lecture 13 Avoiding the Spaghetti plot

Lecture 14 Exercise 2: Line Charts

Lecture 15 Area Charts

Lecture 16 Pie and Doughnut Charts

Lecture 17 Why we should avoid Pie charts!

Lecture 18 Exercise 3: Pie Charts

Lecture 19 Scatter plot or XY chart

Lecture 20 Exercise 4: Scatter plot

Lecture 21 Frequency Distribution and Histograms

Lecture 22 Exercise 5: Histogram

Lecture 23 Waterfall chart

Lecture 24 Exercise 6: Waterfall chart

Lecture 25 Hierarchy Charts: Sunburst and Treemap

Lecture 26 Exercise 7: Hierarchy charts

Lecture 27 Combination charts

Lecture 28 Exercise 8: Combination Charts

Lecture 29 Highlighting chart message

Lecture 30 Eliminating Distractions from the Graph

Lecture 31 Avoiding clutter

Section 3: Pivot charts

Lecture 32 Pivot table

Lecture 33 Pivot Charts

Lecture 34 Exercise 9: Pivot charts

Section 4: Less used charts

Lecture 35 Stock charts

Lecture 36 Radar charts

Lecture 37 Surface charts

Lecture 38 Heatmaps

Section 5: Sparklines

Lecture 39 Mini charts: Sparklines

Lecture 40 Exercise 10: Sparklines

Section 6: Infographics using Excel charts

Lecture 41 Creative Infographic 1

Lecture 42 Creative Infographic 2

Section 7: New! Maps chart – Excel 2019 and above

Lecture 43 Maps chart

Section 8: Appendix: Bonus Excel functionalities

Lecture 44 Essential Excel functions

Lecture 45 How to solve transportation problem using Excel Goal-Seek

Section 9: Bonus Section

Lecture 46 The final milestone!

Lecture 47 Bonus Lecture

Anyone curious to master charts in excel from beginner to advanced in short span of time

Course Information:

Udemy | English | 4h 24m | 2.17 GB
Created by: Start-Tech Academy

You Can See More Courses in the Business >> Greetings from CourseDown.com

New Courses

Scroll to Top