Course Details
Course Code: Instructor-led
Audience
Those who wish to Excel their knowledge in creating charts in a different type. And explore in-depth.
Prerequisites
- Knowledge in windows
- Microsoft Excel
- Microsoft Word
- Microsoft Power Point
Methodology
Hands on creation and lab Exercises with simple case study.
Course Objectives
Upon completion of this program, participants should be able to:
- Create stunning data visualizations instantly with Excel 2016’s new Recommended Charts
- Use charts to instantly reveal trends, differences, and relationships
- Quickly generate combo charts that once required complex, frustrating procedures
- Use spark lines to imbue worksheets with more context and insight
Create Waterfall and Thermometer Charts.
Outlines
Module 1: Creating Chart in Microsoft Excel 2016
- Creating 3-D Charts and Make as a Default
- 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 Component Comparisons
- Adding a Second Series to Show a Comparison
- Creating Waterfall Chart
Module 3: Pie Charts
- Creating Pie Charts
- Rotating a Pie Charts
- Highlighting One Slice of a Pie Chart
- Creating Pie of Pie Chart
Module 4: Creating Charts that show Relationships
- Creating a Scatter Chart
- Showing Scatter Chart Labels in Excel 2010
- Joining the Points in a Scatter Chart with Lines
- Adding a Third Dimension with a Bubble Chart
- Using Paired Bar to Show Relationship
Module 5: Advanced Chart Techniques
- Mixing Two Chart Types on a Single Chart
- Creating Bullet Chart
- Creating a Thermometer Chart
- Creating a Benchmark chart
- Creating a Delta Chart
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
