Demystifying PivotTables

Understand how to set up data for PivotTables, create simple PivotTables, and manipulate data in PivotTables.

Why you should Attend:
Do you have lines and lines of data that’s just sitting in your Excel spreadsheet? Don’t let it go to waste - there’s gold in those hills! Data is the goldmines of the 21st century. But with so much, how to you extract something useful?

PivotTables can quickly summarize and reorganize large datasets without using one single formula. Their drag and drop method makes analyzing data easier than ever. But the first time you look at a PivotTable might leave you running for the hills.

I’ll show you exactly how to set your data up for PivotTable success, review the database terms PivotTables use, and show you how PivotTables are pulling the data. Once you understand what’s going on behind the PivotTable veil you won’t be afraid of them anymore!

This class sets you up to understand more advanced PivotTable functions, quickly produce individual reports, and create interactive dashboards.

Areas Covered in the Session:

• What would we do without PivotTables?
• Tabulated format - the sneaky format that makes all the difference
• Getting your data ready to pivot
• What does pivot mean anyway and other helpful database terms
• How to unpivot your data - so you can pivot your data
• What is a PivotTable doing anyway?
• Creating a simple PivotTable

• Administrative assistant
• Human resources (HR) administrator
• Market researcher
• Sales Manager
• Medical Administration
• Rising College Students
• Fleet Manager
• Cost Estimator
• Project Manager