I Mastered GROUPBY and PIVOTBY in Excel and You Can Too!

Learn how to take your Excel skills to the next level by mastering the GROUPBY and PIVOTBY functions! In this tutorial, we'll dive deep into the world of data analysis and show you how to use these powerful functions to summarize and transform your data with ease. From grouping and aggregating data to creating custom pivot tables, we'll cover it all. By the end of this video, you'll be able to group and pivot like a pro, making you a more efficient and effective data analyst. Whether you're a beginner or an advanced Excel user, this video is perfect for anyone looking to improve their skills and take their data analysis to the next level. #excel #dataanalysis #powerquery #arrayfunctions #excelformula #pmo #fyp #groupby #pivotby #pivottable #slicer Delivered by  @Changetipsandtools  Link to previous video reference: https://youtu.be/PHFXVHtJYNo?si=qkTW_iookrrW0Stx Link to support file so you can follow along: https://drive.google.com/drive/folders/1-WKNM9QRAKQuzqrzUbmLThnYG8YEgh2x?usp=sharing In this video: 00:00 - Intro 00:49 - What we will explore in this video both the GROUPBY and PIVOTBY Functions 02:33 - GROUPBY Function 04:38 - Format numbers and apply conditional formatting for totals 09:19 - How to use a Slicer to filter with the GROUPBY Function 13:01 - PIVOTBY Function with filter based on the slicers Link to the UK Bingo Game in Excel training series for Parts 1, 2, 3 and 4 follow along so you can build it for yourself: https://www.youtube.com/playlist?list=PLHo4KrxeEewlJ6ml-POT-C8FT_aw0b6cW Or here is a link to Patreon, for the 8 Ticket version with full user instructions: https://www.patreon.com/ChangeTipsandTools/shop/ivans-uk-bingo-game-in-excel-365-642301