Excel 2016 Charts Syllabus

Excel 2016 Charts

This course covers Excel 2016 Charts and consists of 11 topics.

Histograms – In this video we show how to use Excel 2016 to create much improved histograms.
Pareto Charts – In this video we show how to use Excel 2016 to create much improved Pareto charts.
Boxplots One Variable – In this video we show how to use Excel 2016 to create a Boxplot to summarize the results of the 1970 Draft Lottery.
Boxplots More Than One Variable – In this video we show how to use Excel 2016 to create a Boxplot that summarizes multiple test scores at three high schools.
Waterfall Chart – Time Series Data – In this video we show how to use an Excel 2016 Waterfall chart to summarize the progress of sales during a year.
Waterfall Chart – Revenue to Profit – In this video we show how to use an Excel 2016 Waterfall chart to summarize how various cost centers reduce Company Revenue and Profit.
Treemap Chart – Bookstore – In this video we use an Excel 2016 TreeMap or Mosaic chart to summarize hierarchical bookstore sales data.
Sunburst Chart – Bookstore – In this video we use an Excel 2016 Sunburst chart to summarize hierarchical bookstore sales data.
Sunburst Chart – Monthly Breakdown – In this video we use an Excel 2016 Sunburst chart to summarize quarterly and monthly sales data.
Treemap Chart -Restaurant – In this video we use the SUMIFS functions to prepare restaurant sales data and then summarize the sales data with a TreeMap chart.
Funnel Chart – In this video we show how to create a funnel chart which shows the winnowing of a pool of doners from prospects to bid doners
Learn More