Pivot Tables Excel: Detailed Beginners Pivot Table Tutorial
Автор: Simon Sez IT
Загружено: 2021-11-03
Просмотров: 438874
✅ Download the free course files to follow along
➡️https://www.simonsezit.com/pivot-tabl...
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-tabl...
📝 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/
🚀 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! ➡️ https://simonsezit.lpages.co/ssit-14-...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Training Courses
✅ Check out our free video playlist for PivotTables 👉 • How to Use Pivot Tables in Excel - The Ult...
✅ Pivot Tables - All you can Eat playlist here 👉 • Pivot Tables - All you can Eat - Dine out ...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips and Tricks
✅ Advanced Pivot Tables in Excel here 👉 • Advanced Pivot Tables in Excel Tutorial
💬Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
https://www.youtube.com/simonsezittra...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
