This custom function generates triangular distribution with a specified minimum, maximum and mean.

Sometimes we have a task to go through a number of files and make some changes in each of them or pull data from them. In this article we will have a look at the Excel-VBA code which allows to do all of that.

Excel-VBA script for running simple Monte-Carlo simulations in Excel (no add-ins required).

All you need to know to get rid of 80% of your routine and focus on more interesting tasks

In the first part we will discuss instruments, which I wish I have known how to use when I have started my first job as a Budget Analyst. They would have allowed me to automate 80% of the routine and save hundreds of hours of time.