Excel Charts to Visualize Data - Comprehensive Lesson with 11 Chart Examples

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Explore the world of Excel charts in this comprehensive 52-minute video tutorial. Learn to define charts and their purpose, understand the importance of effective chart design without unnecessary clutter, and discover 11 different chart types. Master the terminology for various chart elements and dive into practical examples of column, bar, pie, stacked column, clustered column, histogram, line, X-Y scatter, break-even, combo, and bubble charts. Create histograms using the FREQUENCY array function and PivotTables, analyze time series data, and visualize sample and financial information. By the end of this lesson, gain the skills to effectively visualize data and create impactful Excel charts for various scenarios.

Syllabus

) Define Charts. What do Charts do?.
) Effective Charts: No Chart Junk. Example of Chart Junk..
) Types of Charts: 11 different chart types..
) Terminology for Chart Elements:.
) Column Charts.
) Bar Charts.
) Pie Charts.
) Stacked Column Charts.
) Clustered Column Charts.
) Histogram. Two Examples: 1) Retail Sales Data Histogram with FREQUENCY Array Function. 2) Count Web Transactions by Hour with PivotTable..
) Line Charts. Time Series Chart..
) X-Y Scatter for Sample Data..
) Break Even Chart X-Y Scatter.
) Combo Charts.
) Bubble Chart.
) Summary.