Course
digicode: ME3
Visualizing Data with Excel
A picture tells more than words or numbers. Learn how to visualize your numbers and data using Excel charts, sparklines, conditional formatting, and other techniques.
Duration
1 day
Price
700.–
Course documents
Digital digicomp courseware
Course facts
Download as PDF- Visualizing figures and using different types of diagrams to achieve your goals
- Understanding and using special charts, such as waterfall, map, and funnel charts
- Using histograms
- Creating compelling visualizations
1 Basics
- Using Charts
- Chart Elements
2 Important Chart Types
- Column and Bar
- Line and Area
- Scatter (XY)
- Pie and Doughnut
3 Creating and Designing Charts
- Planning and Creating Charts
- Arranging Data
- Using Chart Layouts
- Creating Chart Templates
- Creating and Formatting Sparklines
4 Formatting Chart Elements
- Deleting, Moving, and Formatting Chart Elements
5 Labeling Charts
- Inserting and Formatting Titles, Data Tables, and Legends
- Labeling Data and Axes
6 Modifying Chart Appearance
- Changing the Data Range
- Changing the Chart Type
- Creating Combo Charts with a Secondary Axis
- Modifying Axes
- Using Gridlines
7 Special Charts
- Pie of Pie / Bar of Pie
- Half Pie / Doughnut
- Bubble Charts
- Funnel, Waterfall, and Stock Charts
- Hierarchy Charts (Treemap, Sunburst, Histogram, Pareto, Box & Whisker)
- Map Charts
8 Trendlines and Error Indicators
- Creating and Formatting Trendlines
- Displaying Error Bars including Break-Even
9 Dynamic Charts
- Formatting as a Table
- Filtering Data
10 Special-Purpose Charts
- Gantt
- Waterfall
- Funnel
11 Alternatives to Classic Charts
- Data Visualization with Sparklines
- Charts Created with Symbols
This course is aimed at people who want to gain in-depth knowledge of charts to skillfully visualize their data.
Practical experience with Excel as well as knowledge according to our Excel courses: