MART for Excel
In Many Ways
FORMULA EXPLORER & VLOOKUP
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.
REMOVE EXTERNAL LINKS
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
Highlight all the ‘must check’ formulas any inconsistent formulae in a selected range to identify the ‘must check’ formulas
Detect and list all formula differences between two (or more) worksheets of a workbook
REMOVE CUSTOM STYLES
Remove all unwanted custom styles that slow down your workbook
FREEZE & DELTA
Create a delta worksheet to sensitivitize changes versus the current status of a worksheet
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
Find out the size (in Kb) of every single worksheet of a workbook