Pivot Tables Excel: Detailed Beginners Pivot Table Tutorial

✅ Download the free course files to follow along

Learn all about Excel Pivot Tables in this detailed tutorial for beginners. Learn how you can summarize your datasets by creating Pivot Tables while following along using the same data that the instructor used in the course.

In this 2+ hours Excel tutorial video, we will walk you through the importance of cleaning your data to be used in Pivot Tables. You will learn how to prepare your data by removing blank rows and duplicates, clear formatting in Excel, merging and splitting columns, and converting numbers stored as text.

We teach you how to create and format Excel tables and how to create Pivot Tables from scratch or by using the Recommended Pivot Tables option. Learn different Pivot Table layout options and how to lock the report layout. We also show you how to add Pivot Table fields, ways to summarize your data, and how to group data.

We've even included downloadable course files so you can follow along in this course. This will help you put what you are learning into practice and master PivotTables in Excel.

📝 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 - What Are Pivot Tables
0:06:33 - Cleaning Excel Data
0:09:39 - Removing Blank Rows
0:15:10 - Removing Duplicate Rows
0:17:49 - Clearing Formatting
0:22:14 - Applying Number Formatting
0:30:53 - Changing the Case
0:40:10 - Removing Spaces and Non-printing Characters
0:50:16 - Merging and Splitting Columns
1:03:18 - Converting Numbers Stored as Text
1:05:46 - Find and Replace
1:11:53 - Spell Checking
1:15:51 - Excel Tables vs. Pivot Tables
1:21:15 - Formatting Data as an Excel Table
1:30:02 - Using Recommended Pivot Tables
1:35:31 - Creating a Pivot Table from Scratch
1:42:16 - Pivot Table Ribbons and Fields
1:47:55 - Pivoting Fields
1:53:27 - Adding Multiple Dimensions
1:56:15 - Deleting Fields and Locking the Report Layout
1:59:56 - Methods of Aggregation
2:04:07 - Combining Methods of Aggregation
2:09:43 - Grouping and Ungrouping Data in Excel
2:19:28 - Applying Number Formatting
2:24:14 - Handling Cells with No Data
2:28:15 - Subtotals and Grand Totals
2:32:41 - Choosing a Report Layout
2:37:27 - Inserting Blank Rows

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

🔥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 👍🏽 ;-)

[babatundeegbeyemi]

Madam, i have been following you for a long time, maybe you don't know how much you are lifting some of us in Africa out of poverty by enriching us with this kind of knowledge to improve human development. This is speeding up my career as a maintenance planner. Thank you so much

[tracycollier]

OMG! This tutorial is well worth the 2 hours it takes to complete! I'm so happy I found this. Thank you Simon Sez and Instructor Deb A!

[doraszabo]

AGREE, absolutely would recommend this course! I love the way it begins to introduce us to the world of pivot tables, starting with CLEANING! Thank you, very professional!!!

[viencastaneda]

This is by far the BEST and VERY BEGINNER FRIENDLY video tutorial about Pivot Table I've ever watched. I cannot thank you enough for this!!!!

[SUPERSLIDE]

What a great tutorial!!! I do a lot of the stuff in the vid but having a thorough walk through and explanation is so useful!! I learned so much more than expected. Thank you!!

[lacreamlacream]

Thanks alot Simon, am new to data but because of your videos when i speak or work on a data they think am a professional already thanks alot simon for helping me

[aika]

The woman explained the excel in a really amazing way. Very articulate and easy to understand! I'am able to understand what she said quickly. really talented teacher. Kudos to all of the team 🙇

[tasst]

I wish I could give a million likes. I am going back to work after being off for several years and want to refresh my Excel skills. This is fabulous. Thanks!

[mikeparks]

Thank you Deb - of all the Excel YouTube videos available on Excel Pivot Tables, yours' are the most informative and complete.

[patrickpeter]

This is the best detailed tutorial I've seen on YouTube, thank you for putting this out, I really gained value
God bless you

[eirhnh.x]

Words cannot describe what a fantastic tutor you are!! The pace of the presentation, the tone and colour of your voice, the subjects you choose to present... Pivot tables are absolutely essential to what I have to deal with right now but I had developed a paralysing fear for them. With your presentation, I now know I can deal with this and feel so, so confident. Thank you, with all my heart thank you.

[tonytaf]

I've watched the 2 short vids on Pivot Tables, twice. Now I'm watching this one for the second time but this time I'm following along, I'm literally flying 😎😎😎

[joekriss]

This training is absolutely fantastic! Thank you so much. I found it extremely useful that you also taught how to clean up the data. This is an important step and knowing the techniques you taught will speed up my workflow considerably. I was doing many of these things manually and learning a better way was very helpful to me. Thank you again, much appreciated!

[wwpharmacist]

No words to describe the value added to my knowledge from this amazing video, many thanks

[margaretdsouza]

Words cannot describe how great a Tutor you are. Very detailed and clear voice modulation. God Bless !

[ElvisTamba-kq]

I can't explain how grateful I am to the Simon Sez team especially Deb Ashby. Detailed explanation and very helpful course files to follow along. My interest for learning has more than increase. Thank you for the training and may God bless you all.

[chukwunonsojoshua]

Finally finished the tutorial. It's well detailed and taught in an easy-to-understand language. Great job!

[mohangr]

This is one of the best courses and has so much value. Brilliantly done I learned so much in 2 hrs

[olusolaokuboyejo]

Fantastic tutorial Deb. Don't know how to express my delight. This is definite more than I was expecting. I was not expecting such clarity. Many thanks for making this easy to learn.

[rfdave]

Wow a fantastic tutorial. Ms. Ashby your are a expert in Excel. I have learnt so much, blown away at every lesson. This will help me make my reports quickly. Thank You.