What will you learn?

We will explore each of the 20 chart types that excel 2016 has to offer.

• Bar & Column charts
• Histograms & Pareto charts
• Line charts & trend lines
• Area charts
• Pies & Donuts
• Scatter plots & Bubble charts
• Box & Whisker charts
• Tree Maps & Sunbursts
• Waterfall & Funnel charts
• Radar & Stock charts
• Heat maps, 3-D Surface & contour charts
• Chloropleths & Geospatial maps
• Custom combo charts & graphs
• Sparklines
• And more…

From there we’ll dive into a series of 12 advanced Excel demos guaranteed to turn you into an absolute data viz rockstar. These aren’t “textbook” demos that you can find on YouTube; these are Microsoft, MIT, and the New York Times all featured award-winning work. I have built my 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. 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 high five when you check it out.

What is included in the course?

• LIFETIME access to all content
• Downloadable project files and resources
• Unique, hands-on demos and case studies
• Course quizzes & homework exercises
• Certificate of Completion
• 100% MONEY-BACK GUARANTEE

Who is this course for?

• Anyone looking to create beautiful, custom data visualizations in Excel
• Excel users who have basic skills but want to master advanced charts, graphs & dashboards
• Students looking for an engaging, hands-on, and highly interactive approach to training

There is a course onCURRICULUM.

Getting started. The structure and outline of the preview course. Start with the course resources. Start setting expectations. Data visualization best practices. The 10-Second Rule is PreviewKey Principles. The good, the bad, and the ugly. There are three key questions. There is chart Formatting and customization. StartChart elements, layout and styles. StartChart Formatting options are available. Adding a secondary axis is one of the ways to start changing chart types. Creating, modifying, and applying custom templates arePreviewCreating, modifying, and applying custom templates arePreview Creating, modifying, and applying custom templates arePreview Creating, modifying, and applying custom templates arePreview Creating, modifying, and applying custom templates arePreview Creating, modifying, and applying custom templates Take the StartQUIZ about chart customization. Basic Charts and Graphs can be mastered. The StartBar & Column Charts can be found here. There are bar and column charts. Start Histogram and Pareto Charts. Histogram and Pareto Charts are included in Start Homework. Startline charts and trendlines. Line charts and trendlines are included in Start Homework. The start area charts. Start Homework: Area Charts. Start pies, donuts, and race tracks. Pies, doughnuts, and race tracks are part of the homestead. StartScatter Plots There are StartBubble Charts. There are Scatter Plots and Bubble Charts. The StartBox and Whisker Charts are here. Box and Whisker Charts are part of Start Homework. There are PreviewTree Maps and Sunbursts. Start Homework: Tree Maps. There are start waterfall charts. StartFunnel Charts are 3:42. There are waterfall and charts in Start Homework. The previewradar charts are for 7 minutes. StartHOMEWORK: Radar Charts. There are StartStock Charts. Stock charts are part of Start Homework. StartHeat Maps can be found here. Start home work: heat maps. StartSurface & Contour Charts are used. Start Homework: Surface and Contour Charts. Startgeospatial maps with power map StartHOMEWORK: Power Map. StartBasic combo charts. There are combo charts in StartHOMEWORK. StartSparklines is a short film. Start Homework: Sparklines. StartQUIZ: Charts and Graphs. Data vas demos are next-level. The start setting expectations. StartDEMO: custom image charts. StartDEMO: Adding Values to the Ranges. There is automation with offset and counta. StartDEMO: Adding Interactive Elements with Form Controls. There are changes over time. StartDEMO: Building a Dynamic Dashboard is the first part. The second part of PreviewDEMO: Building a Dynamic Dashboard is here. StartDEMO: Dynamic Value-Based Formatting. PreviewDEMO: Dynamically Highlighting a Data Series. StartDEMO: building a custom chart. StartDEMO: building a custom gauge chart. StartDEMO shows Percentages with Arrays. StartQUIZ: Next-Level Data They are wrapping up. The preview is from Maven Analytics.