Chapter 9 Using Spreadsheets for Management Tasks

Abstract

In this chapter we will see how using spreadsheets can help you with many of the control tasks that we have discussed in the different chapters. We’ll also see how you can use graphs and charts (hand-drawn and by spreadsheet) to help in decision-making and presenting results.
We will look at some of the simple techniques that can make spreadsheets easier to use on a frequent basis and at some of the shortcuts you can take. Incorporating some basic design features can help with ongoing usage, and with enabling others to use spreadsheets that you have designed. The use of charts and how they can help with presenting complex information in a simpler way will also be considered.
It’s assumed that you have a basic knowledge of spreadsheets. If some of this is boring because you’re at a higher level of competence, then please move on.
There’s a refresher exercise to revise skills and perhaps practise some new ones, and some suggestions about using spreadsheets for personal tasks.
By the end of this chapter, therefore, you should be able to:
- Comprehend the basic principles of spreadsheet design
- Practise a range of techniques to improve speed and efficiency
- Comprehend the variety of areas where spreadsheets can be used
- Draw a chart to scale by hand
- Create a chart using a spreadsheet.