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:
| 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 | Reads your data and recalculates the model — recompiling first in the unusual case that the model is not already compiled. |
| 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. |
| 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
The panel does not open by itself. Add-ins installed from the Office Store can't open their own task pane — a Microsoft behaviour, not an Axmo one — so 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 — whether what's on the sheet matches what the model says it should be;
- actions — Update, which recomputes what needs recomputing;
- the last operation — when the model last recalculated, and how long it took, broken down into reading inputs and running the engine.
Active Sheet lists the model objects present on whatever worksheet you're looking at, which is 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.
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.