Pivot Tables — a great way to consolidate, filter, and sort data to create amazing tables and graphs with just a few clicks. This is similar to creating Queries and Reports with a database. Let’s try out the below exercise as an example:
For more help on Pivot Tables, see Lynda.com to search for “EXCEL: PivotTables for Beginners” or “EXCEL 2013: Pivot Tables”
Remember to access Lynda.com from your National University Single-Sign-On (SSO) to connect to your FREE access to these full courses.
OPTIONAL Advanced Exercise — use the data in the activity to create your own Pivot Table from scratch! Also, create a Pivot Chart to help you answer each question too!