How to use Ideas in Excel

Ideas in Excel helps you to understand your data through natural language queries that allow you to ask questions about your data without writing formulas that are, pretty complicated. Ideas also analyzes and provides high-level visual summaries, trends, and patterns.

How can I use Ideas for Excel?

Excel has a pretty high learning curve because anybody can master its basic features pretty fast. Things get a little bit tricky when you get to formulas, right? And you have to become a little Excel master to know them by heart.

In the Ideas tool, you can use Natural Language Queries which is self-explanatory. You are able to ask complicated information like data questions with formulas, charts, or pivot tables in a very easy and common way.

To put it even more lightly, it’s like the Google search in Office.

Using the Ideas in Excel

Microsoft developers explain the exact process in the release notes:

Simply click a cell in a data range, and then click the Ideas button. Enter a question in the query box at the top of the pane, and press Enter. Ideas will provide answers that you can insert into the workbook in the form of charts, tables, PivotTables, and formulas answers.

ncG1vNJzZmivmaOxsMPSq5ypp6Kpe6S7zGiorp2inrK0ecidnJqrXZrFpLHLaA%3D%3D