ModelxcelPro documentation

Full, detailed documentation for the ModelxcelPro Excel add-in: install and activate it, understand formulas, review models, improve workbook presentation, and manage licensing and reference workflows.

Private beta

ModelxcelPro is in private beta. The installer is not yet code-signed, so Windows SmartScreen may show an “unknown publisher” prompt during setup — this is expected for now, and the signed build ships before general availability.

Choose your task

These pages are the complete reference. They expand well beyond the quick, offline Help & Commands pane inside Excel — see In-Excel Help vs these docs below.

Get startedInstall ModelxcelPro, confirm the ribbon is loaded, and activate a machine-bound license.Understand formulasTrace formula flow, inspect calculations with TrustLens, explain formulas with CalcScope, and test sensitivity.Name ConversionFlatten defined names to direct references, apply existing names back into formulas, and restore the latest conversion pass.Review and audit modelsMap workbook structure, compare versions, triage review issues, and build Proof & Trust evidence.Improve workbook presentationApply smart formatting, manage themes, fit columns, and control formatting recovery.Security, licensing, and adminUnderstand license states, activation, local security, machine binding, and signing administration.ReferenceLook up keyboard shortcuts, settings, file types, and troubleshooting paths.

The ModelXcel Pro ribbon

Once installed, ModelxcelPro adds a single ModelXcel Pro tab to the Excel ribbon, organized into eight groups:

  • Format — smart formatting, themes, text case, auto-fit, and empty-reference highlighting.
  • Formula Tools — trace precedents/dependents, Flow Diagram, TrustLens, CalcScope, and Sensitivity.
  • Name Conversion — flatten and apply named ranges.
  • Map — Worksheet Map and Risk Heatmap.
  • Compare — workbook, version, and sheet comparison.
  • Audit — model health, review issues, and the audit trail.
  • Proof — bind, sign, verify, and certify a model’s derivation.
  • Help — the in-Excel Help pane, About, and License Status.

In-Excel Help vs these docs

The add-in ships a built-in Help & Commands pane (the Help button on the ribbon): quick, searchable, fully offline summaries you can read without leaving Excel. These web docs are the full version — deeper context, complete step-by-step workflows, expected output, examples, caveats and limitations, troubleshooting, file artifacts, and how features work together.