This coming Saturday the second edition of the #DataWeekender online conference is going to take place. The conference contains 45 main sessions & 15 Lightning Talks. I am honoured to inform that my topic An introduction to the ImportExcel PowerShell module has been selected as one of the 15 short talks. The ImportExcel module by…Read More Speaking at #DataWeekender
I always used VLOOKUP formula, I could do it even with my eyes closed, but now when I have Excel 365 I can use XLOOKUP, which is similar but not the same. When I have learned this new functionality I found out that I also have an option to use dynamic array formulas in a…Read More XLOOKUP function and dynamic array formulas – Excel 365.
I found the CTRL+D shortcut key as an interesting feature in many programs. It can duplicate without using copy and paste. But not always. It is also D like DELETE, DISPLAY, or HIGHLIGHT… Microsoft Office Excel and Google Docs Spreadsheets. In Excel or Google Spreadsheet, CTRL +D duplicates content from the cell/cells row above. We need to…Read More D like Duplicate.
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…Read More Power Query installation.
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…Read More Microsoft Excel functionality – Data import from PDF – very useful tool.
Last week I have introduced you to ImportExcel PowerShell module and its capability to manipulate the worksheets and create pivot tables and pivot charts. This week let’s jump on some other features: conditional formatting and charts. ImportExcel – how to? If you have not installed the module before, use the below code to do so…Read More PowerShell into Excel:ImportExcel Module Part 2
While ago I needed to do some manipulation on Excel spreadsheets but had no Office installed on the server. For the specific case, I looked for a way to complete my task with the PowerShell. A quick look into Google search results and… Even though the name is not specified, both articles talk about the…Read More PowerShell into Excel:ImportExcel Module Part 1