MART for Excel

Supercharges You

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.

COMPARE WORKBOOKS

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.

UNPROTECT SHEETS

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.

REVIEW LOG

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.

DATA FLOW

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

INSTANT MAP

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

FORMULA CONSISTENCY

Highlight all the ‘must check’ formulas any inconsistent formulae in a selected range to identify the ‘must check’ formulas

COMPARE WORKSHEETS

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

METADATA

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

USED RANGE

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

SHEET SIZE

Find out the size (in Kb) of every single worksheet of a workbook

© Copyright 2019 MART Software GmbH. All rights reserved.

Privacy • EULA • Impressum