power query – Mikey Bronowski

2020-09-19 by Magda 0 comments

Power Query installation.

While I was preparing to work in the new (for me) Microsoft Office 365, I learned that Excel 365 already has the “built-in” Power Query add-in. It does not appear directly on the ribbon. It is located under the DATA tab. For previous versions of Excel, the Power Query add-in should be downloaded from the…

2020-09-15 by Magda 0 comments

Microsoft Excel functionality – Data import from PDF – very useful tool.

Many times happened to me when I received a PDF file with a table that I had to “type” into the program manually. Fortunately, the data didn’t have too many lines 10-20 at most, so it wasn’t time-consuming, but it was frustrating and it could cost a mistake. I wish I knew that before.This option…