In this tutorial, you will learn how to structure your workbook for web use, and the importance of named ranges in SpreadsheetWEB applications. The workbook preparation mainly involves restructuring your workbook and assigning named ranges to inputs, outputs, as well as field you want to capture in the database.

Excel is a desktop tool and creating a web application from a spreadsheet means that some features will work differently on the web version. Subsequently, splitting up the user interface into smaller sections, across multiple pages typically works better on the web.

You don’t have to assign named ranges to calculated fields, as all calculations will be automatically detected by the system, and run whenever the web application triggers calculations. This also means that you can choose to display certain field to the end users, and let the calculations run in the background.