Excel Tables & Pivot Tables (Virtual)

Discover how Excel Tables and PivotTables can transform your data—learn to filter, summarize, and analyze with built-in functions like sum, average, and count, plus create dynamic charts with ease.

Register for This Course

What This Course Is About:

During this session, you will learn the powerful yet easy tool of using the Table feature to filter your data and then turn on a total row that will analyze your data automatically by providing built-in sum, average and count functions. Then, learn about how Excel PivotTables quickly summarize, analyze, and chart your data.

What You’ll Learn:

Create a Table
• Add a Total Row
• Change Table Styles
• Filter
• Remove a Table

PivotTables & Pivot Charts
• Create a PivotTable
• Format Values
• Report Layout
• Filter Columns/Rows
• Sort
• Modify PivotTable fields
• Pivoting Fields
• Modify the Summary Function
• Add Column
• Report Filters
• Group Dates
• Conditional Formatting
• Calculated Field
• Timelines
• Slicers that Filter
• PivotChart
• Relationships & Data Models
• Default PivotTable Layout