Module 1: Reporting in Excel
This module examines how you can plan for an effective deployment strategy by identifying the phases of the Enterprise Desktop life-cycle. It also introduces methods used to assess readiness to ensure your network environment can efficiently and effectively deploy the Windows 10 client operating system.
Lessons
Lessons
- Filtering and Formatting Data
- Charts
Lab : Create an Excel report
- Filtering Excel Data
- Formatting Excel Data
- Create excel Charts
– See fewer details
Module 2: Excel Tables
This module looks at the classic Excel data model and at ways to extend it.
Lessons
Lessons
- Excel Data Tables
- Summarizing Data
Lab : Create an Excel Table
- Create an Excel Table
- Summarize Excel Data
+ See more details
Module 3: Pivot Tables and Pivot Charts
This module describes pivot tables and pivot charts and how to work with them.
Lessons
Lessons
- Pivot Tables
- Pivot Charts
- Editing Pivot Tables and Pivot Charts
Lab : Importing Data from a CSV File
- Creating a Pivot Table
- Creating a Pivot Chart
- Editing Pivot Tables and Pivot Charts
+ See more details
Module 4: Dashboards
This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot tables.
Lessons
Lessons
- Creating a Dashboard
- Data Analysis in Excel Pivot Tables
Lab : Create a Dashboard
- Arranging Tables and Charts
- Slicing Data
- Data Analysis
+ See more details
Module 5: Hierarchies
This module describes hierarchies and time data.
Lessons
Lessons
- Hierarchies
- Time Data
Lab : Creating Hierarchies
- Create a Hierarchy
- Configure Time data
- Create an Animated Time Chart
+ See more details
Module 6: The Excel Data Model
This module explores the Excel data model and looks at ways of extending it.
Lessons
Lessons
- Using an Excel Data Model
- External Data
Lab : Explore an Excel Data Model
- Add Multiple Tables
- Create Relationships
- Add External Data
+ See more details
Share with friends