Advanced Pivot Tables Tutorial in Excel - 2.5 Hour Pivot Table Excel Course
Follow-along with the Advanced Pivot Tables tutorial and download the accompanying Excel exercise files here ► https://www.simonsezit.com/adv-pivottables-course-exercise-files/
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.
This video is taken from the full, Simon Sez IT, Advanced PivotTables in Excel course, available here: https://www.simonsezit.com/courses/microsoft/advanced-pivottables-in-excel-training-course/
You can also download the practice exercises for free and follow along here ► https://www.simonsezit.com/adv-pivottables-course-exercise-files/
Advanced Pivot Table Course Markers:
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
To see more, free Advanced Excel tutorials, take a look at this 4.5 hour YouTube course: https://youtu.be/gjfjn8Lwa28
To see a basic Excel course on YouTube, go here: https://youtu.be/ZNGqeCcTu0Q
Other, free Microsoft 2019 playlists from Simon Sez IT:
Microsoft Project 2019 course playlist: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jo_PtA6h6LNhvMbWNtJsXL
Microsoft Excel 2019 Beginners playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg
Microsoft Excel 2019 Advanced playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a "thumbs up" and subscribe
to the channel ;-)
Видео Advanced Pivot Tables Tutorial in Excel - 2.5 Hour Pivot Table Excel Course канала Simon Sez IT
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.
This video is taken from the full, Simon Sez IT, Advanced PivotTables in Excel course, available here: https://www.simonsezit.com/courses/microsoft/advanced-pivottables-in-excel-training-course/
You can also download the practice exercises for free and follow along here ► https://www.simonsezit.com/adv-pivottables-course-exercise-files/
Advanced Pivot Table Course Markers:
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
To see more, free Advanced Excel tutorials, take a look at this 4.5 hour YouTube course: https://youtu.be/gjfjn8Lwa28
To see a basic Excel course on YouTube, go here: https://youtu.be/ZNGqeCcTu0Q
Other, free Microsoft 2019 playlists from Simon Sez IT:
Microsoft Project 2019 course playlist: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jo_PtA6h6LNhvMbWNtJsXL
Microsoft Excel 2019 Beginners playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg
Microsoft Excel 2019 Advanced playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a "thumbs up" and subscribe
to the channel ;-)
Видео Advanced Pivot Tables Tutorial in Excel - 2.5 Hour Pivot Table Excel Course канала Simon Sez IT
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Advanced Pivot Table Techniques: Combine Data from Multiple Sheets in ExcelExcel PivotTables Made Easy - And Why Things Go Wrong!Microsoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners!Advanced Pivot table tricks for Reporting and AnalysisOneNote Tutorial: Getting Started with Microsoft OneNote - OneNote Class50 Ultimate Excel Tips and Tricks for 2020LOOKUP Functions in Excel VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP Tutorial4 Advanced Pivot Table Tips in ExcelData cleaning in Excel - 10 tricks *PROs* use all the timeAdvanced Pivot Table Options in Excel |Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)Creating an Interactive Dashboard in Excel Using Pivot Tables, Pivot Charts and SlicersMost of Excel users are not using full features of pivot table5 Excel Functions YOU NEED in 2021Power Pivot Tutorial & Power Query in Excel - 1-Hour ClassMicrosoft Excel Tutorial for Beginners - Full CourseThe Ultimate Pivot Table Microsoft Excel Tutorial (Free Course)Pivot Table Super Trick in MS Excel | Excel Tutorials 20219 Useful Excel Pivot Table Tips everyone should know