Microsoft Excel Updates

I tried a few online utilities. Some messed up the data. Others did not preserve the cell formatting (number as text). I am currently downloading the trial of Adobe Acrobat XI Pro. It is supposed to have a 30 day fully functional trial. I guess the safest option would be to get the source to provide data in Excel format :\ Insane.
 
Bringing AI to Excel—4 new features announced today at Ignite - Microsoft 365 Blog

Introducing intelligent suggestions with Ideas
Ideas is an AI-powered insights service that helps people take advantage of the full power of Office. Proactively surfacing suggestions that are tailored to the task at hand, Ideas helps users create professional documents, presentations, and spreadsheets in less time. In Excel, for instance, Ideas helps identify trends, patterns, and outliers in a data set—helping customers analyze and understand their data in seconds. Ideas will be generally available in Excel soon and will also begin rolling out in preview to other apps starting with PowerPoint Online. Simply click the lightning bolt icon in Excel or PowerPoint Online and Ideas will start making recommendations.

Ideas in Excel - Excel

Making new data types generally available
Excel has always been great at helping people make the most of numbers. But now Excel can do even more: It can recognize real-world concepts, starting with Stocks and Geography. This new AI-powered capability turns a single, flat piece of text into an interactive entity containing layers of rich information. For instance, by converting a list of countries in a workbook to “Geography” entities, customers can weave location data into an analysis of their own data. And this new capability—though deceptively simple—opens a whole new world of possibilities. As we add new data types over time, Excel’s rows, columns, cells, logic engine, and tools can be used to organize, analyze, and reason over any combination of numbers and sophisticated entities. The Stocks and Geography data types are rolling out to general availability next month.

Excel data types: Stocks and geography - Excel

This one below is pretty awesome:

Saying goodbye to manual data entry
With Insert Data from Picture, you can take a picture of a printed data table with your Android device and convert that analog information into an Excel spreadsheet with a single click. New image recognition functionality automatically converts the picture to a fully editable table in Excel, eliminating the need for you to manually enter data. Insert Data from Picture will be available in preview for the Excel Android app soon.

nZjHyGv.gif
 

Back