Chapter 5 Essential spreadsheet skills for accounting

Chapter 5 Essential spreadsheet skills for accounting

1. 5.1 What is a spreadsheet

   • A spreadsheet is an electronic file consisting of a number of worksheets.
   • The most widely used spreadsheet is Microsoft Excel

2. 5.2 What are the typical features of worksheets within a spreadsheet

   • A typical worksheet includes 3 data types
     • Labels - Column and row headings
     • Numerical values - Numbers in a cell
     • Formulae - Calculation in a cell

3. 5.3 How can spreadsheet skills be developed?

   • There are plenty of help guides within excel and Microsoft website
   • Spreadsheets can be used for: Budgets, Tax Returns, Producing own bank statements, Checking credit card statements, checking mortgage statements, phone and address lists and many more

4. 5.4 What are the limitations of using spreadsheets?

   • You can display the formulae by pressing ctrl + `