|
|
|
|
BOOK DOWNLOAD: Excel Pivot Tables- Halve your work day
SKU
HOW_TO_EXCEL_PIVOT_TABLES
How to with Excel Pivot Tables (Excel 2007)
|
|
|
Content (107 pages, 180+ screenshots, 15 example spreadsheets)
- 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
|
|
Note that this is a download only.
|
|
|