I replaced Excel’s PivotTables with this extremely overpowered tool and haven’t looked back
www.makeuseof.com/excel-power-pivot-better-than-pivottables/
- Power Pivot – Overview and Learning – Microsoft Support
support.microsoft.com/en-us/office/power-pivot-overview-and-learning-f9001958-7901-4caa-ad80-028a6d2432ed - Start the Power Pivot add-in for Excel – Microsoft Support
support.microsoft.com/en-us/office/start-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8 - Get started with Power Pivot in Microsoft Excel – Microsoft Support
support.microsoft.com/en-us/office/get-started-with-power-pivot-in-microsoft-excel-fdfcf944-7876-424a-8437-1a6c1043a80b