Overview

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 chartsHistograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)Line charts & trend linesArea chartsPies & DonutsScatter plots & Bubble chartsBox & 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 chartsHeat maps, 3-D Surface & contour chartsChoropleths & Geospatial mapsCustom combo charts & graphsSparklineAnd 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 overlayUpdating Charts automatically with Offset and CountA functionsEnabling Scroll and Zoom Controls on the Chart to show specific periodsEnabling animations on the ChartUsage of various dashboarding tricks i.e. Changing shapes on the chart, using option boxes or checkboxesCategorical Chart FormattingPivot ChartsPacing and Gauage Chart to show the progressGRID ChartsWhether 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 startedBest Wishes

Skills

Reviews