Excel in Microsoft Excel 3: Pivot Tables Intro & Masterclass

Excel in Microsoft Excel 3: Pivot Tables Intro & Masterclass, available at $69.99, has an average rating of 4.75, with 83 lectures, based on 228 reviews, and has 1436 subscribers.

You will learn about Create Pivot Tables with a just a few clicks, simply and quickly. Maintain and expand Pivot Tables. Update data sources, and maintain formatting during refreshes. Create Pivot Charts in a few simple clicks. Know and use about the more advanced features, and create advanced Pivot Tables. Find out how much powerful it is, and how quickly it can improve your data analysis. This course is ideal for individuals who are This is for you if you have ever heard of the "Pivot Table", but didn't know what it is or how to use it. or This is also for you if you use PivotTables, and want to go deeper. Much deeper. 🙂 or We'll also go into the more advanced functions, and create charts as well, quickly and easily. It is particularly useful for This is for you if you have ever heard of the "Pivot Table", but didn't know what it is or how to use it. or This is also for you if you use PivotTables, and want to go deeper. Much deeper. 🙂 or We'll also go into the more advanced functions, and create charts as well, quickly and easily.

Enroll now: Excel in Microsoft Excel 3: Pivot Tables Intro & Masterclass

Summary

Title: Excel in Microsoft Excel 3: Pivot Tables Intro & Masterclass

Price: $69.99

Average Rating: 4.75

Number of Lectures: 83

Number of Published Lectures: 83

Number of Curriculum Items: 83

Number of Published Curriculum Objects: 83

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Create Pivot Tables with a just a few clicks, simply and quickly.
Maintain and expand Pivot Tables.
Update data sources, and maintain formatting during refreshes.
Create Pivot Charts in a few simple clicks.
Know and use about the more advanced features, and create advanced Pivot Tables.
Find out how much powerful it is, and how quickly it can improve your data analysis.

Who Should Attend

This is for you if you have ever heard of the "Pivot Table", but didn't know what it is or how to use it.
This is also for you if you use PivotTables, and want to go deeper. Much deeper. 🙂
We'll also go into the more advanced functions, and create charts as well, quickly and easily.

Target Audiences

This is for you if you have ever heard of the "Pivot Table", but didn't know what it is or how to use it.
This is also for you if you use PivotTables, and want to go deeper. Much deeper. 🙂
We'll also go into the more advanced functions, and create charts as well, quickly and easily.

Review:

“The knowledge of the teacher is impressive, and he knows how to teach. The speed of the course is just right. And going thru the exercises after each one is great. I only have one word for the teacher and the way he’s presenting the course WOW!!!” — Daniel Sandberg

This course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.

It sounds difficult, but in fact can be done in just a few clicks. We’ll do our first one in a couple of minutes – that’s all it takes. We’ll also add a chart as well in that time.

After only these first few minutes, you will be streets ahead of anyone who doesn’t know anything about Pivot Tables – it is really that important.

After this introduction, we’ll go into some detail into how to set up your Pivot Table – the initial data, and the various options that are available to you. We will go into advanced options that most people don’t even know about, but which are very useful.

By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you’ll be able to help others with their data analysis.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome

Lecture 2: Welcome to Udemy

Lecture 3: Introduction to Udemy

Lecture 4: Do you want auto-translated subtitles in more languages?

Lecture 5: Curriculum

Chapter 2: Creating our first PivotTable and PivotChart

Lecture 1: Our first PivotTable

Lecture 2: PivotTable Menus

Lecture 3: Our first PivotChart

Lecture 4: PivotChart Menus and An Introduction to Practice Activity 1

Lecture 5: Practice Activity Number 1

Lecture 6: Answer to Practice Activity 1

Chapter 3: Expanding our PivotTable

Lecture 1: Source data requirements

Lecture 2: Adding additional values

Lecture 3: Recommended PivotTables

Lecture 4: Moving PivotTable

Lecture 5: Refresh PivotTable – why it doesn't auto-update

Lecture 6: Extracting data

Lecture 7: Sorting

Lecture 8: Practice Activity Number 2

Lecture 9: Answer to Practice Activity 2

Chapter 4: Going deeper in our PivotTable

Lecture 1: Adding additional row fields

Lecture 2: Different layouts – Compact, Outline and Tabular

Lecture 3: Blank Rows

Lecture 4: Group Records

Lecture 5: Showing or hiding additional detail – the +/- buttons

Lecture 6: Adding columns

Lecture 7: Adding page fields

Lecture 8: Adding filters

Lecture 9: Changing source

Lecture 10: Using a table source

Lecture 11: Final options

Lecture 12: Introduction to Practice Activity 3

Lecture 13: Practice Activity Number 3

Lecture 14: Answers to Practice Activity 3

Chapter 5: Modify field selections

Lecture 1: Change aggregate (COUNT, MIN, MAX)

Lecture 2: Repeat All

Lecture 3: Using Conditional Formatting to hide Repeat All

Lecture 4: Grand Totals

Lecture 5: Adding subtotals

Lecture 6: Show items with no data

Lecture 7: Other field settings

Lecture 8: Practice Activity Number 4

Lecture 9: Answers to Practice Activity 4

Chapter 6: PivotTable Options

Lecture 1: Layout

Lecture 2: Totals & Filters, and Alt Text

Lecture 3: Display

Lecture 4: Print

Lecture 5: Data

Lecture 6: Practice Activity Number 5

Lecture 7: Answers to Practice Activity 5

Chapter 7: Slicers (Excel 2010 and later)

Lecture 1: Create slicers

Lecture 2: Identifying impossible options, and selecting more than one option at once.

Lecture 3: Join to multiple PivotTables

Lecture 4: Options

Lecture 5: Practice Activity Number 6

Lecture 6: Answer to Practice Activity 6

Chapter 8: Dates and Timeline

Lecture 1: Aggregates

Lecture 2: Group by time period

Lecture 3: Timelines

Lecture 4: Practice Activity Number 7

Lecture 5: Answer to Practice Activity 7

Chapter 9: Formatting

Lecture 1: Formatting number values

Lecture 2: Custom Formatting – number formatting

Lecture 3: Custom Formatting – dates and text

Lecture 4: Custom Formatting – sections and colors

Lecture 5: Conditional Formatting – Highlighting cells

Lecture 6: Conditional Formatting – Data Bars and Color Sets

Lecture 7: Formatting printing

Lecture 8: Styles

Lecture 9: Practice Activity Number 8

Lecture 10: Answer to Practice Activity 8

Chapter 10: Advanced calculations

Lecture 1: Percentage of total

Lecture 2: Percentage of total – Advanced

Lecture 3: Cumulative totals

Lecture 4: Index

Lecture 5: Difference from

Lecture 6: Calculated fields

Lecture 7: Calculated Items

Chapter 11: PivotCharts

Lecture 1: Relationship of PivotChart with PivotTable

Lecture 2: Options and Styles

Lecture 3: Bubble charts

Chapter 12: Conclusion

Lecture 1: Thank you for joining me

Lecture 2: Bonus Lecture

Instructors

Phillip Burton
Best Selling Instructor – over 800,000 students so far
I Do Data Limited
Improve your skills in SQL, Office, Tableau, Power BI + more

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 12 votes
4 stars: 59 votes
5 stars: 156 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