Add New Functions to Excel with Fast Excel SpeedTools Extras

July 26, 2022 - by Bill Jelen

There are several add-ins that add new calculation functions to Excel. One of the best is from Charles Williams and FastExcel. The SpeedTools Extras package includes functions that accountants will use in everyday work.

• Generate a vector of numbers to be used in amortization tables.
• Return an array of True/False values for each row or column.
• Reverse an array.
• Do wildcard matching with Regular Expressions (RegEx)
• Concatenate a range of text, specifying a delimiter

Check out these tools at https://tinyurl.com/fastexcel.

This article is an excerpt from Power Excel With MrExcel

Title photo by Max Bender on Unsplash