Thinking that it will make it easier to process and organize data from Excel, Microsoft Office is working on a feature, widely requested by many users, and that is obtaining data from pdf files. This feature is currently in the Office for Windows beta options.
The Microsoft team has reported that they will be adding this option, and in a very simple way. Although it is true that many users use other tools to extract the data manually, Excel will do it in a simple way, making a few clicks in the program and following the path “Get Data”, “From Files”, option “From PDF”. Great and simple.
The new feature is in the early stages of testing the Office Insider program, it will take a while to get to the desktop version of Office.
What you can try, if you are part of the Insiders Program, are the new pivot tables from “Power BI” data. Let’s remember that Power BI is a Business Intelligence (BI) tool incorporated in the Office 365 suite, which allows you to analyze and interact with a massive amount of data, inside Excel, and to easily obtain searches and access data inside and outside the organization and from almost any device. In addition to the possibility of creating attractive and interactive visualizations.
To access this feature the shortest route is to click on the Data tab, select “Get Data”, then “From Power BI”.
In its last updates, Microsoft Office, improved the option to save the worksheets that contained multiple formulas with defined names, in addition to solving the error, when saving, “This workbook is currently referenced by another one and cannot be closed”, due to the add-ins were loaded in alphabetical order and not in the order specified by the user.
Without a doubt, updates that will make the use of Excel more dynamic and simple in our daily work.
