What are some guidelines/reccomendations with code in the MS Excel VBA editor. Do I insert a "New Module" so it is available to all the workbooks or do I put the code in the Sheet1 module section. If I only have a workbook that has 1 sheet then what difference does it make (other than from an organizational perspective) if I create a new module or place it in the Sheet1 module (Underneath MS Excel Objects/Sheet1(Sheet1)
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
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…
While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful. I tested several solutions and share the results in this article as well as t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.