大象传媒

Spreadsheets

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

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

鈥榃hat if鈥 scenarios can be carried out using spreadsheets set up with 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
Image caption,
Using spreadsheets saves the finance department time with automated calculations and templates.