Welcome! This is a website that everyone can build together. It's easy!

Purdue Pivot Table HomeThis is a featured page

Thank you for visiting our web page.

The purpose of this site is to teach you how to create a pivot table in Excel with a Macintosh computer. what do the instructions not do?

Click on Instructions on the left side of the page to get started.

Agenda:
• Opening Excel
• Downloading Data FIle
• Opening up Excel
• Creating a pivot table
• Formatting the pivot table
• Saving Data what about links to each of these sections right here?

Pivottable-Flatdata.PNG
Figure 1: Sample Raw Data in Excel Table
=Fi

Uses for Pivot Tables:
A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet.
• Personal Finance sheets for students.
• Organizing large data dumps and personalize tables for different types of reporting.
• Among other functions, they can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data.
• A pivot table can help quickly summarize the flat data, giving it depth, and get the desired information.

Pivottable-Pivoted.PNG
Figure 2: Sample formatted data in Excel Pivot Tables

* Please follow the navigation in the left pane to continue to Instructions or click Next below.








No user avatar
sladow
Latest page update: made by sladow , Dec 15 2009, 5:45 PM EST (about this update About This Update sladow Edited by sladow

16 words added

view changes

- complete history)
Keyword tags: None
More Info: links to this page
Started By Thread Subject Replies Last Post
sladow overview 0 Dec 4 2009, 4:37 PM EST by sladow
Thread started: Dec 4 2009, 4:37 PM EST  Watch
ok, you also very clearly need to state what the documentation doesn't do as well as what it does. This also needs development telling us what steps we'll go through to create the table and links embedded within there--the reference to the left hand navigation is good but not enough--especially since it doesn't break down steps that I can easily choose what I need and where to go.

You have not given me writing priveledges for the site--you might want to do that
Do you find this valuable?    
Keyword tags: None
Showing 1 of 1 threads for this page