Excel Charts & Graphs Course: Basic to Advanced Visualization

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 of buying some advanced tools to create awesome data visualization or creating advanced-level charts/graphs. However, most of 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 let's explore 20+ amazing Excel Data visualizations along with 7+ advanced-level customization to create awesome effects on your reports. In this course, I am going to talk about Why, When, and How we should be using Excel Graphs and Charts and the need for these by explaining every single detail.

Let's explore these Excel Charts and Techniques to create professional reports, dashboards, and summaries. 

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 this visualization. The 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 Gauge Chart to show the progress

• GRID Charts

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

Best Wishes