VLOOKUP functions can be useful but it often takes some time to find out where the returned values are coming from. Use the Formula Explorer function to navigate to the origin cell of a VLOOKUP function with a single click.

Track changes is a very useful function in Word for version control but still not available in Excel. MART For Excel offers a track version function for Excel that helps me to see all changes in a workbook or worksheet with a single click.

External links of Excel files often remain in a file even after using Excel’s ‘break links’ function. In such cases I use MART For Excel’s clean-up function to get rid of the sticky links with a single click.

Often enough I forget about the password I used for my Excel models. MART For Excel offers an unprotect worksheet function for Excel with a single click.

As I am often reviewing Excel models, I was searching for an easy and efficient way to track my comments and to document our review process for internal and/or external purposes. MART For Excel offers a comment function for Excel that helps me to save my comments in a log file with a single click.

Visualize the data flow of any
Excel model to accelerate the understanding and to focus on relevant parts

Visualize all formula inconsistencies in a model and navigate directly to the critical formulas that should be reviewed

Detect and list all formula differences between two (or more) worksheets of a workbook

Remove all unwanted custom styles that slow down your workbook

Show any properties and information contained in the workbook file’s metadata

Find out the last used row and column in each of the worksheets to spot unwanted content