Course Description
Overview:
Microsoft® Office Excel® 2016's capabilities for graphically presenting data go well beyond the use of simple chart types. This course will show you how to use sparklines and how to map Excel data to make visual sense of your complex information for any of your business needs.
Target Student:
This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features.
Course Content
Lesson 1: Creating Sparklines and Mapping Data
Topic A: Create Sparklines
- Sparklines
- Sparkline Types
- The Create Sparklines Dialog Box
- The Sparkline Tools Contextual Tab
- How to Create and Modify Sparklines
- Creating Sparklines
Topic B: Map Data
- The 3D Map Feature
- Data Structuring
- 3D Map Elements
- Tours
- How to Create a 3D Map and Tours
- Creating a 3D Map