Fully Customizable Courseware For Trainers
Microsoft Excel 2016 PowerPivot
Deliver high-impact training with professionally designed, fully editable courseware you can brand, customize, and deliver in-person or online
$795.00
PowerPivot is an Excel add-in that allows for the creation of a more sophisticated data model than using Excel by itself. Introduce your students to this data modelling technology, which lets users to amalgamate large volumes of data from various sources, perform rapid information analysis, and easily share insights.
This builds on skills learned in the three-part Velsoft Excel 2016 courses, offering lessons covering the following topics:
- Getting Started with PowerPivot
- Manipulating PowerPivot data
- Creating PowerPivot reports
- Using DAX Functions in PowerPivot
- Distributing PowerPivot data
Each component in this Microsoft Excel 2016 PowerPivot training package is completely customizable. You can add your logo, rearrange lessons, create different examples, and much more. Each training package contains an instructor guide, student manual, quick reference guide, and PowerPoint slides.
Download a?free sample today and see how easy training can be.
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1:
Getting Started with PowerPivot
PowerPivot
The PowerPivot Window
The PowerPivot Ribbon Interface
PowerPivot Worksheets
Activity 1-1
PowerPivot Data Sources
Data Feeds
The Table Import Wizard
Data Types
How to Import Data From Various Data Sources
Activity 1-2
Data Refresh
Connections
How to Refresh Data from a Data Source
Activity 1-3
Linked Tables
How to Create Linked Tables
Activity 1-4
Summary
Review Questions
Lesson 2:
Manipulating PowerPivot Data
PowerPivot Tables
Managing Tables
How to Organize and Format Tables
Activity 2-1
Calculated Columns
PowerPivot Formulas
How to Create Calculated Columns
Activity 2-2
Sort Options
Filter Options
How to Sort and Filter PowerPivot Data
Activity 2-3
Table Relationships
Types of Relationships
The Create Relationship Dialog Box
The Manage Relationships Dialog Box
The Diagram View
How to Create and Manage Table Relationships
Activity 2-4
Summary
Review Questions
Lesson 3:
Creating PowerPivot Reports
PivotTables
Flattened PivotTables
The PowerPivot Field List Pane
Creating Key Performance Indicators
How to Create a PivotTable
Activity 3-1
PivotCharts
PivotChart Types
How to Create PivotCharts
Activity 3-2
Customize the Ribbon
Power Views
Activity 3-3
Slicers
How to Filter Data Using Slicers
Activity 3-4
Sparklines
Types of Sparklines
The Sparkline Tools – Design Contextual Tab
Conditional Formatting
Conditional Formats
How to Present PivotTable Data Visually
Activity 3-5
Summary
Review Questions
Lesson 4:
Using DAX Functions in PowerPivot
Measures
DAX Functions
DAX Variables
Aggregate Functions
How to Manipulate PowerPivot Data Using DAX Functions
Activity 4-1
Filter Functions
How to Extract Data From Tables Using Functions
Activity 4-2
Time Intelligence Functions
Create a Date Table
How to Work with Time Dependent Data
Activity 4-3
Summary
Review Questions
Lesson 5:
Distributing PowerPivot Data
Workbook Protection
Worksheet Protection
How to Protect Reports
Activity 5-1
File Formats
How to Save Reports in Different File Formats
Activity 5-2
Summary
Review Questions
Lesson Lab 1-1
Lesson Lab 1-2
Lesson Lab 2-1
Lesson Lab 2-2
Lesson Lab 3-1
Lesson Lab 3-2
Lesson Lab 4-1
Lesson Lab 5-1
Appendices
Keyboard Shortcut Quick Reference Sheet
Glossary
Index
 Select the format that works best for your organization or learners
Instructor-Led Training Kits
Complete training kit with everything you need to facilitate.
- Instructor Guide
- Participant Manual
- PowerPoint Slides
- Print-Ready Files
- Editable in Word/PowerPoint
- More
SCORM eLearning Courses
Ready-to-deploy eLearning for any SCORM-compliant LMS.
- SCORM 1.2 Package
- LMS Compatible
- Completion Certificates
- Progress Tracking
- Mobile Responsive
Storyline Source Files
Editable .story files for full customization in Articulate 360.
- Editable Source Files
- Articulate 360 Format
- Brand Customization
- Content Editing
- Interactive Elements
mos5004
What You Get
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.