Course Description:
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.
Course Topics
Module 1: Overview
A simple introduction module.
After completing this module, students will be able to: Understand your course, classroom, classmates, facility and instructor.
Module 2: PowerPivot Introduction
In this module we take a look at the lessons of the module!
Lessons
Lab : Installing PowerPivot
After completing this module, students will be able to:
- Install PowerPivot for Excel
- Be able to navigate the PowerPivot windows
- Understand the new features of Excel 2010
Module 3: PowerPivot Data Sources
In this module we take a look at the lessons of the module!
Lessons
Lab : Loading Data Sources
Lab : Cleaning Data
Lab : Creating Relationships
After completing this module, students will be able to:
- Import various data sources into PowerPivot
- Understand how to clean imported data
Module 4: PowerPivot Functions
In this module we take a look at the lessons of the module!
Lessons
Lab : Create a Time Table
Lab : Using DATE Functions
Lab : Using TIME INTELLIGENCE Functions
Lab : Using STATISTICAL Functions
Lab : Using VALUE Functions
Lab : Using TEXT Functions
After completing this module, students will be able to:
- Be able to describe all the new PowerPivot Expressions
- Use and apply many of the PowerPivot Expressions
Module 5: Building Reports using PowerPivot
In this module we take a look at the lessons of the module!
Lessons
Lab : Creating Reports
After completing this module, students will be able to:
- Describe the different Report types in PowerPivot
- Be able to create Slicers and Sparklines for more engaging reports
Module 6: PowerPivot for SharePoint 2010
In this module we take a look at the lessons of the module!
Lessons
- Reports and Email
- PowerPivot for SharePoint 2010
Lab : Installing PowerPivot for SharePoint 2010
Lab : Configuring PowerPivot For SharePoint 2010
After completing this module, students will be able to:
- Describe the integration points between PowerPivot and SharePoint 2010
- Be able to publish and setup workbook data refresh in SharePoint 2010
Target Audience
Advanced Excel users, users that want to gain familiarity with PowerPivot to build compelling reports.
Prerequisites
Before attending this course, students must have:
- General Excel and Report building skills
Inclusions
With CCS Learning Academy, you’ll receive:
- Certified Instructor-led training
- Official Training Seminar Student Handbook
- Collaboration with classmates (not currently available for self-paced course)
- Real-world learning activities and scenarios
- Exam scheduling support*
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
*For more details call:Â 858-208-4141Â or email:Â training@ccslearningacademy.com; sales@ccslearningacademy.com
English 
Spanish