Microsoft Office Tutorials and References
In Depth Information
■ Sharepoint standalone installations as well as a developer edition that runs on Windows 7 are supported for
powerpivot. You need a Sharepoint server farm with excel Services, Secure Store Services, and Claims to Windows token
Services running on the same application server where you plan to set up powerpivot.
The Excel client will include a new PowerPivot menu, as shown in Figure 5-43 . It is highly recommended to use
the 64-bit edition of Excel 2013 as well as a 64-bit operating system.
Figure 5-43. The PowerPivot tab in Excel
Clicking on Manage opens a new design window. With PowerPivot, you can simply copy and paste a large chunk
of data into the Excel sheet and perform an analysis on the data. You can also connect to other data sources and
perform the same operations as you can perform with Excel.
Figure 5-44 shows various data sources that can be connected to PowerPivot. You can access the list of data
sources from the From Other Sources button.
Search JabSto ::