Advanced Pivot Tables Tutorial in Excel - 2.5 Hour Pivot Table Excel Course

✅Download the accompanying Excel exercise files here:

The PivotTable function in Excel is one of the most impressive and powerful functions that Excel offers. With a few clicks, you can perform data analysis that would otherwise take forever. In this 2.5-hour pivot tables tutorial, we've assumed you've used a pivot table before and are looking to build on this skill.

We start with a quick pivot tables recap before moving on to combining data from multiple worksheets for a pivot table, combining and grouping data, different pivot table layouts and styles and so much more.

This pivot tables Excel 2019 course is aimed at intermediate to advanced users. Existing knowledge of pivot tables and Excel is advised.

We've even included a free downloadable transcription study aid so you can follow along in this Pivot Table Tutorial.

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

0:00:00 - Introduction to Advanced PivotTables
0:04:02 - PivotTables Recap
0:16:45 - Importing data from a text file
0:26:43 - Importing data from Access
0:35:18 - Exercise 01
0:40:03 - Cleaning Data
0:57:42 - Tabular Data
1:14:04 - Exercise 02
1:17:21 - Creating and Manipulating a PivotTable
1:29:48 - Combining Data from Multiple Worksheets
1:41:52 - Grouping and Ungrouping
1:52:52 - Report Layouts
2:03:48 - Formatting Error Values and Empty Cells
2:12:13 - Exercise 03
2:13:49 - PivotTable Styles
2:25:28 - Custom Number Formatting
2:41:54 - Exercise 04

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[eleananatsi]

This is where it goes "no comment". In a sense of great generosity, high level profesionalism, tutorials designed in detail, all combined to offer us an expensive tutorial program for free.
Thank you Simon! I'm sure your generosity will return back to you. You are a genuine giver.
Thank you Deb! You are a natural talent in teaching and we are so lucky to have you. You are really special.

[rajbirsandhu]

As a Data Analyst intern, it has become my worst nightmare to analyze data and find out insights because sometimes, ite really hard to decide how to start and where to start. But by watching your videos, things have become so simple and interesting I would like to say. You truly are the Excel queen. Thank you so much for making our lives easier :)

[yohannesabraham]

This is the only PivotTable course that one needs to be a good analyst. Thank you so much for your generosity in delivering such a valuable course for free by such professional and knowledgable person.

[petarpetrov]

I just recently got an opportunity to advance in my career to a new position. Turns out I must be a master of Excel which I had not ever opened once in my life! I want to sincerely thank you for your fantastic training and free training materials, which have made me gain so much confidence in dealing with Excel! Now I look at my future job requirements for Excel and I'm like- I GOT THIS EYES CLOSED THANK YOU !!!!

[RipRoarLB]

Excellent Course, perfectly delivered. There are a few things, I'd like to offer to the viewers of which I saw possibly easier ways to accomplish: 1) Finding blank rows. The method in the video used found rows of blanks cells within the data, but also individual cells left blank. The video showed the user simply using the control key and mouse to remove them from the collection. However, as said in the video, this could be a very large data sheet, thus making that not a functional way to remove blank rows. Because the data is in the table, the user can go to the table header which has a drop-down field, and simply unselect the all and then scroll to the bottom of the list and select "blank". If some rows show up with data in them, go to the column header of the row and choose blank for it also. But, most likely, choosing a column that is the primary field in the data, will show all the blank rows. Then the user can simply highlight the rows and delete them from the table.

[J-qdwd]

Thank you Simon for your generosity; thank you Deb, you are an excellent communicator, the best teacher in the world.

[kennymek]

I honestly can not say how much of an assistance the tutorials that Deb Ashby's gives has been in advancing my skills and knowledge on Excel. To start with, Deb Ashby is an excellent tutor with fantastic communication style and approach. The course content is elaborate, detailed and structured. 100% informatively relevant content and very up to date. Thank you for these contents

[sakiboki]

I LEARN SO MUCH THROUGH YOUR TEACHING AND APPRECIATE SO MUCH. THANK YOU DEB.

[A-broken-clay-jar]

You are a wonderful instructor! Pivot Table intimated me in college, but now it all starts making sense. I interviewed a job today that requires high level of Pivot Table skills. I am trying to improve my Pivot Table skills from basic to advanced just in case I get a 2nd interview/or the job. I am sure it will be very useful for me in the future for other jobs as well.

[idayichingovo]

Deb you are such an excellent communicator and tutor, i got to understand a lot of formulaes i couldn't get from other tutorials.Thank you so much and SIMON YOU ARE STAR

[bird]

Your explaining/teaching procedure is excellent. Even any beginner can understand and learn, provided he makes practice of it.

[tonytaf]

I watched first the 1h video Pivot tables beginner then the 1h advanced one. After that I watched the 2h video beginner Pivot Tables and now right here watching this 2h advanced one. All 4 together is like magic, Thank you so much 🙏🏻

[denissteward]

Great job done especially to support MEAL Departments in development world.

[nithyaprakash]

This is a really helpful and valuable lecture. Cant stop myself from leaving a comment

[OmefeVictor]

Hi Deb, thanks for this tutorial. You're the best teacher in the world.

[osoriomatucurane]

Great Tutorial, Crystal Clear and Concise. When grouping a numerical field into categories/classes, instead of keeping intervals, It would be awesome if we could have the option to rename the groups (like low, moderate, high, etc, ...), just as we did when grouping text fields. Actually this feature I feel like it should be better named as hierarch or categorization/bucketing since right from the beginning, the pivot table is already grouping by unique fields/values, apply the aggregation metric (sum, average, count, min, just thinking loud!

[sanchezdora]

Deborah, you have a great simple facility to explain excel that I even used your videos to perform my English! I thank you for your time and for sharing your knowledge!

[davidyang]

There is no download link for the course files. The only download link is for the exercise files.

[EllenHurstfoxx]

I loved this training and thank you very much for making this training available for us.

[wahidullahnoor]

I really enjoyed learning best quick pivot table training from your channel.