Главная
Study mode:
on
1
Introduction
2
Insert chart
3
Modify chart selection
4
Avoid totals in charts
5
Select non-contiguous data
6
Change chart type
7
Chart shortcut keys
8
Chart titles
9
Chart elements
10
Styles and colors
11
Filter
12
Chart design tab
13
Chart format tab
14
Chart templates
15
Advanced options
16
Adjust position and size
17
Switch row and column
18
Sparklines
19
Pie charts
20
Pivot charts
21
Wrap up
Description:
Master the art of creating and customizing data visualizations in Excel through this comprehensive 25-minute tutorial. Learn essential techniques for generating various chart types including line, pie, bar, and pivot charts while exploring formatting options and best practices. Discover time-saving shortcuts, understand how to properly select and organize data for charts, and explore advanced features like sparklines and pivot charts. Follow along with hands-on exercises using the provided sample workbook to create professional-looking visualizations, modify chart elements, apply styles and colors, and implement filters. Gain practical knowledge about chart positioning, sizing, and template creation, enabling you to effectively communicate data insights through polished visual presentations.

Creating and Formatting Charts in Microsoft Excel - A Complete Tutorial

Kevin Stratvert
Add to list
00:00
-00:28