HOME | CHECKOUT | ABOUT | FAQ | CONTACT US |
 
Welcome Guest [create an account] or log-in:
email
password

Chapter 9 Using Spreadsheets for Management Tasks

DOI: 10.23912/978-1-908999-97-9-2514

ISBN: 978-1-908999-97-9

Published: 30 June 2014

Component type: chapter

Published in: Essential Financial Techniques for Hospitality Managers 2edn

Parent DOI: 10.23912/978-1-908999-97-9-2479

10.23912/978-1-908999-97-9-2514

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.

Sample content

Click here to download PDF

Contributors

  • Dr Cathy Burgess, Oxford Brookes University (Author)

For the source title:

  • Dr Cathy Burgess, Oxford Brookes University (Author)

Cite as

Burgess, 2014

Burgess, D.C. (2014) "Chapter 9 Using Spreadsheets for Management Tasks" In: Burgess, D.C. (ed) . Oxford: Goodfellow Publishers http://dx.doi.org/10.23912/978-1-908999-97-9-2514

Available

Chapter 9 Using Spreadsheets for Management Tasks [Details]Price: £4.99*Licences / Downloadable file

Published in Essential Financial Techniques for Hospitality Managers 2edn

Chapter 9 Using Spreadsheets for Management Tasks [Details]Price: £4.99*Licences / Downloadable file
Paperback format [Details] Available as an inspection copyPrice: £37.99Copies / Delivery by post
Terms and conditions of purchase | Privacy policy