# PowerPivot for Excel Tutorial Introduction

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

Welcome to the Microsoft PowerPivot for Excel tutorial for creating your first PowerPivot workbook.

PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance. To complete this tutorial, you need the PowerPivot for Excel Tutorial Sample Data.

## Tutorial Scenario

In this tutorial, you will complete a scenario for analyzing international electronic sales. The fictitious company, Contoso, is used for all examples.

Imagine you are an analyst for an electronics company called Contoso Electronics. You want to examine sales over time and compare sales by product type, year, and country. During the course of this tutorial, you will use PowerPivot to:

• Import data from multiple sources.

• Create relationships between data from different sources.

• Rename columns, and create calculated columns.

• Create hierarchies.

• Create PivotTables and PivotCharts.

• Create a measure and KPI.

• Create perspectives.

• Save the resulting Excel spreadsheet.

## Prerequisites

Make sure that the following are installed:

• Microsoft PowerPivot for Excel

• Microsoft Excel 2010

For more information, see Install PowerPivot for Excel. Additionally, to follow along with the tutorial, you need the PowerPivot for Excel Tutorial Sample Data – Version 2. The sample data that is used in this tutorial is from the fictional company Contoso and is stored in Access databases and Excel worksheets. If you prefer to import the same data from a SQL Server database instead, download and restore the full Contoso database to a server. Depending on the Contoso version, there could be minor differences in the data, but you should be able to complete the tutorial successfully.

### For Windows XP

In Windows Server and Windows 7, features in the PowerPivot window are available on a ribbon. In Windows XP, features are available from a set of menus. If you are using Windows XP and want to see how the menu commands relate to the ribbon commands, see The PowerPivot UI in Windows XP.

## What You Will Learn

This tutorial is divided into the following lessons:

## Next Step

To continue this tutorial, go to the next topic: Add Data to Your PowerPivot Workbook (Tutorial).

#### Concepts

Introducing PowerPivot for Excel