How to use Analyze Data in Excel (AI Creates Pivot Tables and Charts)

Microsoft Excel Tips and Tricks

Data analysis in Microsoft Excel has just gotten a LOT easier. A feature called “Analyze Data” uses AI (artificial intelligence) makes this process simpler, faster and more intuitive. This feature used to be called IIDEAS in Excel but it was renamed to “Analyze Data”. It automatically creates pivot tables for you so you don’t even need to think about what to put in the rows and what to put in the columns of the pivot tables. You’ll get pivot table and chart suggestions which you can immediately use. You’ll also get data insights you might not be actively looking for which could be important for your analysis. This tool simply makes analyzing data in Excel really easy.

Credit Leila Gharani