Highline Excel 2016 Class 15

Excel Charts to Visualise Data: Comprehensive Lesson 11 Chart Examples

DESCRIPTION

In this video learn about:
(00:28) Define Charts. What do Charts do?
(01:12) Effective Charts: No Chart Junk. Example of Chart Junk.
(02:54) Types of Charts: 11 different chart types.
(06:55) Terminology for Chart Elements:
(08:15) Column Charts
(12:15) Bar Charts
(13:41) Pie Charts
(14:25) Stacked Column Charts
(14:25) Clustered Column Charts
(17:44) Histogram. Two Examples: 1) Retail Sales Data Histogram with FREQUENCY Array Function. 2) Count Web Transactions by Hour with PivotTable.
(28:45) Line Charts. Time Series Chart.
(31:54) X-Y Scatter for Sample Data.
(34:45) Break Even Chart X-Y Scatter
(46:05) Combo Charts
(47:30) Bubble Chart
(51:19) Summary

WORKBOOKS

Download “Highline Excel 2016 Class 15” Highline-Excel-2016-Class-15.zip – Downloaded 27 times – 4 MB







Be the first to comment

Leave a Reply