Microsoft working to bring natural language, speech input to Excel

Summary:Microsoft researchers are working on a new, future Excel feature that combines natural language and automatic programming technologies to make queries and data analysis easier.

If you liked Flash Fill for Excel 2013, you're going to love Analyze for Excel. And if you're an Excel user who hasn't heard of either, read on.

Flash Fill is a feature baked into Excel 2013 that enables Excel to fill in information based on examples of what a user wants. As explained in a recent Microsoft Research write up, a user could type a correctly formatted example of names or numbers and FlashFill will automatically fill in the rows below the example with the same formatting. (Microsoft Research and the Office 2013 team worked together on the Flash Fill feature.)

flashfill

Microsoft Researchers are now working on the follow-up act, known as Analyze for Excel. During a presentation at the recent Microsoft Research TechFest 2013 event -- the part that was for employees only and closed to outside guests -- researchers provided a demonstration of Analyze. Stephen Chapman unearthed a video clip of that demo and published it to his MSFTKitchen site last week.

Analyze uses natural-language tools and automatic-programming-generation techniques to allow users to perform basic calculations and other analytic tasks inside Excel spreadsheets. Instead of having to figure out a way to generate a specific query, users will be able to type in requested information, such as "who got paid the most," and let Analyze do the work of parsing and answering.

At the end of the video clip showing off Analyze, Microsoft Chief Technology Officer Eric Rudder says that eventually speech input will be enabled, allowing users to query Excel by voice.

There was no timetable revealed as to when Analyze will be available as part of a next version of Excel or as a standalone module. But based on the video clip, it sounds like Microsoft officials soon could start using Analyze as one of many examples of machine learning technologies that the company is honing.

While on the topic of Office productivity tools, it's worth mentioning Microsoft updated the Metro-Style/Windows Store version of its OneNote note-taking app last week. The update includes pen and inking improvements, plus support for Office 365 notebooks.

Topics: Emerging Tech, Business Intelligence, Microsoft

About

Mary Jo Foley has covered the tech industry for 30 years for a variety of publications, including ZDNet, eWeek and Baseline. She is the author of Microsoft 2.0: How Microsoft plans to stay relevant in the post-Gates era (John Wiley & Sons, 2008). She also is the cohost of the "Windows Weekly" podcast on the TWiT network. Got a tip? Se... Full Bio

Contact Disclosure

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Related Stories

The best of ZDNet, delivered

You have been successfully signed up. To sign up for more newsletters or to manage your account, visit the Newsletter Subscription Center.
Subscription failed.