Microsoft Is Adding Natural Language Queries to Excel

Posted on November 5, 2019 by Mehedi Hassan in Microsoft 365, Office 365 with 1 Comment

At Ignite yesterday, Microsoft announced a whole lot of new products and services. And amongst all the big news, there was a small announcement about Excel that caught my eye: Excel is getting language queries. Yep.

You will no longer need to write complicated formulas every time you want to query something. And although Excel is known for its formulas and all the amazing things you can do with those formulas, novice Excel users will probably appreciate this new feature quite a lot.

The feature will be available as part of Ideas in Excel and allows users to ask questions about their data without writing the complex formulas. You can simply ask things like “What was the sum of sales from last month” for example. Excel will also provide its answers with charts, or pivot tables that you can insert directly into your spreadsheet.

It’s first launching in English for Windows, Mac, and Excel for the web, but Microsoft plans to expand to other languages in the future.

Tagged with ,

Elevate the Conversation!

Join Thurrott Premium to enjoy our Premium comments.

Premium member comments on news posts will feature an elevated status that increases their visibility. This tab would allow you to participate in Premium comments with other premium members. Register to join the other Premium members in elevating the conversation!

Register or Subscribe

Join the discussion!

BECOME A THURROTT MEMBER:

Don't have a login but want to join the conversation? Become a Thurrott Premium or Basic User to participate

Register