Microsoft Excel: Data Visualization, Excel Charts & Graphs

Data visualization is about creating clear, powerful narratives and striking a balance between design and function. This lecture reviews several key data visualization principles and demonstrates the "10-Second Rule" to test the effectiveness of a given chart or graph.

This lecture covers several examples of strong, weak, and just plain ugly data visualizations. Learn about the importance of using chart elements effectively, minimizing noise, and choosing the correct chart types. 

This lecture reviews the three key questions that you should ask yourself when designing data visualizations, including what type of data are you working with, what you're trying to communicate, and who will be the end user consuming the information.

This lecture serves as a quick review of chart customization in Excel 2016, including chart elements, layout options, colors and styles. 

This lecture reviews basic chart formatting options, including applying options in both the format ribbon and formatting pane as well as customizing individual chart elements. 

This lecture reviews when and how to change chart types in Excel, and demonstrates several methods of adding a secondary chart axis to visualize multiple data series.

This lecture demonstrates how to create and save new chart templates in Excel 2016.

This lecture reviews when, why, and how to use bar and column charts in Excel (basic, stacked, and clustered), including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture reviews when, why, and how to use histograms and pareto charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture reviews when, why, and how to use line charts and trendlines (linear, logarithmic, polynomial, etc) in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture reviews when, why, and how to use area charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture reviews when, why, and how to use pie, donut, and custom race track charts and visualizations in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture reviews when, why, and how to use scatter plots in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture reviews when, why, and how to use bubble charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture reviews when, why, and how to use box & whisker charts and graphs in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

Excel's Tree Map and Sunburst charts are ideal for visualizing hierarchical data that falls into natural groups and subgroups. In this demo, we'll explore movie titles and employee records to practice building and customizing our own tree maps and sunbursts.

This lecture reviews when, why, and how to use waterfall charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture reviews when, why, and how to use funnel charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture reviews when, why, and how to use radar charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016. This lecture also covers the importance of normalizing data sets to create consistent scales and more effective visualizations.

This lecture reviews when, why, and how to use stock charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture reviews when, why, and how to use cell-formatted heat maps in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture reviews when, why, and how to use surface and contour charts in Excel, including pro tips, sample data sets, and hands-on exercises in Excel 2016.

This lecture serves as a brief introduction to Excel's Power Map tool, and reviews a sample exercise showcasing state-level geo-spatial mapping in Excel 2016.

This lecture reviews when, why, and how to use combo charts in Excel, and reviews sample exercises showcasing combinations of line, column, and stacked area charts in Excel 2016.

This lecture reviews when, why, and how to use cell sparklines in Excel, including a hands-on demo in Excel 2016.

This Excel demo showcases how you can combine basic stacked column charts with custom graphics to create image overlay charts.

This Excel demo showcases how to use binary values and stacked column charts to highlight specific dates or date ranges within a chart.

This Excel demo showcases how to use OFFSET and COUNTA functions within named ranges to dynamically update charts as new data points are added.

This Excel demo showcases how to use scrollbar form controls, OFFSET functions, and named arrays to create charts that users can dynamically scroll and zoom.

This Excel demo shows you how to create a dynamic source array using basic SUMIFS functions, and combine form controls with data validation lists to create charts that show animation over time. 

In this Excel demo, users will populate a sample dashboard using SUMIFS functions, data validation lists, custom conditional formatting rules, and combo charts.

This Excel demo builds on the previous dashboard example, and showcases how to create dynamic charts and graphs that can display different metrics based on user-selected values.

This Excel demo showcases how to create formula-based chart formatting rules to highlight data points based on underlying values.

In this Excel demo, users will learn how to create charts and graphs that dynamically highlight specific data series based on user-selected values.

This Excel demo is all about using combo charts and creative formatting to design a custom pacing chart.  

In this Excel demo, we'll combine a donut chart with a scatter plot and incorporate some trigonometry functions to build a custom gauge & needle effect.

This Excel demo showcases how array functions and scatter plots can be used to build a custom percentage visualization built from 100 individual data markers.