Без темы
<<  Use of assessment to monitor and attain learning goals in South Africa Anil Kanjee Use Watch folders to automatically add PDFs to Mendeley Desktop  >>
Use of Microsoft Office 2003 Excel Pivot Tables
Use of Microsoft Office 2003 Excel Pivot Tables
Presentation Overview
Presentation Overview
Adding the Pivot Table Menu to the Toolbar
Adding the Pivot Table Menu to the Toolbar
The Pivot Table Menu Options
The Pivot Table Menu Options
Creating the Pivot Table
Creating the Pivot Table
Creating the Pivot Table
Creating the Pivot Table
Creating the Pivot Table
Creating the Pivot Table
Creating the Pivot Table – Pivot Table Field Settings
Creating the Pivot Table – Pivot Table Field Settings
Creating the Pivot Table – Pivot Table Field Settings
Creating the Pivot Table – Pivot Table Field Settings
Creating the Pivot Table – Pivot Table Field Settings
Creating the Pivot Table – Pivot Table Field Settings
The Pivot Table Menu – Hiding Subtotals
The Pivot Table Menu – Hiding Subtotals
The Pivot Table Menu – Hiding Detail
The Pivot Table Menu – Hiding Detail
The Pivot Table Menu – Refresh Data
The Pivot Table Menu – Refresh Data
The Pivot Table Menu – Capture New Data
The Pivot Table Menu – Capture New Data
The Pivot Table Menu – Show Field List
The Pivot Table Menu – Show Field List

Презентация: «Use of Microsoft Office 2003 Excel Pivot Tables». Автор: Jeff Stumpe. Файл: «Use of Microsoft Office 2003 Excel Pivot Tables.ppt». Размер zip-архива: 885 КБ.

Use of Microsoft Office 2003 Excel Pivot Tables

содержание презентации «Use of Microsoft Office 2003 Excel Pivot Tables.ppt»
СлайдТекст
1 Use of Microsoft Office 2003 Excel Pivot Tables

Use of Microsoft Office 2003 Excel Pivot Tables

ASQ Milwaukee Pre-Meeting Clinic Monday, May 21, 2012 Presented by: Jeff Stumpe

2 Presentation Overview

Presentation Overview

How 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

Adding the Pivot Table Menu to the Toolbar

4 The Pivot Table Menu Options

The Pivot Table Menu Options

No Active Pivot Table Drop Down

Active Pivot Table Drop Down

5 Creating the Pivot Table

Creating the Pivot Table

6 Creating the Pivot Table

Creating the Pivot Table

Single Cell Column Titles!!!

7 Creating the Pivot Table

Creating the Pivot Table

Text or Number Data Columns

Number Data Columns

8 Creating the Pivot Table – Pivot Table Field Settings

Creating the Pivot Table – Pivot Table Field Settings

Data Columns Only

9 Creating the Pivot Table – Pivot Table Field Settings

Creating the Pivot Table – Pivot Table Field Settings

Click Drop Down for Selection/De-selection

10 Creating the Pivot Table – Pivot Table Field Settings

Creating the Pivot Table – Pivot Table Field Settings

Click Sort Ascending to Re-order Column Data (Alpha-Numeric)

11 The Pivot Table Menu – Hiding Subtotals

The Pivot Table Menu – Hiding Subtotals

12 The Pivot Table Menu – Hiding Detail

The Pivot Table Menu – Hiding Detail

13 The Pivot Table Menu – Refresh Data

The Pivot Table Menu – Refresh Data

Use 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

The Pivot Table Menu – Capture New Data

15 The Pivot Table Menu – Show Field List

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
cсылка на страницу
Урок

Английский язык

29 тем
Слайды