How to do everything in Excel in half the time- Pivot Tables

Pivot Tables are the most important tool within Microsoft Excel, particularly in the business world. This book covers the key questions around pivot tables in a quick, easy to read way. Just over 100 pages of useful pivot table related excel knowledge that will halve your work time (at least!). With over 180 screenshots and 15 example spreadsheets you will master Pivot Tables in no time.

Read more below or go and buy it from www.AuditExcel.com

Search the site

Contact Details

Mail: info@AuditExcel.co.za

+27 11 563 3805

Miricle Solutions cc

PO Box 2683

Rivonia

2128

'How To' questions addressed

Pivot Tips and Tricks included

• Pivot Tables – Let’s get started

• 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 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)

• Linking into a Pivot Table

  • Manual method

  • Using GetPivotData to link into a Pivot Table

• Conditional Formatting on Pivot Tables (Excel 2007)

• 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

In Excel terms the questions that will be answered include:

• 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

To buy this book visit our corporate site at www.AuditExcel.com