2010
Pluralsight
Robert Cain
2:23
English

Learn how to use Microsoft PowerPivot to do self service Business Intelligence. This course will guide you through importing data, working with it, then creating pivot tables and charts all in Excel 2010.

Beginning PowerPivot
Introduction
PowerPivot - Filling the Gap
A Tour of PowerPivot
Importing Data Into PowerPivot
Working With Imported Data
Creating Pivot Tables
Creating Pivot Charts
Using Slicers
Summary
Working With Data In PowerPivot
Introduction
Limiting Data
Refreshing Data
Renaming Columns
Hiding Columns
Getting Data from Excel
Combining Data from Multiple Sources
Summary
Working With PowerPivot Pivot Tables
Introduction
Handling Dates
Showing the same data many ways
Adding new measures
Formatting your Pivot table
Sparklines
Summary
Working With PowerPivot Pivot Charts
Introduction
Basic Chart Creation
Chart Properties
Chart Types
Formatting Numbers
Advanced Chart Formatting
Dashboards
Summary

Download File Size:258.7 MB

---