Excel 365 in 30 Minutes – PivotTables (Advanced 7 of 11)

In this Bigger Brains course, you’ll learn how to create and modify PivotTables to summarize and analyze data efficiently. You’ll see how to build a PivotTable from a data source, apply styles, and format fields to improve readability and consistency. You’ll also learn how to select, copy, move, and format PivotTables, change data sources as your data evolves, and group fields using both standard and custom groupings to better organize your analysis. 

You’ll explore advanced PivotTable capabilities that support deeper analysis and reporting. You’ll learn how to change summary functions, turn on subtotals, and adjust PivotTable options to control how results are displayed. You’ll see how to add calculated fields and calculated items and how to use Show Values As calculations to compare results in meaningful ways. You’ll also learn how to leverage the GETPIVOTDATA function for reliable formulas linked to PivotTables. Designed for advanced Excel 365 users, this fast-paced course helps you build powerful PivotTables that support smarter reporting and decision-making. 

Topics covered include: 

• Creating and modifying a PivotTable 

• Formatting a field 

• Selecting, copying, and moving PivotTables 

• Grouping fields using standard and custom groups 

• Changing the data source for a PivotTable 

• Formatting a PivotTable 

• Changing options 

• Turning on Subtotals 

• Using the GETPIVOTDATA Function  

• Adding a calculated field to a PivotTable 

• Adding a calculated item to a PivotTable  

• Changing the summary function 

• Setting the Show Values As calculations 

Enjoy award winning HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.