Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Skip to search results
Connect to (import) an OLAP database
Show All Hide All You can use an Office Data Connection (.odc) file to connect to an Online Analytical Processing (OLAP) database. On the Data tab, in the Get E...
Create or delete a PivotTable or PivotChart report
Insert or delete a PivotTable or PivotChart report to summarize and analyze data in Excel 2007, and display a visual presentation of PivotTable data in a PivotC...
Demo: Explore Adventure Works in Excel by using an OLAP PivotTable report
This video shows how to use a PivotTable report to analyze data that is connected to an external data source in Excel 2007.
Design the layout and format of a PivotTable report
After you create a PivotTable report and have added the fields that you want, you often want to enhance the layout and format of the report to improve readabili...
Pivot data in a PivotTable or PivotChart report
Rearrange or pivot the data in a PivotTable report to view it from different angles in Excel 2007.
PivotTable I: Get started with PivotTable reports in Excel 2007
Overview Make sense out of data . Learn about Microsoft Office Excel 2007 PivotTable reports, a fast and powerful way to analyze data and answer questions you h...
PivotTable II: Filter PivotTable report data in Excel 2007
Overview Learn how to filter data in PivotTable reports with Microsoft Office Excel 2007. After completing this course you will be able to: Filter to hide an...
PivotTable III: Calculate data in PivotTable reports in Excel 2007
Overview Work with numbers in PivotTable reports in Microsoft Office Excel 2007 to help you see what your data means. After completing this course you will be ...
Select data in a PivotTable report
To apply formatting, copy data, or make changes to a PivotTable report, you can select either individual cells or data regions by using commands or by using a m...
Try Microsoft Office 2010
Give Microsoft Excel 2010 a spin by trying Office 2010 free for 60 days, or buy it now!