Find out how add-ins and templates can help you get the most out of Excel.
All items in the portfolio are distributed on a freeware license. If you find any of these tools useful or interesting, please consider following Excel Virtuoso on social media.
Add-ins are custom tools added to your Excel ribbon to be used in any workbook. The add-ins posted here add new features on top of Excel’s built-in functionality.
|Name Manager Plus||Download|
|A name management add-in that provides new functionality to move, categorize, and manage named ranges in Excel.|
|Remove Empty Rows||Download|
|This is an Excel data management add-in that will remove all empty rows or columns within large sets of data. Users have the ability to define a search range and various criteria to remove unwanted rows.|
Templates include business tools to help fill various needs.
|This is an Employee Timesheet Excel template that can be used to record individual employee time. Time is recorded on a daily basis on a calendar-like interface. Monthly data is provided on a summary tab in an easily view-able and printable format.|
|Coffee Brewing Methods||Download and Documentation||A simple financial model to compare the cost of coffee brewing methods.|
|Bond Ladder||Download and Documentation||An Excel/VBA implementation of a bond ladder portfolio and summary. Will calculate an average weighted yield for a ladder of bonds.|
VBA Functions and Excel Formulas
|Bubble Sort Functions||Documentation||The bubble sort is commonly used to sort simple arrays. Did you know that it can also sort other VBA data structures like 2D arrays and dictionaries?|
|VLOOKUPLEFT||Documentation||A custom Excel formula which allows VLOOKUP to reference from right to left.|