Fully Customizable Courseware For Trainers
Microsoft Excel 2016 PowerPivot
DOWNLOAD A FREE SAMPLE
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
Everything you need to deliver amazing training
Each courseware title is a trainers' kit that comes with the following course components:
Instructor Guide
Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.
Student Manual
Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable Student Manual gives each participant the ?student? version of the course you will be teaching.
Exercise Workbook
Velsoft offers an Exercise Workbook (also customizable) that is specific to the course you are offering. You can choose whether this is something you would like to present to your students.
Sample Files
Pre-made Sample Exercise Files are provided for use with the Lab Workbook so that you, as the trainer, do not have to prepare activity working files.
PowerPoint Deck
Courseware from Velsoft is designed to give you everything you need for use in the classroom or for your workshop. This includes the PowerPoint versions of all the courses, prepared for you in advance.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes the most important elements in each courseware title down to two pages.
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.
