BOOK DOWNLOAD: Excel Pivot Tables- Halve your work day-with Video Clips

How to with Excel Pivot Tables (Excel 2007)

Click Here to Download a Sample

• Create a Pivot Table
• Introducing Data
• Refreshing a Pivot Table
• Manipulating the Data Portion of a Pivot Table
• Formatting the Data in a Pivot Table
• Introducing more than one Value
• Summarizing the Data (SUM, COUNT, AVERAGE etc)
• How else can we represent the data
• Normal, Difference From, % Of and % Difference From, Running Total In, % of Row, % of Column, % of Total, Index
• Manipulating the Rows of a Pivot Table
• Introducing new Labels to the rows
• Changing the Subtotal Settings
• Layout and Print Options
• Sorting the information in the rows- Manual Sorting, Sorting in Ascending and Descending Order
• Using the Dropdown arrows in the row labels
• Determining what exact records make up a particular data point
• Manipulating the columns in a pivot table
• Report Filter (Page Field in Excel 2003)
• How can you create Pivot Tables for many items in the report filter
• Grouping Data in the rows and columns- Manual Grouping, Grouping Dates, Grouping Numbers
• Simple Pivot Charting
• Creating Calculated Fields within a pivot table
• Creating Calculated Item within a pivot table
• Trying to link into a Pivot Cell (and the GetPivotData function)
  

• Conditional Formatting on Pivot Tables (Excel 2007)
• Annexure- FAQ
• Why won’t Excel allow me to create a pivot table
• Why have all the Pivot Table Toolbars disappeared
• Can I delay the creation of the pivot table until I have made all my choices
• Why does my Pivot Table not recognise my dates as dates
• Why is the drop down lists still showing items that have been deleted?
• How do you get a Pivot Table to show you every day including days with no information
• How to use a Pivot Table to extract the unique items from a list
• Why does it look like the same item is appearing twice
• How to Create a Pivot Table out of multiple data sources
• How to create multiple Pivot Reports from the same Pivot Table
• How to (quickly) convert non compliant data into Pivot friendly data
• Labelling Columns
• Subtotals
• Filling in the Blanks
• Formatting Dates prior to incorporating in a Pivot Table
• Data in rows and not columns
• Pivot Table Options- Layout & Format, Totals & Filters, Display, Expand/ Collapse Buttons, Other Options in Display, Printing, Data
• Other buttons in the Ribbon
• Refresh and Refresh All
• Change Data Source
• Move Pivot Table
• Hide/ Show Field List
• Designing the Pivot Table
• Linking to an external database via Pivot Tables