Excel L3-Tables & Pivot Tables

Analyze data faster with the hidden power of Excel Tables and PivotTables!
In this focused 90-minute webinar, you’ll learn how to turn raw lists into dynamic tables and build PivotTables that summarize, filter, and explore your data with ease. We’ll walk through the essential tools that everyday Excel users need—plus modern techniques like slicers, automated refreshing, and layout options that make your reports clearer and easier to maintain.

Whether you work with sales data, HR lists, financial details, or project logs, this session will give you repeatable skills you can use immediately. No advanced Excel knowledge required, just a basic comfort with worksheets.

Topics Include

Excel Tables

• Creating and formatting Tables
• Table options (structured references, sorting, filtering)
• Why Tables make PivotTables better

PivotTables

• Creating PivotTables from Tables
• Navigating the PivotTable Fields pane
• Filtering & sorting PivotTable data
• Changing summary calculations (Sum, Count, % of Total, etc.)
• Basic design & formatting for clean reports
• Refreshing data
• Grouping dates and numbers
• Slicers and Timelines for interactive filtering
• Optional if time: Understanding when Excel prompts to “Add this data to the Data Model”

Bonus Tip:

• Report Filter Pages (create multiple PivotTables at once)

Course materials include a quick-reference guide and practice files. Training will be conducted via Microsoft Teams.

Interested in offering this session for your organization?
Contact officeproductivitytraining@gmail.com or visit OfficeProductivityTraining.com to learn more.