Financial calculations, data entry, and formulas are important components when dealing with finances in Excel. However, built-in worksheet-based functionality limits the design and scope of working with financial data. To truly unlock the financial power, we need to move beyond the grid of the worksheet and delve into the inner workings of Visual Basic for Application (VBA), and create re-useable code-based functions.
When using VBA, you now have the power to personalize the design and look of Excel to provide a rich and professional user-interface for internal use, or for sending information to third-party vendors or clients. For example, you can easily send a customer a worksheet with several lines of data to provide payment information; however, using VBA, you can now send your customer a personalized company-branded application that collects information and may or may not even display the Excel components. You can restrict or provide, as much of the application as you determine...