Главная
Study mode:
on
1
) Define Charts. What do Charts do?
2
) Effective Charts: No Chart Junk. Example of Chart Junk.
3
) Types of Charts: 11 different chart types.
4
) Terminology for Chart Elements:
5
) Column Charts
6
) Bar Charts
7
) Pie Charts
8
) Stacked Column Charts
9
) Clustered Column Charts
10
) Histogram. Two Examples: 1) Retail Sales Data Histogram with FREQUENCY Array Function. 2) Count Web Transactions by Hour with PivotTable.
11
) Line Charts. Time Series Chart.
12
) X-Y Scatter for Sample Data.
13
) Break Even Chart X-Y Scatter
14
) Combo Charts
15
) Bubble Chart
16
) Summary
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Visualization
0:00 / 0:00
1 of 16

) Define Charts. What do Charts do?