The add-in

Axmo lives in one ribbon tab and one task pane. Everything the add-in does is reachable from those two places — there is no separate application, no account, and nothing running outside Excel.

The ribbon

Installing Axmo adds a tab called Axmo Model, alongside Home, Insert and the rest. Every button on it, left to right, with the group each sits in:

The Axmo Model tab in Excel, showing seven groups of buttons: Model, Analyse, Data, Worksheet, View, Share and Learn & Improve. — The Axmo Model tab, as it appears in Excel.

Group	Control	Description
Model	Properties	View and edit the model name, description and settings.
	Dimensions	Open the Dimension Editor to add, rename, or restructure dimensions.
	Data Series	Open the Series Editor to define the dataseries, formulas, connected dimensions and aggregation rules.
Analyse	Model Map	Open the Model Map to explore data-series dependencies, lineage, and unused series.
Data	Update	Compiles the model, reads your input data again, and recalculates every value.
Data	Data Loaders	Open the Data Loader Manager to configure Series Loaders and Dimension Generators.
Worksheet	Input Ranges	Open the Input Ranges Editor to declare the worksheet ranges the model reads and the loaders attached to them.
	Axis Definitions	Open the Axis Definition Editor to define reusable row and column layouts.
	Output Ranges	Open the Output Range Editor to configure where computed values are written.
View	Show Panel	Open the Axmo Data Modelling task pane.
Share	Export	Export the model to an `.axmo` file.
Share	Import	Import a model from an `.axmo` file, replacing the current model.
Learn & Improve	Load Demo	Browse and load a ready-made demo model to explore how Axmo works.
	Learn	Open the Axmo learning hub with guides, tutorials, and examples.
	Feedback	Send feedback or report an issue to the Axmo team.

The panel

Open the panel yourself. The first thing to do in any workbook is Axmo Model → View → Show Panel. On a workbook with no model it says No model found — starting fresh.

The panel has four tabs — Status, Active Sheet, Inputs and Outputs. The one you'll live in is Status; it reports:

the model — its name, and what it's made of: how many dimensions, series, sources, loaders, axis definitions and output ranges;
the current status — one label with a coloured dot, saying what is true of the model right now (see What the status says, below), and beneath it anything you should read;
actions — Update, which compiles the model, reads your input data again and recalculates every value;
the last operation — when the model was last updated, and how long compiling and recalculating took.

Active Sheet lists the Input Ranges and Output Ranges on the worksheet you're looking at. Select some cells and every range they belong to is highlighted in the list — the quickest way to answer what is this sheet actually doing.

Inputs lists the model's data sources; Outputs lists its output ranges. Clicking a name takes you to it on the worksheet — Axmo activates the sheet and selects the range. Each row also carries an Edit button, which opens the matching editor with that item already selected, and an output range's row adds a Filt. button for its filters. Where you have moved an output range's table, going to it follows the table rather than the place it was first written.

A reference Excel can no longer find is marked not found on its row, in Active Sheet and in Inputs — Connect your data explains why that happens and what Axmo does when a range moves.

Axmo also brings the panel forward by itself: when you choose Navigate from the right-click menu; when it has a question about an Input Range; when you close an editor with its ✕ while it still holds unsaved changes; and when an Update ends, if the setting Bring the Status tab forward in Model Properties asks for it — by default, when a new error appears.

What the status says

The label names the most serious thing that applies, and the messages beneath it list the rest. Only Up to date is green.

Status	Dot	What it means	What to do
Compilation error	red	The model's definition has an error, so nothing was calculated.	Read the message beneath it, which names the object, and fix it in its editor.
Run-time error	red	The model compiled, but the calculation could not complete, or a source could not be read.	Read the message beneath it.
Run-time error — data loading	red	A loader could not load its data.	Check the loader and its source.
Output incomplete	red	An Output Range did not write its results.	Open that Output Range. Pressing Update again will not fix it.
Run-time error — broken reference	red	Excel cannot find what a reference points at.	Correct the reference.
Recalculation needed	amber	Something has changed since the last Update — an input, the model itself, or the workbook was reopened — so the figures cannot be relied on until you update.	Press Update.
Calculated, with errors	amber	The model calculated, but some cells could not be calculated and hold an error. The panel says how many, and in which series.	Read the lines beneath it.
Calculated — a source loaded nothing	amber	The model calculated, but a source you declared loaded nothing — a renamed column heading, say — so what depends on it was calculated over empty cells.	Check the loader and its source.
Up to date, warning(s) present	amber	The figures are current, and there is something worth reading beneath — a question about an Input Range, for example.	Read the warnings.
Up to date	green	The figures on the sheet are the model's current answer.	Nothing.

In a cell, DS.INFO reports the same states.

The right-click menu

Right-click an ordinary cell and Excel's menu carries an Axmo group with three items:

Create Input Range — opens the Input Ranges editor with a new range set to the cells you selected.
Create Output Range — opens the Output Ranges editor with a new range anchored at the top-left cell you selected.
Navigate — opens the panel on its Active Sheet tab, where the ranges your selection belongs to are highlighted.

Inside an Excel table the Axmo group is not there. Excel shows its own table menu there, and add-ins cannot add to it. Everything in the group can be reached another way: right-click an ordinary cell next to the table, or use the Axmo Model ribbon tab. To read a table into the model, open Input Ranges, click +Add, select the table's cells and click Use selection — Axmo puts the table's name in the reference, so the range follows the table as it grows.

The two editors that matter

Dimensions defines what the model is organised by — Country, Year, Product, Scenario — including the hierarchies that let countries roll up into regions.

Data Series defines each quantity in the model: whether you supply it or Axmo works it out, which dimensions it varies over, how it aggregates, and — for a calculated series — its formula. This is where the modelling language is visible, and it is the editor worth opening first on any model you didn't build.

Where the numbers come from and go

Axmo doesn't store your data. It reads inputs from worksheet ranges you nominate and writes results back into ranges you choose, as ordinary Excel values. Whatever you already use to get data into Excel keeps working exactly as it does.

The model itself lives inside the workbook file. There is no account, no sign-in, and no copy on anyone's server.

Two functions

Axmo adds exactly two functions you can type into a cell — DS.DATA and DS.INFO. Everything else is driven from the ribbon and the panel. They're covered in the worksheet functions reference.