Excel PivotTables: Advanced PivotTable Techniques for Analyzing and Presenting Data Faster

Duration: 55m | Video: .MP4 1280x720, 24fps(r) | Audio: AAC, 48000 Hz, 2ch | Size: 420 MB
Genre: eLearning | Language: English

Master PivotTables in Excel to get better at analyzing and presenting data!

As a data analyst, you're likely tasked with making sense of large data sets, leaving little time to summarize it into reports and dashboards. Join me as I share my advanced PivotTable techniques to make your data more interactive, enabling you to more quickly glean trends and insights from your data.

What you'll learn

Create and set up PivotTables in order to better visualize your data
Filter, sort, and slice your data within a PivotTable
Add calculated fields to your PivotTables
Create PivotCharts to better visualize your data
Create and save PivotChart templates to match brand guidelines
Use GetPivotData for custom reports to get data and apply custom formatting
Refresh PivotTable with Macros to automatically update different layouts and views of your PivotTables