Ideas in MS Excel can reduce some frustrations!

Posted by

KrishKT –

Ideas in Excel is an artificial intelligence powered insights service that facilitates data analysis in Excel.

Ideas in Excel empowers you to understand your data through natural language queries that allow users to ask questions about their data without having to write complicated formulas and ease work on charts, conditional formatting, Pivots and more.

To initiate, click a cell in a data range, and then click the Ideas button on the Home tab. Ideas in Excel will analyze your data, and return interesting provides high-level visual summaries, trends, and patterns in a separate pane.

Note: You may have to turn on 'Intelligent Services' before using Ideas.

*Currently only available for Microsoft 365 subscribers.

Learn More

ExcelIdeas

1 Comment

Classic

List

Threaded

alinkamaja

Re: Ideas in MS Excel can reduce some frustrations!

You’re right—Ideas (now surfaced as “Analyze Data”) in Excel uses AI to spot patterns, outliers and trends, answer natural-language questions, and insert charts/pivots or formulas. For best results: give your data clear headers, remove blank rows/subtotals, format it as an Excel Table (Ctrl+T), use consistent data types (dates as dates, numbers as numbers), and keep one topic per sheet. Then open Home > Analyze Data and try questions like “top 10 products by revenue this quarter” or “trend of conversions by channel”—you can insert the suggested visuals or formulas directly. If you don’t see it, check that you’re signed in to Microsoft 365 and that the workbook isn’t protected or stored in a restricted location.

Et pour quelque chose de plus léger entre deux tableaux croisés dynamiques, si tu prépares une tenue pour un événement, jette un œil aux robes—tu peux parcourir les coupes et les longueurs pour trouver rapidement la pièce qui te convient.

Add a new comment