• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

In Excel 2007: Pivot Tables for Data Analysis, Microsoft Most Valuable Professional Curt Frye helps dispel the common fear of the Pivot Table feature, by demonstrating how to use this powerful tool to discover valuable business intelligence. Curt shows how to create Pivot Table reports from internal Excel data and outside data sources, use filters to focus on the most important data in the sheet, and make visual presentations of data using Pivot Chart reports. Exercise files accompany this course.

Course Excel 2007: Pivot Tables for Data Analysis Author Curt Frye SKU ISBN Release Date 2009-11-05 Duration 2.45 hrs / 47 tutorials Work files Yes Price $ 19.95 Retail price $ 49.95 Language Tags Excel

1. Creating and Pivoting PivotTable Reports Introducing PivotTable reports 04:21 Formatting data for use in a PivotTable report 05:22 Creating a PivotTable report 03:49 Pivoting a PivotTable report 03:27 Configuring a PivotTable report 04:51 Connecting to an external data source 02:40 Consolidating data from multiple sources 05:19 Updating and refreshing PivotTable data sources 04:51 Managing PivotTables 04:31 2. Summarizing PivotTable Data Adding, removing, and positioning subtotals and grand totals 02:47 Changing the data field summary operation 07:36 Summarizing more than one data field 03:18 Creating a calculated field 03:28 Drilling down to the underlying data 02:21 Grouping fields 03:19 Using PivotTable data in a formula 05:55 3. Sorting and Filtering PivotTable Data Sorting PivotTable data 02:41 Creating a custom sort order 03:28 Filtering by selection 03:43 Filtering by a rule 05:20 Filtering with report filter fields 05:28 Clearing and reapplying filters 01:19 4. Formatting PivotTable Reports Applying a style 03:26 Creating and editing styles 04:33

Changing the layout 02:18 Changing the data field number format 01:54 5. Emphasizing Data Using Conditional Formatting Highlighting cells by applying a rule 03:36 Highlighting the top or bottom value in a report 03:35 Formatting cells using data bars 02:34 Formatting cells using color scales 03:36 Formatting cells using icon sets 11:48 Editing conditional formatting rules 01:42 Controlling how Excel applies multiple conditional formatting rules 03:44 Deleting conditional formatting rules 02:21 6. Creating and Manipulating PivotChart Reports Creating a PivotChart report 03:41 Pivoting a PivotChart report 03:04 Filtering a PivotChart report 03:40 Formatting a PivotChart report 03:17 Changing the layout 02:27 Changing the chart type 02:07 Adding a trendline 02:13 7. Printing PivotTable and PivotChart Reports Printing a PivotTable report 02:28 Printing each item on its own page 03:23 Printing a PivotChart report 01:49 Conclusion Goodbye 00:17