Excel Add-In overview

The Datarails add-in brings your Datarails data into Excel, so you can build reports with live numbers, analyze what is behind them, and share the result. This article shows where everything is and links to the guide for each feature. With the add-in you can:

  • Build reports that update themselves. Pull live data into your own layouts with formulas, ready-made reports and data tables.
  • Understand any number. Drill from a total down to the transactions behind it without leaving the sheet.
  • Share with confidence. Send a clean copy to people outside Datarails, or publish a range to a dashboard that stays current.
  • Spend less time on upkeep. Let reports add new accounts and roll forecasts forward for you.

Open the add-in

  1. Install the add-in. See the installation guide.
  2. Open a workbook in Excel.
  3. On the Home tab of the Excel ribbon, click Datarails Add-in.

The add-in opens in a task pane on the right side of the Excel window. You can leave it open beside your sheet as you work, or close and reopen it whenever you like. 

How the task pane is organized

The task pane follows the way you work: stay in sync, build and analyze, then share and maintain.  The home screen has two tabs:

  1. Build & analyze: Your daily work: getting data into the sheet and drilling into it.
  2. Management: Sharing what you have built, and advanced setup such as dynamic ranges and planning.
new-home-tabs.png


Top bar: stay in sync with Datarails

The top bar is always visible, because these are the actions you need on every report: making sure you are looking at current data, saving your work back, and choosing which slice and period you see.

Control What it does More info
Connect Links a local Excel file to a Filebox in Datarails. Once the file is connected, the button becomes Submit. Connect, submit and refresh
Submit Sends your changes from Excel to Datarails. Connect, submit and refresh
Refresh Updates the workbook with the latest data from Datarails. Connect, submit and refresh
Filters Slices every Datarails object in the workbook by a field, such as department or entity. Filters
Set Date Sets the reference date (formerly Date Picker), which moves the reporting period of your reports. Connect, submit and refresh
Info (the "i" icon) Shows the Filebox name, its tags, and a banner if you are not on the latest version of the file. It appears once the file is connected.  
Additional options (the three dots) Opens Account, Settings, Help and troubleshooting tools.  

Errors and notifications: know when a number needs attention

The top of the home screen tells you about problems as they happen. Click a notification to go straight to where you can fix it.

new-home-notifications.png
Notification What it means
File errors The add-in found problems inside the file. Opens the File errors screen, which lists each one.
Integrations errors One of your integrations failed to sync.
Unmapped items Items in your data could not be mapped, so they are not included in your numbers. Opens a window where you can map them without leaving Excel.

Build & analyze: create reports and understand the numbers

This tab is where most of your time goes. Get data gives you three ways to bring live data into Excel, from a single cell to a whole report, and Drill down answers "what is in this number?" when someone asks.

overview-03.png
Feature What it does More info
Get data > Formulas Brings data into cells with Datarails formulas. Build formulas, edit their conditions and manage functions. Formulas
Get data > Report builder Builds a full report by dragging fields into rows and columns, then brings it into Excel as live formulas. Report builder
Get data > Data tables Adds a filtered extract of a Datarails table to your sheet. Data tables
Drill down Breaks a number down into the records behind it. Drill down

Management: share your work and keep it maintaining itself

Once a report is built, this tab helps you get it to the right people in the right form, and set it up so it keeps pace with your data and your planning cycle with little manual upkeep.

new-management-tab.png

Feature What it does More info
Export Shares a report as static values, as a PDF, or as one version per filter value. Export reports
Embedded ranges Publishes a range from your workbook to a Datarails dashboard (formerly Published Ranges). Embedded ranges
Advanced options > Dynamic range Keeps a report's rows in step with your data, adding new line items and filling formulas down. Dynamic ranges
Advanced options > Planning module Sets up planning periods and the default formula applied when a forecast rolls forward. Planning module

The right-click menu: common actions without the task pane

The actions you repeat most, refreshing and drilling down, are on Excel's right-click menu, so you can stay in the sheet. Items are enabled or greyed out depending on what you have selected.

On Excel for the web, open the task pane once before using the right-click menu, so the menu knows which items to enable.

Menu item What it does Enabled when
Refresh All Refreshes every Datarails formula and table in the workbook Always
Refresh Cell Refreshes the Datarails formula in the selected cell The cell contains a formula starting with DR., such as DR.GET
Refresh Table Refreshes the Datarails data table at your selection Your selection is inside a Datarails data table
Edit Table Opens the table editor for that data table Your selection is inside a Datarails data table
Open Detailed Records Lists the transactions behind the cell's value The cell is a numeric Datarails value
Drill Down - By Field Breaks the value down by a field you choose The cell is a numeric Datarails value
Drill Down - Add to Favorites Saves the current breakdown for reuse The sheet contains a drill-down pivot table

Ordinary Excel formulas such as =SUM(...), column headers, empty cells and other Excel tables do not enable the Datarails items.

Known limitation on Windows and Mac desktop: the Datarails menu does not appear when you right-click directly on a data table. Right-click a cell range that overlaps the table instead, or use the task pane. On Excel for the web the menu works on every cell.

Windows, Mac and the web

The add-in is the same on Windows desktop, Mac desktop and Excel for the web. A report built on one opens the same way on the others.

 




© Datarails Ltd. All rights reserved.

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request