Spreadsheets

Spreadsheets can be used in the finance department to produce graphs and charts of financial information.

The formulae function within the spreadsheet can be used to carry out instant calculations accurately. Formulae will also amend calculations automatically when the spreadsheet is updated.

‘What if’ scenarios can be carried out using spreadsheets set up with IF statements and appropriate formulae.

Information held within a spreadsheet can be easily secured using a password.

Time can be saved in the finance department by using spreadsheet templates for financial statements and spreadsheets can be easily amended or edited.

A monthly cash flow forecast spreadsheet
Using spreadsheets saves the finance department time with automated calculations and templates.