I don't use Pivot Tables in Excel anymore, I do this instead

Project Files: https://www.teachexcel.com/excel-tuto... Excel Tips by Email: https://tips.teachexcel.com In this tutorial, you'll learn how to create Pivot Tables in Excel without the use of actual Pivot Tables. This will include new Excel functions and new AI functionality from Chatgpt (OpenAI). I’ll cover the new Excel GROUPBY and PIVOTBY functions, and show you how they can replace many traditional PivotTable workflows. We'll start with the basics and then build increasingly powerful examples that show how these modern dynamic array functions can summarize, group, filter, sort, and analyze data with far more flexibility than traditional PivotTables. You'll also see how to combine these functions with Excel's latest AI tools to quickly generate reports, uncover insights, and create dynamic summaries that automatically update as your data changes. Topics Covered: How to use the GROUPBY function How to use the PIVOTBY function How to create Pivots using AI How to create PDF reports using AI How to make advanced prompts in AI Whether you're an Excel beginner or an advanced user, these techniques will help you build cleaner, more powerful spreadsheets with less effort. If you'd like to learn more about automating Excel, check our Excel Automation Courses (linked below). I hope you enjoy the video! :) Don ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~ Downloadable File ~~ https://www.teachexcel.com/excel-tuto... ~~ Automation Courses (50-80% off) ~~ https://courses.teachexcel.com/ ~~ AI Course Pre-signup Discount ~~ https://notify.teachexcel.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 00:00 Intro 00:25 Final Result 01:20 Data Setup 01:37 Pivot Tables the Old-Fashioned Way 05:05 Create Pivot Tables with Formulas (GROUPBY) 11:28 Create Pivot Tables with Formulas (PIVOTBY) 15:05 Benefit of Pivot Formulas over Pivot Tables 16:17 Make Pivot Tables & PDF’s without Excel (One Shot) 19:21 Make Pivot Tables & PDF’s without Excel (Multi-step) #Excel #ai #pivottable #finance #data