Excel 2013 PowerPivot for End Users

Course Number: 55084A

• Vendor: Microsoft
• Category: Desktop Applications Courses
• Outline: Excel 2013 PowerPivot for End Users PDF
• Prerequisites
• List Price

Description

PowerPivot for Excel is an add-in that you can use to perform powerful data analysis in Excel 2013, bringing self-service business intelligence to your desktop. . This course is intended for all business professionals including IT professional, developers, managers, project leads, project managers, and team leads, but we do not expect coding skills
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 Power View, Power Query and Power Map.
You will also explore how PowerPivot workbooks can be integrated with SharePoint 2013

Prerequisites

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

List Price

$695.00