Introduction ​

Collecting and Calculating the Travel Expenditure is an area of corporate budgeting where MODLR can assist easily. The following tutorial demonstrates how easy it is to collect information from users who are geographically distributed without using Spreadsheets and Email. The aim is to provide the user with an understanding of cube linking functions (vlookup type formulae) and data validation (drop-down lists).

In this tutorial, we will be re-developing a basic Excel Spreadsheet used to collect Travel Plans from various business units in MODLR to present the various benefits of using the MODLR Solution. You can download a copy of the example spreadsheet here.