Pivot Your Tables into Information They Will Understand

The PivotTable feature is perhaps the most technologically sophisticated component in MS Excel. With only a few mouse clicks, you can slice and dice a data table in dozens of different ways and produce just about any type of summary you can think of. A PivotTable is essentially a dynamic summary report generated from a database. The database can reside in a worksheet (in the form of a table) or in an external data file. A PivotTable can help transform endless rows and columns of numbers into a meaningful presentation of the data.

In this webinar we’ll address how to make your data digestible and easily understood. We’ll cover:

• Understanding PivotTables
• Creating PivotTables automatically and manually
• Copying a PivotTable to a blank worksheet
• Working with non-numeric data
• Creating a PivotTable chart
• Creating slicers to help you query your results

Bonus Handout: PivotTables: Data They Will Understand

Hot Tip: Create a PivotTable Automatically: If your data is in a worksheet, select any cell within the data range Choose Insert> Tables>Recommended PivotTables. Excel quickly scans your data, and the Recommended PivotTables dialog box presents thumbnails that depict some PivotTables that you can choose from.

About Anne Marie DelPrincipe: Anne Marie DelPrincipe, owner of Mastering Software Unlimited, has over 30 years of training experience with emphasis on end-user computing and desktop publishing. Anne Marie worked as an Adjunct Professor at Raritan Valley Community College (RVCC) teaching Computer Literacy. She is a Corporate Training Specialist at RVCC and at Rutgers University teaching MS Office, Adobe products and PACE Certification. Anne Marie has partnered with SkillDevelopers to educate for free tips and techniques for Word, Excel, and PowerPoint, 2sdaystips.com. Anne Marie earned a BA in CIS and a MBA in MIS from Iona College.