Excel tricks: get answers without writing a formula

By on
Excel tricks: get answers without writing a formula

Microsoft is pitching the new feature at novices or power users who want to save time.

Microsoft has just announced a new Excel feature that enables you to type ‘natural language’ questions, instead of writing a formula.

For example, you might type “What were the sales for clothing products?” and Excel will provide the answer in a chart.

Or you could type “Total sales of locks and helmets?” to see the answer.

Excel can respond with formulas, charts or pivot tables. There’s more details about this here

Here’s Microsoft’s explanation of who might use this feature: “It’s for the novice users who may not know how to write the right formulas to gain useful insights from their data, the power users who can save time by simply asking the right questions and quickly adding charts and tables, and everyone in between.” 

The feature is initially only available if you’ve joined the Office Insider program, and for now it runs on Windows, Mac and Excel for the Web.

Copyright © BIT (Business IT). All rights reserved.

Most Read Articles


What would you like to see more of on BiT?
How To's
Photo Galleries
View poll archive

Log In

  |  Forgot your password?