I've been trying to simplify a series of procedures in one module to a single procedure using Case in the module. The module is named modInsertImage and within the module are numerous like procedures. The module is accessed in the Worksheet_SelectionChange event.
I can't get there? Dashboard-rev.xlsm
Let's assume that the topics were not broken down by category and so all the topics were in one list and you wanted to copy the image for "Sparklines in Tables". I'm sure you can see how in that situation
This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results.
Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…