Introducing PowerPivot for Excel

Microsoft SQL Server PowerPivot for Microsoft Excel (PowerPivot for Excel) is a data analysis tool that delivers unmatched computational power directly within the application that you already know and love—Microsoft Excel. PowerPivot for Excel Help will get you up to speed and enable you to be productive right away.

• For more information about PowerPivot for Excel, including articles, videos, and blog posts, see the PowerPivot for Excel page on TechNet.

• For PowerPivot community documentation, see the PowerPivot section on TechNet Wiki.

• For answers to frequently asked questions about PowerPivot for Excel, see PowerPivot FAQ on TechNet Wiki.

• To engage in community conversations, see the PowerPivot for Excel forum.

Getting Started

We recommend that you read the following topics and work through the tutorial before moving on to the rest of the content.

• Install PowerPivot for Excel

• Learn About PowerPivot Capabilities

• Take a Tour of the PowerPivot UI

• Watch Videos About PowerPivot Tasks

• PowerPivot for Excel Tutorial Introduction

If you are an IT administrator and you want to learn about how PowerPivot for Excel and PowerPivot for SharePoint can be used in your organization, see PowerPivot Overview for IT Administrators.

Using Reference Content

The following links provide access to the PowerPivot for Excel reference content, including the UI reference and the reference for Data Analysis Expressions (DAX) Language.

• UI Reference

  • PowerPivot Tab Overview

  • PowerPivot Window: Home Tab

  • PowerPivot Window: Design Tab

  • PowerPivot Window: Linked Tables Tab

  • PowerPivot Window: Keyboard Shortcuts

• DAX Reference

  • Data Analysis Expressions (DAX) Overview

  • Data Analysis Expressions Reference