Download the free course files to follow along
️https://www.simonsezit.com/pivot-table-beginners-instructor-files/

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.

https://www.simonsezit.com/pivot-table-beginners-instructor-files/

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

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for PivotTables https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

Pivot Tables - All you can Eat playlist here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Advanced Pivot Tables in Excel here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hhKEX9VBkzc8_bJ3Yjd6Pd

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

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