This 2-day instructor led course teaches how to use PowerPivot to access data source and relationships; use Power Pivot DAX expressions; and generate and format reports. You will also explore how PowerPivot workbooks can be integrated with SharePoint 2010.
A simple introduction module.
- Understand your course, classroom, classmates, facility and instructor.
In this module we take a look at a PowerPivot Introduction. 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
After completing this module, students will be able to import various data sources into PowerPivot, and will understand how to clean imported data.
- Lessons: Supported Data Sources
- Lab : Loading Data Sources
- Lab : Cleaning Data in PowerPivot
- Lab : Creating Relationships between Data Sources
After completing this module, students will be able to describe all the new PowerPivot Expressions, as well as use and apply many of the PowerPivot Expressions
- Lessons: PowerPivot Expressions
- Lab : Create a Time Table for future labs
- 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
After completing this module, students will be able to describe the different Report types in PowerPivot and be able to create Slicers and Sparklines for more engaging reports.
- Lessons: PowerPivot Reports
- Lab: Creating Reports
After completing this module, students will be able to describe the integration points between PowerPivot and SharePoint 2010, and be able to publish and setup workbook data refresh in SharePoint 2010.
- Lessons: Reports and Email
- Lab: Installing PowerPivot for SharePoint 2010
- Lab: Configuring PowerPivot For SharePoint 2010
- General Excel and Report building skills.
- Explore every aspect of using Microsoft PowerPivot.
Register
Not currently scheduled
Fast track the availability of this course.
Add to watch list or call 1300 794 006.
Add to watch list or call 1300 794 006.
Request a Quote
About Microsoft On-Demand Learning
Build your Microsoft technical expertise while balancing the demands of your schedule. The new MOC On-Demand series courses combine high-quality video lectures, live hands-on labs and knowledge-checks in a self-paced format to help you build skills as your schedule allows—all at once or five minutes at a time.
MOC On-Demand at a Glance
Self-Paced Learning
Immediate Feedback on Mastery
SATV Eligible
Direct From the Source
Learn Anywhere Anytime
Live Hands-on
Labs
