Business Case Study

The Problem / Challenge:

Excel only has built-in functions for the most common tasks.
When you need to perform a calculation or return specific information you often have to write your own function.
Users have two options:
(a) Create a long (and often complicated) formula
(b) Write a VBA user defined function
and both of these options come with several disadvantages.
Using a Formula means that the entire formula has to be copied across into every cell and every workbook.
These formulas can be accidentally modified and difficult to update and manage at a later date.
Using a VBA user defined function means that the code has to be copied across into every workbook and the file extension of the workbook has to be changed.
Having VBA in your workbooks often causes security concerns and will not work online.

The Solution / Answer:

To solve this problem for our customers we have created an Office add-in that allows custom functions and formulas to be centrally managed.
This allows users to quickly insert them into their workbooks without creating any type of dependency on the add-in itself.
All the functions and formulas are created as lambda functions which are saved within the Name Manager dialog box.
This means you can spend a lot more time on analysing and interpreting your numbers instead of worrying about the calculations.

Features Include:

• Formulas are not duplicated across multiple cells and worksheets.

• New formulas can be quickly added.

• Old formulas can be quickly removed.

• Existing formulas can be easily updated.

• All the functions are well documented with examples

• The functions can be manually copied and pasted between workbooks.

• The functions have already been tested and their accuracy validated.

• The add-in can be quickly installed via the office store.

• The add-in can be quickly deployed within a large organisation.

• The add-in includes a dedicated Functions tab for fast access to both built-in and custom functions.

• Sample data can be quickly inserted.

Get In Touch

To arrange a no obligations demonstration, please contact us.