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.
Requires Excel for Microsoft 365.
Analyzing data in Excel using AI-assisted features such as pivot tables and charts can help uncover trends, correlations, and other insights that may not be immediately obvious from looking at raw data. Pivot tables allow you to take large amounts of data and summarize it into meaningful information by reorganizing or ‘pivoting’ the data around different fields. Charts are visual representations of your data that make it easier to compare values between categories, identify patterns, and draw conclusions. With AI-assisted features like these, you can quickly spot problems or opportunities within your datasets without needing a deep understanding of statistical analysis techniques.
Click anywhere in the data. · On the INSERT tab, in the Charts group, pick Recommended Charts. · On the Recommended Charts tab, pick any chart with the PivotChart ...
Click a cell in the source data or table range. · Go to Insert > Recommended PivotTable. · Excel analyzes your data and presents you with several options, like in ...
Select a cell in your table. Select PivotTable Tools > Analyze > PivotChart. Select a chart. Select OK.