✅ 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

🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ [ Ссылка ]

🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ [ Ссылка ]

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

🔥Check out our FREE 300+ hour training course playlist here ➡️
[ Ссылка ]

✅ Check out our free video playlist for PivotTables 👉[ Ссылка ]

✅ Pivot Tables - All you can Eat playlist here 👉[ Ссылка ]

✅ Microsoft Excel Tips and Tricks 👉[ Ссылка ]

✅ Advanced Pivot Tables in Excel here 👉[ Ссылка ]

💬Stay in touch!
SimonSezIT.com: [ Ссылка ]
LinkedIn: [ Ссылка ]
FaceBook: [ Ссылка ]

🔔 Subscribe to our channel:
[ Ссылка ]

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

свернуть