Excel Mastry: PivotTables

Excel Mastry: PivotTables, available at Free, has an average rating of 5, with 12 lectures, based on 1 reviews, and has 549 subscribers.

You will learn about 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 This course is ideal for individuals who are People that want to stand out with their Excel skills at work or at home or Anybody that has to work with data in spreadsheets or Someone that wants to take their data analysis skills to the next level It is particularly useful for People that want to stand out with their Excel skills at work or at home or Anybody that has to work with data in spreadsheets or Someone that wants to take their data analysis skills to the next level.

Enroll now: Excel Mastry: PivotTables

Summary

Title: Excel Mastry: PivotTables

Price: Free

Average Rating: 5

Number of Lectures: 12

Number of Published Lectures: 12

Number of Curriculum Items: 12

Number of Published Curriculum Objects: 12

Original Price: Free

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

### 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!

Course Curriculum

Chapter 1: PivotTable Basics

Lecture 1: Downloadable Workbook – download the workbook to work along with the lessons

Lecture 2: Introduction to PivotTables

Lecture 3: Create a basic PivotTable

Lecture 4: Format a PivotTable

Lecture 5: Value Field Settings

Lecture 6: Update/Refresh Data

Chapter 2: Advanced PivotTable techniques

Lecture 1: Downloadable workbook

Lecture 2: Configuring subtotals and grand totals

Lecture 3: Multiple data points

Lecture 4: Adding slicers and timelines to your PivotTable

Lecture 5: Adding conditional formatting to your PivotTable

Lecture 6: Table Calculations

Instructors

Tom Hinkle
Master of Excel, SQL, Tableau (and other tools…)

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 1 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu