Excel provides numerous functionalities that can be leveraged to create powerful data analysis and financial worksheets; however, it is not possible to cover all of the needs of every user. Therefore, it is necessary to create additional pieces of functionality that can be added or inserted into Excel; these will enhance or augment the existing features available.
Unlike creating large macros via code that handle large-scale duties such as loan amortization plans and worksheet security; add-ins are small enhancements that are usually continuously available and used within a sheet.
In this chapter, you will learn to create code-bits and other add-in items that will augment current functionality, allowing for the counting of colors within Excel, quick date conversion, modification of the Excel ribbon, and other useful items that will enhance the financial analysis process. While some of the recipes in this section will focus on analysis, many of the code bits provide timesaving...