Click Add to Data Model in the Tables group. Doing so generates another view of your data. Your Excel data is safe–you can’t edit the data in the Power Pivot view.

A pivot table is a must-have tool for power Excel users. It lets you see the bigger picture, where you can make sense of ...

Tip: Best practices for presenting pivot table data If you are new to using pivot tables for data analysis, check out these tips to get the best out of it. Highlight the most important insights ...

A great place to start learning about pivot tables is with The Ultimate 2022 Pivot Tables & Dashboard in Excel Bundle, which covers all the above concepts and more. It’s available now for a further 15 ...