excel

Post thumbnail

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.

Post thumbnail

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.

ImportExcel - PowerShell module ImportExcel - PowerShell module

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

ImportExcel - PowerShell module ImportExcel - PowerShell module

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