Microsoft Learning Logo is a registered trademark of Microsoft. All rights reserved.

Microsoft Excel 2016: Creating Dashboards and Learning Power Pivot

Schedule

Start End Duration Location Details

Course Details

Microsoft Excel 2016: Creating Dashboards using Pivot Tables and Learning Power Pivot

Course code: Custom761

Duration: 1 Day

Course Outlines:

Lesson 1: Automating Workbook Functionality
 Topic A: Apply Data Validation
 Topic B: Work with Forms and Controls

Lesson 2: Applying Conditional Logic
 Topic A: Use Lookup Functions
 Topic B: Combine Functions

Lesson 3: Analyzing Data with PivotTables, PivotCharts, and Slicers
 Topic A: Create a PivotTable
 Topic B: Analyze PivotTable Data
 Topic C: Present Data with PivotCharts
 Topic D: Filter Data by Using Slicers

Lesson 4: Getting Started with Power Pivot
 Topic A: Enable and Navigate Power Pivot
 Topic B: Manage Data Relationships

Lesson 5: Visualizing Power Pivot Data
 Topic A: Create a Power Pivot Report
 Topic B: Create Calculations in Power Pivot

Lesson 6: Working with Advanced Functionality in Power Pivot
 Topic A: Create a Key Performance Indicator
 Topic B: Work with Dates and Time in Power Pivot