50433 PowerPivot for End Users
CLASS DATE(s):
6/29/2020 - 6/30/2020
8/10/2020 - 8/11/2020

COURSE LENGTH: 2 Days

COURSE COST: $695.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

This 2-day Instructor Led course How to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. You will also explore how PowerPivot workbooks can be integrated with SharePoint 2010.

AUDIENCE AND PREREQUISITES

Advanced Excel users, users that want to gain familiarity with PowerPivot to build compelling reports.

At Course Completion After completing this course, students will be able to:

  • Explore every aspect of using Microsoft PowerPivot
Before attending this course, students must have:
  • General Excel and Report building skills.

  

*Course Cost listed does not include the cost of courseware or lunch, required in your registration. Please refer to your Enrollment Sales Order or Invoice for the additional cost. If you have any questions, please contact us (learn@vtec.org or 207-775-0244). Class subject to minimum enrollment.

COURSE TOPICS:


Module 1: Overview
A simple introduction module

Module 2: PowerPivot Introduction
PowerPivot Introduction
Lab : Installing PowerPivot

Module 3: PowerPivot Data Sources
Supported Data Sources
Lab : Loading Data Sources
Lab : Cleaning Data
Lab : Creating Relationships

Module 4: PowerPivot Functions
PowerPivot Expressions
Lab : Create a Time Table
Lab : Using DATE Functions
Lab : Using TIME INTELLIGENCE Functions
Lab : Using STATISTICAL Functions
Lab : Using VALUE Functions
Lab : Using LOGICAL and INFORMATION Functions
Lab : Using TEXT Functions

Module 5: Building Reports using PowerPivot
PowerPivot Reports
Lab : Creating Reports

Module 6: PowerPivot for SharePoint 2010
Reports and Email
PowerPivot for SharePoint 2010
Lab : Installing PowerPivot for SharePoint 2010
Lab : Configuring PowerPivot For SharePoint 2010