Duration
1 day
Overview
This course offers a practical guide to several useful Excel charts and graphs for data visualization. User can learn how to create infographic-style charts, enhance the charts appearance, leverage built-in templates, represent data graphically, and combine different chart types on single sheet.
Learning Objectives
- Create interactive charts and graphs from your data
- Use charts to instantly reveal trends, differences, and relationships
- Quickly generate stunning data visualizations
Module 1: Creating Chart in Microsoft Excel
- Creating 3-D Charts
- Creating Stacked Column Chart
- Formatting Chart Plot Area and Chart Area
- Save as a Template
- Set as a Default chart
Module 2: Charts that show Differences
- Showing Positive and Negative Chart
- Creating Waterfall Chart
Module 3: Creating Charts that show Relationships
- Creating a Scatter Chart
- Showing Scatter Chart Labels in Excel
- Joining the Points in a Scatter Chart with Lines
- Adding a Third Dimension with a Bubble Chart
- Using Paired Bar to Show Relationship
Module 4: Advanced Chart Techniques
- Mixing Two Chart Types on a Single Chart
- Creating a Thermometer Chart
- Creating a Benchmark Chart
Module 5: Pivot Table
- Creating a Pivot Table
- Creating Chart Using Pivot Table
Module 6: Visualization and Other Non-Chart Methods
- Creating Chart Using Conditional Formatting
- Creating Chart Using the REPT Function
Module 7: Exporting Chart for Use Outside of Excel
- Presenting Excel Chart in Power Point or Word
- Copying a Chart as a Picture
- Presenting Chart on a Web
- Converting to XPS or PDF
Programme scope, delivery arrangements and suitability are confirmed during enquiry.