SkillSoft Explore Course – Lambers, Inc.

BUY NOW! STARTING AT ONLY $299!

Productivity & Collaboration Tools Microsoft Office 2013 Excel 2013 Microsoft Office 2013: Expert Excel (No Assessments)

Power Pivot allows you to create advanced PivotTables and PivotCharts in Excel 2013. Discover how to work with Power Pivot, so you can analyze data from a variety of sources.

Asset ID	ds_msex2013_15_enus
Course Type	Video Course
Course Category	Microsoft Office 2013

Objectives
Excel 2013: The Power Pivot Add-in Activating Power Pivot Importing your database Creating Power Pivot relationships Formatting your Power Pivot tables Applying data formats in Power Pivot tables Sorting the data in your Power Pivot table Filtering data in your Power Pivot table Creating a calculated field in your Power Pivot table Creating custom views in your Power Pivot table Updating your Power Pivot tables Creating an advanced PivotTable Creating an advanced PivotChart Creating a dashboard

Objectives

Excel 2013: The Power Pivot Add-in

Activating Power Pivot
Importing your database
Creating Power Pivot relationships
Formatting your Power Pivot tables
Applying data formats in Power Pivot tables
Sorting the data in your Power Pivot table
Filtering data in your Power Pivot table
Creating a calculated field in your Power Pivot table
Creating custom views in your Power Pivot table
Updating your Power Pivot tables
Creating an advanced PivotTable
Creating an advanced PivotChart
Creating a dashboard