Pivot tables charts
This presentation is the property of its rightful owner.
Sponsored Links
1 / 29

Pivot Tables & Charts PowerPoint PPT Presentation


  • 48 Views
  • Uploaded on
  • Presentation posted in: General

Pivot Tables & Charts. When to use a Pivot Table?. How to structure your input data. How NOT to structure your input data. How NOT to structure your input data. How NOT to structure your input data. How to correctly structure the data (previous slide). Anatomy of a Pivot Table.

Download Presentation

Pivot Tables & Charts

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Pivot tables charts

Pivot Tables & Charts


When to use a pivot table

When to use a Pivot Table?


How to structure your input data

How to structure your input data


How not to structure your input data

How NOT to structure your input data


How not to structure your input data1

How NOT to structure your input data


How not to structure your input data2

How NOT to structure your input data


How to correctly structure the data previous slide

How to correctly structure the data (previous slide)


Anatomy of a pivot table

Anatomy of a Pivot Table


Limitations of pivot table data

Limitations of Pivot Table Data


Creating a pivot table

Creating a Pivot Table


Creating a pivot table1

Creating a Pivot Table


Creating a pivot table2

Creating a Pivot Table


Pivot tables charts

Creating a Pivot Table:Select fields (top right) and then simply drag them into or out of the areas (below right)


Re arranging the pivot table fields

Re-arranging the Pivot Table fields


Using the optional filter field

Using the optional “filter” field


1 changing data and 2 adding data

(1) Changing Data; and (2) Adding Data


1 changing data and 2 adding data1

(1) Changing Data; and (2) Adding Data


Cosmetic editing applying a style

Cosmetic editing: Applying a style


Cosmetic editing number format

Cosmetic editing: Number format


Cosmetic editing replacing blank cells with zeros

Cosmetic editing: Replacing blank cells (with zeros)


Cosmetic editing changing field names

Cosmetic editing: Changing field names


Cosmetic editing layout

Cosmetic editing: Layout


Cosmetic editing subtotals blank lines etc

Cosmetic editing: Subtotals, blank lines, etc.


Cosmetic editing removing field headings

Cosmetic editing: Removing field headings


  • Login