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.

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

• Create Your First PowerPivot Workbook (Tutorial)

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.

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

  • Excel Window: PowerPivot Features

  • PowerPivot Window: Home Tab

  • PowerPivot Window: Design Tab

  • PowerPivot Window: Linked Tables Tab

  • PowerPivot Window: Keyboard Shortcuts

• DAX Reference

  • Getting Started with Data Analysis Expressions (DAX)

  • DAX Reference