Overview

DescriptionFULL COURSE DESCRIPTION:Ask people what comes to mind when they think of Excel, and odds are they'll say "spreadsheets". The truth is, Excel is an incredibly powerful and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts - and I'm here to prove it.This course gives you a deep, 100% comprehensive understanding of Excel's latest data visualization tools and techniques. I'll show you when, why, and how to use each Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercises every step of the way.__________We'll kick things off by exploring each of the 20+ charts & graphs introduced in Excel 2019, including: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 chartsChloropleths & Geospatial mapsCustom combo charts & graphsSparklinesAnd more...__________We'll cover advanced Excel data viz topics that you won't find anywhere else, including:Custom image overlay chartsAutomation with named ranges and OFFSET/COUNTA functionsScroll & Zoom functionality with Excel form controlsAnimated charts to visualize changes over timeDynamic, custom Excel dashboardsValue-based chart formattingCustom gauge charts & pacing chartsGrid visuals using Excel array formulasWhether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your Excel data visualization game in a major way, this course is for you.See you there!-Srinivas Reddy (Founder, Excel Map)__________*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2016, Excel 2019 or Office 365.

Skills

Reviews