№ | Слайд | Текст |
1 |
 |
Use of Microsoft Office 2003 Excel Pivot TablesASQ Milwaukee Pre-Meeting Clinic Monday, May 21, 2012 Presented by: Jeff Stumpe |
2 |
 |
Presentation OverviewHow much time do you waste analyzing and manipulating data in Microsoft Excel 2003? If you don’t know how to use Pivot Tables, a lot!! Pivot Tables are Microsoft Excel’s premier analytical tool – the ideal feature for quickly creating summary information that can be easily manipulated with drag-and-drop techniques to show multiple levels of totals in a variety of layouts. Microsoft Excel users who need to analyze database-like data can only go so far with sorting, filtering, and inserting subtotals. Ways are needed to created multiple totals in columns and rows and have the capability to interchange these fields, add other fields and sort results without using lengthy command sequences and creating complicated formulas. |
3 |
 |
Adding the Pivot Table Menu to the Toolbar |
4 |
 |
The Pivot Table Menu OptionsNo Active Pivot Table Drop Down Active Pivot Table Drop Down |
5 |
 |
Creating the Pivot Table |
6 |
 |
Creating the Pivot TableSingle Cell Column Titles!!! |
7 |
 |
Creating the Pivot TableText or Number Data Columns Number Data Columns |
8 |
 |
Creating the Pivot Table – Pivot Table Field SettingsData Columns Only |
9 |
 |
Creating the Pivot Table – Pivot Table Field SettingsClick Drop Down for Selection/De-selection |
10 |
 |
Creating the Pivot Table – Pivot Table Field SettingsClick Sort Ascending to Re-order Column Data (Alpha-Numeric) |
11 |
 |
The Pivot Table Menu – Hiding Subtotals |
12 |
 |
The Pivot Table Menu – Hiding Detail |
13 |
 |
The Pivot Table Menu – Refresh DataUse When Changes Have Been Made to Source Data but No Changes Have Been Made to #Rows, #Columns |
14 |
 |
The Pivot Table Menu – Capture New Data |
15 |
 |
The Pivot Table Menu – Show Field List |
«Use of Microsoft Office 2003 Excel Pivot Tables» |
http://900igr.net/prezentacija/anglijskij-jazyk/use-of-microsoft-office-2003-excel-pivot-tables-59678.html