Creating a SQL Server 2012 playground (part IX)

Introduction

In this blogpost I'll explain the installation of Powerpivot for Excel installation (download the 64 bit version). You can download the software from MSDN. Powerpivot is an add-in for Excel 2010 and  can be used to include Powerpivot data in Excel. There is also the ability to share the analysis with Microsoft Sharepoint 2010.

This blogpost is one in a series of blogposts:

• Creating a VM environment with virtualbox (part I).

• Configuration of the domain controller (part II).

• Creating AD users and installing SQL Server 2012 (part III).

• Installation of Sharepoint (part IV).

• Adding the tabular mode instance to the SQL Server installation (part V).

• Adding the powerpivot mode instance to the SQL Server installation (part VI).

• Configuring SharePoint Central Administration (part VII).

• Installing Reporting Services Sharepoint mode as Single Server Farm (part VIII).

• Installing MS SQL Server Powerpivot for Excel 2010 (part IX).
• Installation of SSDT and the SSDT Power tools (part X).
• Installation of Contoso and AdventureWorks databases (part XI).
• Installation of Master Data Services (part XII).
• Installation of Data Quality Services (part XIII).
• etc.

Installation of Powerpivot for Excel

Installation of Microsoft office
The first step in this blogpost is installing  Microsoft Office 2010. If you run the setup process automatically it will install the 32 bit version. Therefore execute the setup in the 64 bits subfolder of the installation iso.  

Install .net framework 4.0
The next step is the installation of .net Framework 4.0. You can download this from the microsoft download center. There is not much to say about the installation. Just install the .net framework and you're done.

Installation of Visual Studio 2010 Tools for Office Runtime
The installation of Visual Studio 2010 Tools for Office Runtime is also very straightforwared. The Visual Studio 2010 Tools for Office Runtime can be downloaded from Microsoft download center too.

Installation of Powerpivot for Excel
The installation of Powerpivot for Excel is also a very straightforward process and easily done

Check it out
Finally, let's check the installation of powerpivot by opening Excel and click on the Powerpivot ribbon.

Conclusion

In this blogpost I've described an easy installation of Microsoft Office and Powerpivot

Greetz,
Hennie