Excel Mastry: PivotTables

Name: Excel Mastry: PivotTables
Rating: 4.7 (54 reviews)

From building your first Pivot to advance techniques, this course has it all!

Created byTom Hinkle

Last updated 8/2024

English

English [Auto],

What you'll learn

Taught by a 2 time Excel MVP
How to utilize the awesome power of PivotTables for analyzing and presenting data
Create a PivotTable from Scratch
Learn every possible way to configure a PivotTable
Understand how to format a PivotTable to make it easy for people to consume
How to configure the aggregations of a PivotTable
Utilize multiple data points to make your analysis that much more impactful
Use slicers and timelines to make interaction with the PivotTable easy
Advanced table calculations to add another dimension to PivotTables

Course content

2 sections • 12 lectures • 1h 21m total length

Downloadable Workbook - download the workbook to work along with the lessons0:04
Introduction to PivotTables6:06
This lesson is a simple overview of what exactly a PivotTable is, and why you would want to use one.
Create a basic PivotTable6:30
After this lesson you will be able to make a simple PivotTable
Format a PivotTable11:07
This lesson will teach you how to format your PivotTable. Not just colors, but layouts, groupings etc.
Value Field Settings4:21
This lesson is important, it will show you how to modify what is being aggregated in the PivotTable. After watching you will be able to specify if you want to sum up, count, get the min or max of the field being aggregated and more.
Update/Refresh Data5:29
This lesson will show you how to update your PivotTable when you get new data.

Downloadable workbook0:02
Configuring subtotals and grand totals9:00
Adding subtotals and grand totals to a PivotTable can make it much easier to see trends at a higher level. This lesson will show you how to set all of that up.
Multiple data points5:55
Basic PivotTables will only aggregate on one data field. This lesson will show you how to add multiple fields to an aggregation. You will also learn how to position multiple fields so that it does not become too distracting to look at.
Adding slicers and timelines to your PivotTable9:53
Slicers and Timelines make the PivotTable much more interactive. They are graphic elements that let the consumer filter out values and time periods.
Adding conditional formatting to your PivotTable11:49
Conditional formatting is one of the most underrated features of Excel in general. This lesson will show you how to apply it to a PivotTable.
Table Calculations10:45
Table calculation's let you add another dimension to your PivotTable aggregations. Instead of doing a simple sum or count, table calculations enable you to do things like 'percent of row', 'percent of grand total', 'running totals'.

Not used that often, but when you need to do something like it, table calculations are phenomenal.

Requirements

Be curious and eager to increase your skills with PivotTables and Excel
Be comfortable moving around in excel and working
Have a basic understanding of formulas and functions

Description

### Mastering PivotTables in Excel with Tom Hinkle

Unlock the full potential of your data with our comprehensive course on PivotTables in Excel, taught by Tom Hinkle, a 2-time Microsoft MVP with over 20 years of industry experience. This course is designed for data enthusiasts who are eager to enhance their data analysis skills and make the most out of Excel’s powerful features.

In this hands-on course, you will start by learning the basics of creating a PivotTable, one of Excel's most powerful data analysis tools. You'll discover how to quickly summarize large datasets, allowing you to see trends and insights at a glance. Tom will guide you through the process of formatting your PivotTables to make your data visually appealing and easier to understand.

Next, you’ll delve into modifying Value Field settings to customize your analysis further, and learn how to refresh your data effortlessly to ensure your reports are always up-to-date. But we don't stop there—this course also covers advanced topics to take your skills to the next level.

You'll master subtotals and multiple data points, making your analysis more granular and insightful. Learn how to use slicers and timelines to filter your data dynamically, and apply conditional formatting to highlight key information. Finally, explore table calculations to perform complex data manipulations directly within your PivotTables.

Join Tom and transform your data analysis capabilities with this essential Excel course. Whether you’re a beginner or looking to refine your skills, this course will empower you to handle data like a pro.

Enroll now and start making data-driven decisions with confidence!

Who this course is for:

People that want to stand out with their Excel skills at work or at home
Anybody that has to work with data in spreadsheets
Someone that wants to take their data analysis skills to the next level

Excel Mastry: PivotTables

What you'll learn

Explore related topics

Course content

PivotTable Basics6 lectures • 34min

Advanced PivotTable techniques6 lectures • 47min

Requirements

Description

Who this course is for: