ModelMint Features: Excel Tools for Financial Analysts

Formula Trace

Walk a formula's precedents or dependents one layer at a time, navigating the sheet as you go. The live reference lights up right inside the formula bar.

Formula Trace
Formula Trace walking a formula's precedents while the formula bar highlights the live reference

Find Hardcodes

Surface plug numbers typed straight into formulas, the sneaky =Rev*1.05 fudges, and select them in one click.

Find Hardcodes
Find Hardcodes selecting plug numbers buried inside formulas

Find Dependents

See every cell and sheet that references the one you're on, then jump straight to any of them.

Find Dependents
Find Dependents listing every cell that references the selected one

Color Coder

Paint cells by role, inputs, formulas, links and errors, so a model's structure reads at a glance.

Color Coder
Color Coder painting cells by role so model structure reads at a glance

Name Scrubber

Filter, rename, hide, or delete defined names in bulk, and sweep out broken #REF! orphans.

Name Scrubber
Name Scrubber selecting and deleting broken #REF! defined names in bulk

Format Cycler

One shortcut cycles your selection through the number formats analysts actually use, from general to comma, currency, and percent.

Format Cycler
Format Cycler changing number formats

Error Wrap

Wrap a selection in IFERROR, or strip an existing wrapper out, without retyping a single formula.

Error Wrap
Drop in assets/error-wrap.gif

Paste Exact

Paste formulas, formats, and column widths exactly as copied, with no shifting references.

Paste Exact
Drop in assets/paste-exact.gif

Copy as Image

Copy any range as a crisp, high-resolution image, ready to paste into a deck or an email.

Copy as Image
Drop in assets/copy-image.gif

Prepare to Share

Run a one-click pre-send cleanup: hide gridlines, reset zoom, check external links, and clear document metadata.

Prepare to Share
Prepare to Share running a pre-send cleanup

Send Workbook

Email the workbook or the active sheet as a PDF, an Excel file, or both, dropped straight into an Outlook draft.

Send Workbook
Send Workbook creating an Outlook draft with PDF and Excel attachments