Fully Customizable Courseware For Trainers
Microsoft Excel 2010: PowerPivot
DOWNLOAD A FREE SAMPLE
This customizable Microsoft Excel 2010: PowerPivot two-day training package focuses on the PowerPivot add-in for Microsoft Excel 2010. When you purchase these training materials, you’ll’see lessons on:
- Getting Started with PowerPivot
- Manipulating PowerPivot Data
- Creating PowerPivot Reports
- Using DAX Functions
- Distributing PowerPivot Data
P.S.: If you’re interested in Microsoft Excel 2010 training, take the opportunity to talk to one of our specialized training consultants, who can tell you?all about the other great programs we offer!
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1: Getting Started with PowerPivot
TOPIC A: Explore the PowerPivot Application
PowerPivot
The PowerPivot Window
The PowerPivot Ribbon Interface
PowerPivot Worksheets
Activity 1-1
TOPIC B: Import Data from Various Data Sources
PowerPivot Data Sources
Data Feeds
The Table Import Wizard
Data Types
How to Import Data From Various Data Sources
Activity 1-2
TOPIC C: Refresh Data from a Data Source
Data Refresh
Connections
How to Refresh Data from a Data Source
Activity 1-3
TOPIC D: Create Linked Tables
Linked Tables
How to Create Linked Tables
Activity 1-4
Summary
Review Questions
Lesson 2: Manipulating PowerPivot Data
TOPIC A: Organize and Format Tables
PowerPivot Tables
How to Organize and Format Tables
Activity 2-1
TOPIC B: Create Calculated Columns
Calculated Columns
PowerPivot Formulas
How to Create Calculated Columns
Activity 2-2
TOPIC C: Sort and Filter PowerPivot Data
Sort Options
Filter Options
How to Sort and Filter PowerPivot Data
Activity 2-3
TOPIC D: Create and Manage Table Relationships
Table Relationships
Types of Relationships
The Create Relationship Dialog Box
The Manage Relationships Dialog Box
How to Create and Manage Table Relationships
Activity 2-4
Summary
Review Questions
Lesson 3: Creating PowerPivot Reports
TOPIC A: Create PivotTables
PivotTables
Flattened PivotTables
The PowerPivot Field List Pane
How to Create a PivotTable
Activity 3-1
TOPIC B: Create PivotCharts
PivotCharts
PivotChart Types
How to Create PivotCharts
Activity 3-2
TOPIC C: Filter Data Using Slicers
Slicers
How to Filter Data Using Slicers
Activity 3-3
TOPIC D: Present PivotTable Data Visually
Sparklines
Types of Sparklines
The Sparkline Tools – Design Contextual Tab
Conditional Formatting
Conditional Formats
How to Present PivotTable Data Visually
Activity 3-4
Summary
Review Questions
Lesson 4: Using DAX Functions in PowerPivot
TOPIC A: Manipulate PowerPivot Data Using DAX Functions
Measures
DAX Functions
Aggregate Functions
How to Manipulate PowerPivot Data Using DAX Functions
Activity 4-1
TOPIC B: Extract Data from Tables Using Functions
Filter Functions
How to Extract Data From Tables Using Functions
Activity 4-2
TOPIC C: Work with Time Dependent Data
Time Intelligence Functions
How to Work with Time Dependent Data
Activity 4-3
Summary
Review Questions
Lesson 5: Distributing PowerPivot Data
TOPIC A: Protect Reports
Workbook Protection
Worksheet Protection
How to Protect Reports
Activity 5-1
TOPIC B: Save Reports in Different File Formats
File Formats
How to Save Reports in Different File Formats
Activity 5-2
Summary
Review Questions
Lesson Labs
Lesson 1
Lesson Lab 1-1
Lesson Lab 1-2
Lesson 2
Lesson Lab 2-1
Lesson Lab 2-2
Lesson 3
Lesson Lab 3-1
Lesson Lab 3-2
Lesson 4
Lesson Lab 4-1
Lesson 5
Lesson Lab 5-1
Course Wrap-Up
Post-Course Assessment
Course Summary
Appendices
Keyboard Shortcut Quick Reference Sheet
Glossary
Index
This customizable Microsoft Excel 2010: PowerPivot two-day training package focuses on the PowerPivot add-in for Microsoft Excel 2010. When you purchase these training materials, you’ll’see lessons on:
- Getting Started with PowerPivot
- Manipulating PowerPivot Data
- Creating PowerPivot Reports
- Using DAX Functions
- Distributing PowerPivot Data
P.S.: If you’re interested in Microsoft Excel 2010 training, take the opportunity to talk to one of our specialized training consultants, who can tell you?all about the other great programs we offer!
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1: Getting Started with PowerPivot
TOPIC A: Explore the PowerPivot Application
PowerPivot
The PowerPivot Window
The PowerPivot Ribbon Interface
PowerPivot Worksheets
Activity 1-1
TOPIC B: Import Data from Various Data Sources
PowerPivot Data Sources
Data Feeds
The Table Import Wizard
Data Types
How to Import Data From Various Data Sources
Activity 1-2
TOPIC C: Refresh Data from a Data Source
Data Refresh
Connections
How to Refresh Data from a Data Source
Activity 1-3
TOPIC D: Create Linked Tables
Linked Tables
How to Create Linked Tables
Activity 1-4
Summary
Review Questions
Lesson 2: Manipulating PowerPivot Data
TOPIC A: Organize and Format Tables
PowerPivot Tables
How to Organize and Format Tables
Activity 2-1
TOPIC B: Create Calculated Columns
Calculated Columns
PowerPivot Formulas
How to Create Calculated Columns
Activity 2-2
TOPIC C: Sort and Filter PowerPivot Data
Sort Options
Filter Options
How to Sort and Filter PowerPivot Data
Activity 2-3
TOPIC D: Create and Manage Table Relationships
Table Relationships
Types of Relationships
The Create Relationship Dialog Box
The Manage Relationships Dialog Box
How to Create and Manage Table Relationships
Activity 2-4
Summary
Review Questions
Lesson 3: Creating PowerPivot Reports
TOPIC A: Create PivotTables
PivotTables
Flattened PivotTables
The PowerPivot Field List Pane
How to Create a PivotTable
Activity 3-1
TOPIC B: Create PivotCharts
PivotCharts
PivotChart Types
How to Create PivotCharts
Activity 3-2
TOPIC C: Filter Data Using Slicers
Slicers
How to Filter Data Using Slicers
Activity 3-3
TOPIC D: Present PivotTable Data Visually
Sparklines
Types of Sparklines
The Sparkline Tools – Design Contextual Tab
Conditional Formatting
Conditional Formats
How to Present PivotTable Data Visually
Activity 3-4
Summary
Review Questions
Lesson 4: Using DAX Functions in PowerPivot
TOPIC A: Manipulate PowerPivot Data Using DAX Functions
Measures
DAX Functions
Aggregate Functions
How to Manipulate PowerPivot Data Using DAX Functions
Activity 4-1
TOPIC B: Extract Data from Tables Using Functions
Filter Functions
How to Extract Data From Tables Using Functions
Activity 4-2
TOPIC C: Work with Time Dependent Data
Time Intelligence Functions
How to Work with Time Dependent Data
Activity 4-3
Summary
Review Questions
Lesson 5: Distributing PowerPivot Data
TOPIC A: Protect Reports
Workbook Protection
Worksheet Protection
How to Protect Reports
Activity 5-1
TOPIC B: Save Reports in Different File Formats
File Formats
How to Save Reports in Different File Formats
Activity 5-2
Summary
Review Questions
Lesson Labs
Lesson 1
Lesson Lab 1-1
Lesson Lab 1-2
Lesson 2
Lesson Lab 2-1
Lesson Lab 2-2
Lesson 3
Lesson Lab 3-1
Lesson Lab 3-2
Lesson 4
Lesson Lab 4-1
Lesson 5
Lesson Lab 5-1
Course Wrap-Up
Post-Course Assessment
Course Summary
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 manual gives each participant the student version of the course you will be teaching.
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.
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.
