Flatten Names
Replace named ranges in formulas with direct cell references so reviewers can see the exact cells being read. Optimized for large financial models and backed by the Name Conversion restore snapshot.
Formula Intelligence · Ribbon group: Formula Tools + Name Conversion
Explain formulas, trace dependency paths, and control named ranges inside Excel.
Formula Intelligence is the review cockpit for inherited or high-stakes workbooks. CalcScope explains the selected formula, Trace maps precedent and dependent paths, TrustLens adds evidence context, Sensitivity ranks drivers, and Name Conversion lets reviewers flatten or reapply named ranges with a restore path.
Ships in every planFormula ToolsName Conversion
Investment banking & PEProject finance & PPPCorporate FP&AAudit & assurance
Name Conversion
Names should help review, not hide the cells.
Named ranges can make an operating model readable, but they can also obscure the exact cells a formula uses. Formula Intelligence gives reviewers a reversible path: flatten names for inspection, apply existing names for readability, then restore the last pass when the review needs to back out.
Why it deserves its own space
Reviewers can switch between readable formulas and exact cell references.
- Flatten Names exposes the literal cells behind defined names.
- Apply Names returns formulas to readable notation using existing names only.
- Restore Last Name Conversion keeps the pass reversible while the snapshot exists.
Apply Names
Scan formulas and replace matching cell references with existing defined names. Strict mapping only: no new names are created, so the model returns to readable named-range notation without inventing structure.
Restore Last Name Conversion
Undo the most recent Flatten Names or Apply Names pass while the in-memory snapshot exists. Reviewers can inspect formulas in reference form, then back out the conversion if needed.
Formula Review Cockpit
From selected formula to clean handoff.
Explain the formula, map its paths, prove its state, and convert names when exact references matter. The workflow stays inside Excel and keeps the workbook ready for review.
CalcScope
Explain
Decompose the selected formula into live rows, branch state, and eligible no-write what-if sliders.
Trace
Follow
Move between precedent and dependent paths while keeping the cockpit focused on Explain, Follow, and Prove.
TrustLens
Prove
Check proof state, drift, path reasoning, timelines, and live dependents before handoff.
Flagship features
Core tools in the inspection workflow.
The surfaces reviewers reach for first when a formula needs to be understood, traced, tested, or defended.
Trace Precedents
Walk upstream from the selected cell and navigate directly to the inputs feeding the current formula.
Formula Explorer (Flow Diagram)Ctrl+Shift+W
Use Drill view for formula logic and List view for direct precedents, then export the map into review packets.
TrustLensCtrl+Shift+I
Inspect proof state, drift, result values, path reasoning, proof timeline, and live dependents from one formula workbench.
CalcScope
Open a floating calculation explainer with live values, branch state, find/edit controls, and no-write what-if sliders where eligible.
Dock CalcScope
Keep a read-only review cockpit beside the grid with Explain, Inputs, Impact, Scope, and Hidden views following selection.
Sensitivity AnalysisCtrl+Shift+S
Rank the drivers that matter across multiple outputs, with quick scan, top-N filters, navigation, and copyable data.
Also in this capability
Supporting tools and utilities.
- Trace DependentsWalk downstream from a selected input to the formulas, outputs, and review paths that depend on it.
- Classic Pretty PrintCtrl+Shift+YUse the classic compact formula view with indentation, syntax highlighting, clickable references, and the Ctrl+Shift+Y shortcut path.
Same product, more capabilities