✅Download the free course files and follow along here:
➡️https://www.simonsezit.com/data-models-pivottables-and-power-query-in-excel-demo-files
This course introduces you to advanced data analysis techniques by combining the power of PivotTables, data models, and Power Query. Learn how to summarize and analyze large data sets using PivotTables. Unlock the power of data models for organizing multiple data sources. Streamline your data preparation process with Power Query. Connect multiple data sources, clean and manage data, and create insightful analysis in Excel.
? Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Course Introduction
00:01:29 - Introduction to PivotTables, Data Model, and Power Query
00:05:10 - Analyze Data with PivotTables Part 1
00:13:07 - Analyze Data with PivotTables Part 2
00:16:52 - Filters and Slicers in PivotTable
00:19:42 - Get and Transform Data with the Power Query Editor
00:28:16 - Create Relationships using the Data Model
00:32:51 - Create a PivotTable from the Data Model
00:39:19 - Edit and Customize Data with Power Query Editor
00:44:58 - Course Conclusion
? Get unlimited training with Simon Sez IT’s 200+ 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-day-free/
? Watch more free popular training tutorials from Simon Sez IT:
?Check out our FREE 400+ hour training course playlist here ➡️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
? For a full training experience, check out our FREE YouTube course: ? https://www.youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks ?https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here ?https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
?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 ?? ;-)