Unit 27 Spreadsheet modeling

Because spreadsheets are so versatile, they are used regularly to provide information that will help managers to make decisions. Spreadsheets allow users to store, manipulate and analyse data and then provide ways to present that data to others.

They can be automated to make them more efficient and easy to use. In this unit you will create a spreadsheet model to meet a particular business need.

You will be assessed through coursework which could be in the form of: • Presentations • Spreadsheet models • Witness statements of an observed practical exercise • Web pages • Leaflets • Reports • Screenshots.