VTEC Training
Course Code: 876
50433 PowerPivot for End Users
VTEC Training
Portland,
ME
Class Dates:
6/14/2023
8/16/2023
Length:
2 Days
Cost:
$695.00
Class Time:
Technology:
Office
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training
Overview
- 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
- 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
Prerequisites
- Before attending this course, students must have:
- General Excel and Report building skills.
Course Details
- 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