by mor | Jan 28, 2021 | Blog
Excel offers hundreds of functions out-of-the-box * SUM(), VLOOKUP(), NPV() – to name a few * What if you need a function to do something unique, not included in the book? The answer: write it yourself! Here is how. Functions in Excel One of the first things you... 
by mor | Jan 21, 2021 | Blog
Are you automating annual Workbooks, monthly PDF reports, or producing any other dynamic files with Excel? Your program needs to automatically save each file in a folder. Here is how you can construct the full path and filename with a couple of VBA functions What is a... 
by mor | Jan 14, 2021 | Blog
When preparing a dynamic report in Excel, you need to arrange the data in the report structure. In this Blog post I demonstrate how to clear the report range and re-populate it with data. Types of reports Reports can take many forms, as far as presenting data is... 
by mor | Jan 7, 2021 | Blog
Take your Excel model one step further beyond calculations. Prepare and publish the final report as a slick PDF file with a click of a button. Here is how… Why PDF PDF has become to be the standard file format for immutable documents. Immutable, for those not computer... 
by mor | Dec 31, 2020 | Blog
Do you need to generate Excel reports based on a template on a regular basis? Do you need to copy the template Worksheet to another Workbook, or from another Workbook? Here are some approaches with VBA code Possible use cases for Excel templates Your monthly report is...
Recent Comments