First steps with Excel PivotTables
Drill down, roll up, slice-and-dice your spreadsheet data
Date and time
Location
Online
About this event
- Event lasts 1 hour
Recording & downloads
- A recording will be made available after the event.
- All files used in the session will be shared at the time of the event.
Overview
This webinar will demonstrate the basics of PivotTables for data analysis in Excel:
- How to structure your data to get the most from PivotTables
- How to create and maintain your first PivotTable connection
- How to build compelling tables and reports using PivotTable basics
Prerequisites
It is recommended to attend this workshop with a desktop version of Excel 365 for Windows. I cannot guarantee availability of these features for all versions of Excel.
- You should have basic to intermediate Excel skills: working with IF statements, creating charts and so forth.
- No other preparation is needed. The workshop materials will be shared with you at the time of the event.
About your instructor
George Mount is the founder and CEO of Stringfest Analytics, a consulting firm specializing in analytics education and upskilling. He has worked with leading bootcamps, learning platforms and practice organizations to help individuals excel at analytics.
George regularly blogs and speaks on data analysis, data education and workforce development and is the author of Advancing into Analytics: From Excel to Python and R (O’Reilly Media, 2021) and Modern Data Analytics in Excel: Using Power Query, Power Pivot and More for Enhanced Data Analytics (O’Reilly Media, 2024). He is a recipient of the Microsoft Most Valuable Professional (MVP) award for exceptional technical expertise and community advocacy in the field of Excel.
George holds a bachelor’s degree in economics from Hillsdale College and master’s degrees in finance and information systems from Case Western Reserve University. He resides in Cleveland, Ohio.