What’s in an Excel Template?
An Excel template contains one or more worksheets with pre‑defined formulas and cell formatting. With templates, you don’t need to know how to do the maths, or even how to write formulas—these are already integrated into the spreadsheet. Parts of the worksheets can be locked to ensure that data is only entered into the right cells.
While Excel can produce prints of specified areas of the worksheets, it cannot produce editable reports. We can add program code to enable Excel to send data to a Word document, producing a fully editable, formatted document.
Excel Template Case Study
Spreadsheets needn’t be complex to be useful. We built a simple one for a design studio in Auckland. They owned the lease of a floor in a large building and shared the space with several other companies. The spreadsheet we built them divided up the costs of various items – including the use of the coffee machine – on the basis of the floor area occupied by each company. New companies could be added, and old ones removed, just by adding and removing columns from the spreadsheet.