Pivot tables charts
Download
1 / 29

Pivot Tables & Charts - PowerPoint PPT Presentation


  • 71 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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

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


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


Limitations of Pivot Table Data


Creating a Pivot Table


Creating a Pivot Table


Creating a Pivot Table


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


Using the optional “filter” field


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


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


Cosmetic editing: Applying a style


Cosmetic editing: Number format


Cosmetic editing: Replacing blank cells (with zeros)


Cosmetic editing: Changing field names


Cosmetic editing: Layout


Cosmetic editing: Subtotals, blank lines, etc.


Cosmetic editing: Removing field headings


ad
  • Login