Excel Charts & Graph Course -Basic to Advanced Visualization

Become an Excel Data Visualization Expert and Explore all impressive visualization Techniques in Excel

4.45 (33 reviews)
Udemy
platform
English
language
Microsoft
category
1,226
students
5.5 hours
content
Nov 2022
last update
$69.99
regular price

What you will learn

Learn Beginners to Advanced Level Demo on Excel Charts and Graphs

Learn Basic Key Principles and Rules before Selecting a Chart

Learn about creating dynamic Charts with Excel Formulas

Use various Excel charts and Graphs Customization Techniques

Become an Advanced Excel Visualization Expert - Explore and Enjoy reading materials and get reference material to use for better understanding

Non Linear Course - Can jump onto any section of the Course, so it is easy to navigate and start from anywhere to learn more about it.

Become Advanced Excel Visualization Expert and create Impressive Charts. This course includes advanced level demo which can give you a chance to stand out

Learn about Excel Visualization Tools and Techniques - Including Dashboarding Tricks which you may use during creating awesome level of dashboars

Watch, Understand Practice Excel Charts and Graphs - Master Unique Tips which you would not find in any Excel Coruse

Get Experts Support while learning if you find any questions or you get stucked - Q&A Support

Description

Explore Excel Data Visualization Techniques which can make you a data viz expert. Once you complete this course, I can guarantee that you will not look for other Data Viz tools because everybody these days thinking to buy some advanced tools to create awesome data visualization or creating advanced level charts/graphs. However most of the people are unaware that they can create advanced level charts in Microsoft Excel itself because this is widely used and everybody has access to spreadsheets. Am I right? So lets explore 20+ amazing Excel Data visualization along with 7+ advanced level customization to create awesome effect on your reports. In this course, I am going to talk Why, When, How we should be using Excel Graphs and Charts and need of these by explaining every single details.


Lets explore these Excel Charts and Techniques to create professional reports, dashboards, summary. This course covers:


  • Bar & Column charts

  • Histograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)

  • Line charts & trend lines

  • Area charts

  • Pies & Donuts

  • Scatter plots & Bubble charts

  • Box & Whisker charts (Office 365, Excel 2016 or Excel 2019)

  • Tree Maps & Sunbursts (Office 365, Excel 2016 or Excel 2019)

  • Waterfall & Funnel charts (Office 365, Excel 2016 or Excel 2019)

  • Radar & Stock charts

  • Heat maps, 3-D Surface & contour charts

  • Choropleths & Geospatial maps

  • Custom combo charts & graphs

  • Sparkline

  • And many more...

Once you understand the basic about these given charts, then we will do a deep dive by covering advanced excel data analysis tools. Also explore practice papers to get trained on these visualization. Next Deep dive in this course includes:


  • Customizing Column Charts with Image overlay

  • Updating Charts automatically with Offset and CountA functions

  • Enabling Scroll and Zoom Controls on the Chart to show specific periods

  • Enabling animations on the Chart

  • Usage of various dashboarding tricks i.e. Changing shapes on the chart, using option boxes or checkboxes

  • Categorical Chart Formatting

  • Pivot Charts

  • Pacing and Gauage Chart to show the progress

  • GRID Charts

Whether you are a beginner or expert, you will find amazing tricks which you would not have heard before. I am sure that this journey will be amazing. Lets get started

Best Wishes

Content

Getting Started With Excel Visualization

Introduction
Important Notes: Read About This
Resource Files
Setting Expectations

Excel Visualization Best Practices and Key Rules

Excel Visualization - Best Practices and Key Principles

Excel Graphs Customization and Formatting

Chapter 1 - Charts Elements, Customizing Layouts & Styles
Chapter 2 Formatting Chart Elements
Chapter 3 Change Excel Chart Type and Secondary Axis
Chapter 4. Creating and Saving Custom Chart Templates
Chart Formatting Quiz

Master Excel Basic to Advanced Visualization

Chapter 5. Bar and Columns Chart
Practice: Bar and Columns Chart
Chapter 6 Histogram and Pareto Charts
Practice: Histogram and Pareto Charts
Chapter 7 Line Charts and Trendlines
Practice: Line Charts and Trendlines
Chapter 8 Area Charts
Practice: Area Charts
Chapter 9 Pie and Donut Charts
Practice: Pie and Donut Charts
Chapter 10 Scatter Plots
Chapter 11 Bubble Charts
Practice: Scatter and Bubble Charts
Chapter 12 Box and Whisker Charts in Excel
Practice: Box and Whisker Charts
Chapter 13 Tree Maps and Sunburst Chart
Practice: Tree Maps and Sunburst Chart
Chapter 14 Waterfall Charts
Chapter 15 Funnel Charts
Practice: Waterfall and Funnel Charts
Chapter 16 Radar Charts
Practice: Radar Charts
Chapter 17 Stock Chart
Practice: Stock Chart
Chapter 18 Heat Maps
Practice: Heat Maps
Chapter 19 Surface Charts
Practice: Surface Charts
Chapter 20 Power Map Charts
Practice: Power Map Charts
Chapter 21 Combo Charts
Practice: Combo Charts
Chapter 22 Sparklines

Advanced Level Demo Exercises

Chapter 23 Image Overlay Charts
Chapter 24 Highlight Special Cases
Chapter 25 Automatic Chart Updates
Chapter 26 Scroll and Bar Charts
Chapter 27 Dashboarding Tricks
Chapter 28 Animations Change Over Time
Chapter 29 Pivot Charts
Chapter 30 Color Based Formatting
Chapter 31 Dynamic Series Selection
Chapter 32 Pacing Chart
Chapter 32 Guage Chart

Screenshots

Excel Charts & Graph Course -Basic to Advanced Visualization - Screenshot_01Excel Charts & Graph Course -Basic to Advanced Visualization - Screenshot_02Excel Charts & Graph Course -Basic to Advanced Visualization - Screenshot_03Excel Charts & Graph Course -Basic to Advanced Visualization - Screenshot_04

Reviews

Mamta
August 18, 2022
This is really very helpful course I have taken in the last few years. I am using excel charts every day for my work and this course helped me a lot to create different charts within a few minutes. I have recommended this course to my colleagues and friends. Thank you, Mamta
Himanshu
December 31, 2021
It was an amazing course. I really enjoyed learning these advance tricks. Thanks Kapil for all help during the course
Pradeep
July 1, 2021
I am working professional and Microsoft Excel is the most commonly used application in office. This course helped me to increased my horizon in Data Visualisation and provided insights of charts . Very experienced and knowledgeable trainer. Nicely explained, very detailed and easy to understand for freshers also. Thank you,

Coupons

DateDiscountStatus
1/8/2022100% OFF
expired

Charts

Price

Excel Charts & Graph Course -Basic to Advanced Visualization - Price chart

Rating

Excel Charts & Graph Course -Basic to Advanced Visualization - Ratings chart

Enrollment distribution

Excel Charts & Graph Course -Basic to Advanced Visualization - Distribution chart
4111572
udemy ID
6/9/2021
course created date
9/19/2021
course indexed date
Bot
course submited by