Excel 2010 PowerPivot for End Users

Course Number: 50433B

• Category: Desktop Applications Courses
• Prerequisites
• List Price

Description

This is a 2 day instructor-led course. PowerPivot for Excel is an add-in that you can use to perform powerful data analysis in Excel 2010, bringing self-service business intelligence to your desktop.
PowerPivot for Excel also includes a wizard that you can use to import data from different sources, ranging from large corporate databases on your intranet, to public data feeds, to spreadsheets and text files on your computer. But PowerPivot for Excel provides significantly different functionality from what is available in an Excel worksheet.
The data that you work on in the PowerPivot window is stored in an analytical database inside the Excel workbook, and a powerful local engine loads, queries, and updates the data in that database. The PowerPivot data can be further enriched by creating relationships between the tables in the PowerPivot window. And because PowerPivot data is in Excel, it is immediately available to PivotTables, PivotCharts, and other features in Excel that you use to aggregate and interact with data.
In addition to the graphical tools that help you to analyze your data, PowerPivot includes Data Analysis Expressions (DAX). DAX is a new formula language that extends the data manipulation capabilities of Excel to enable more sophisticated and complex grouping, calculation, and analysis.
You will also explore how PowerPivot workbooks can be integrated with SharePoint 2010

Prerequisites

To ensure your success, we recommend you first take the following courses or have equivalent knowledge:
-Microsoft Excel 2010 Level 1, Course No. EXL10-1
-Microsoft Excel 2010 Level 2, Course No. EXL10-2
-Microsoft Excel 2010 Level 3, Course No. EXL10-3

List Price

$750.00