Reading to prepare
Pivot Table Reports 101 (expand sections at bottom of page to read entire page.) http://office.microsoft.com/en-us/excel-help/pivottable-reports-101-HA001034632.aspx
Learn to use Pivot Tables in Excel 2007 to Organize Data. If you have never used Pivot Tables before, or at a little bit rusty with them, I highly recommend downloading the example spreadsheet (available at the bottom of the article) and working through the examples. http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data
Chapter 4 (Hacking Pivot Tables) of Excel Hacks, Second Edition by David Hawley and Raina Hawley (2007). Free online access available via Safari books online via Temple Library — http://proquest.safaribooksonline.com/ on campus or search for Safari at Temple library database finder.
Here is the data file for this evening’s lab.
EmergencyRoomVisits.csv (ZIP file)
Download. Unzip. Open in Excel.
Electronic copy of lab exercises: WK12 Excel Pivot Table Lab.
Class capture of class meeting.