https://archive.is/wip/LcIYS Ask people is Archive: what comes to mind when they think of Excel, and odds are they'll say "spreadsheets"..
Archive: https://archive.is/wip/LcIYS Ask people what comes to mind when they think of Excel, and odds are they'll say "spreadsheets".
The truth is is, Excel is an incredibly powerful, robust, 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..
The truth is, Excel is an incredibly powerful, robust, 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 is show you when, why, and how to use each chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and exercises every step of the way.WHAT WILL YOU LEARN?We'll kick things off by exploring each of the 20+ chart types that Excel 2016 has to offer, including:Bar & Column chartsHistograms & Pareto chartsLine charts & trend linesArea chartsPies & DonutsScatter plots & Bubble chartsBox & Whisker chartsTree Maps & SunburstsWaterfall & Funnel chartsRadar & Stock chartsHeat maps, 3-D Surface & contour chartsChloropleths & Geospatial mapsCustom combo charts & graphsSparklinesAnd more...From there we'll dive into a series of 12+ advanced Excel demos guaranteed to turn you into an absolute data viz rockstar..
I'll show you when, why, and how to use each chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and exercises every step of the way.WHAT WILL YOU LEARN?We'll kick things off by exploring each of the 20+ chart types that Excel 2016 has to offer, including:Bar & Column chartsHistograms & Pareto chartsLine charts & trend linesArea chartsPies & DonutsScatter plots & Bubble chartsBox & Whisker chartsTree Maps & SunburstsWaterfall & Funnel chartsRadar & Stock chartsHeat maps, 3-D Surface & contour chartsChloropleths & Geospatial mapsCustom combo charts & graphsSparklinesAnd more...From there we'll dive into a series of 12+ advanced Excel demos guaranteed to turn you into an absolute data viz rockstar.
"textbook" demos is These aren't that you can find on YouTube; these are projects adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times..
These aren't "textbook" demos that you can find on YouTube; these are projects adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times.
I've is built my analytics career around data visualization, and I can help you do the same.Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your data visualization game in a major way, this course is for you..
I've built my analytics career around data visualization, and I can help you do the same.Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your data visualization game in a major way, this course is for you.
fact, is In if you don't learn something brand new in this course, I will make sure you get your money back AND give you a virtual high-five for checking it out!WHATS INCLUDED IN THE COURSE?Downloadable project files and resourcesUnique tips and tools that you won't find in ANY other course, guaranteedAdvanced demos and case studiesCourse quizzes & homework exercises100% MONEY-BACK GUARANTEEWHO SHOULD TAKE THIS COURSE?Anyone looking to create beautiful, custom data visualizations in ExcelExcel users who have basic skills but want to master advanced charts, graphs & dashboardsStudents looking for an engaging, hands-on, and highly interactive approach to trainingCourse CurriculumGetting StartedCourse Structure & Outline (2:03)Bonus Homework ExercisesData Visualization Best PracticesKey Principles & The 10-Second Rule (2:45)The Good, The Bad & The Ugly (3:44)Three Key Questions (1:49)Chart CustomizationSetting Expectations (1:02)Chart Elements, Layouts & Styles (6:20)Chart Formatting Options (5:26)Changing Chart Types & Adding a Secondary Axis (3:03)Creating, Modifying & Applying Custom Templates (4:06)QUIZ: Chart CustomizationMastering Basic Charts & GraphsBar & Column Charts (8:49)HOMEWORK: Bar & Column ChartsHistogram & Pareto Charts (5:58)HOMEWORK: Histogram & Pareto ChartsLine Charts & Trendlines (5:16)HOMEWORK: Line Charts & TrendlinesArea Charts (4:41)HOMEWORK: Area ChartsPies, Donuts & Race Tracks (12:04)HOMEWORK: Pies, Donuts & Race TracksScatter Plots (7:30)Bubble Charts (6:36)HOMEWORK: Scatter Plots & Bubble ChartsBox & Whisker Charts (6:05)HOMEWORK: Box & Whisker ChartsTree Maps & Sunbursts (6:36)HOMEWORK: Tree Maps & SunburstsWaterfall Charts (3:17)Funnel Charts (3:42)HOMEWORK: Waterfall & Funnel ChartsRadar Charts (7:56)HOMEWORK: Radar ChartsStock Charts (7:18)HOMEWORK: Stock ChartsHeat Maps (4:41)HOMEWORK: Heat MapsSurface & Contour Charts (7:35)HOMEWORK: Surface & Contour ChartsGeospatial Maps with Power Map (5:28)HOMEWORK: Power MapBasic Combo Charts (7:57)HOMEWORK: Combo ChartsSparklines (2:07)HOMEWORK: SparklinestQUIZ: Basic Charts & GraphsNext-Level Data Viz DemosSetting Expectations (1:40)DEMO: Custom Image Overlay Charts (6:01)DEMO: Adding Binary Values to Highlight Ranges (5:02)DEMO: Automation with OFFSET & COUNTA (7:08)DEMO: Adding Interactive Elements with Form Controls (12:30)DEMO: Animating Changes Over Time (14:20)DEMO: Building a Dynamic Dashboard (Part 1) (16:10)DEMO: Building a Dynamic Dashboard (Part 2) (12:08)DEMO: Dynamic Value-Based Formatting (10:09)DEMO: Dynamically Highlighting a Data Series (10:26)DEMO: Building a Custom Pacing Chart (10:22)DEMO: Building a Custom Gauge Chart (9:58)DEMO: Visualizing Percentages with Arrays (7:16)QUIZ: Next-Level Data VizWrapping UpResources & Next Steps (2:38).
In fact, if you don't learn something brand new in this course, I will make sure you get your money back AND give you a virtual high-five for checking it out!WHATS INCLUDED IN THE COURSE?Downloadable project files and resourcesUnique tips and tools that you won't find in ANY other course, guaranteedAdvanced demos and case studiesCourse quizzes & homework exercises100% MONEY-BACK GUARANTEEWHO SHOULD TAKE THIS COURSE?Anyone looking to create beautiful, custom data visualizations in ExcelExcel users who have basic skills but want to master advanced charts, graphs & dashboardsStudents looking for an engaging, hands-on, and highly interactive approach to trainingCourse CurriculumGetting StartedCourse Structure & Outline (2:03)Bonus Homework ExercisesData Visualization Best PracticesKey Principles & The 10-Second Rule (2:45)The Good, The Bad & The Ugly (3:44)Three Key Questions (1:49)Chart CustomizationSetting Expectations (1:02)Chart Elements, Layouts & Styles (6:20)Chart Formatting Options (5:26)Changing Chart Types & Adding a Secondary Axis (3:03)Creating, Modifying & Applying Custom Templates (4:06)QUIZ: Chart CustomizationMastering Basic Charts & GraphsBar & Column Charts (8:49)HOMEWORK: Bar & Column ChartsHistogram & Pareto Charts (5:58)HOMEWORK: Histogram & Pareto ChartsLine Charts & Trendlines (5:16)HOMEWORK: Line Charts & TrendlinesArea Charts (4:41)HOMEWORK: Area ChartsPies, Donuts & Race Tracks (12:04)HOMEWORK: Pies, Donuts & Race TracksScatter Plots (7:30)Bubble Charts (6:36)HOMEWORK: Scatter Plots & Bubble ChartsBox & Whisker Charts (6:05)HOMEWORK: Box & Whisker ChartsTree Maps & Sunbursts (6:36)HOMEWORK: Tree Maps & SunburstsWaterfall Charts (3:17)Funnel Charts (3:42)HOMEWORK: Waterfall & Funnel ChartsRadar Charts (7:56)HOMEWORK: Radar ChartsStock Charts (7:18)HOMEWORK: Stock ChartsHeat Maps (4:41)HOMEWORK: Heat MapsSurface & Contour Charts (7:35)HOMEWORK: Surface & Contour ChartsGeospatial Maps with Power Map (5:28)HOMEWORK: Power MapBasic Combo Charts (7:57)HOMEWORK: Combo ChartsSparklines (2:07)HOMEWORK: SparklinestQUIZ: Basic Charts & GraphsNext-Level Data Viz DemosSetting Expectations (1:40)DEMO: Custom Image Overlay Charts (6:01)DEMO: Adding Binary Values to Highlight Ranges (5:02)DEMO: Automation with OFFSET & COUNTA (7:08)DEMO: Adding Interactive Elements with Form Controls (12:30)DEMO: Animating Changes Over Time (14:20)DEMO: Building a Dynamic Dashboard (Part 1) (16:10)DEMO: Building a Dynamic Dashboard (Part 2) (12:08)DEMO: Dynamic Value-Based Formatting (10:09)DEMO: Dynamically Highlighting a Data Series (10:26)DEMO: Building a Custom Pacing Chart (10:22)DEMO: Building a Custom Gauge Chart (9:58)DEMO: Visualizing Percentages with Arrays (7:16)QUIZ: Next-Level Data VizWrapping UpResources & Next Steps (2:38)