Advanced Search

Between the Sheets - Business Studies

In this section we look at the use of spreadsheets in Business Studies. There is help and advice on using spreadsheets and a variety of downloadable spreadsheets on various topics.

Spreadsheet help and advice

The following help and support on using spreadsheets and the downloadable spreadsheets below is available:

• Student introduction - student notes to help with the downloadable spreadsheets
• Teacher introduction - teacher notes to help with the downloadable spreadsheets
• Guide to downloadable spreadsheets - a general guide to the downloadable spreadsheets - how they are laid out and how to use them
• Using spreadsheets - a general introduction to spreadsheets and how to use them in business, economics and accounting
• Glossary of all the terms that appear in the downloadable spreadsheets in this section

Nb: Some of these spreadsheets use macros, these may be disabled by your copy of Microsoft Excel. If the spreadsheets don't appear to work follow the instructions here.

Downloadable spreadsheets

These spreadsheets are in Microsoft Excel format and require Microsoft Excel 97 or above. The following spreadsheets are available:

1. Introduction to balance sheet and income statement
2. Markups and margins
3. Gearing
4. Depreciation
5. Cost analysis
6. Cost volume profit analysis
7. Budgeting
8. Elasticity of demand
9. Profit maximisation