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

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.

I hope you enjoy the video! :)

Don