Course aims
This course sets out essential concepts and skills for understanding spreadsheets and using a spreadsheet application to produce accurate work.
Learning objectives
Successful candidates will be able to:
- Work with spreadsheets and save them in different file formats.
- Choose built-in options, such as the Help function, to enhance productivity.
- Enter data into cells and use good practice in creating lists; select, sort, copy, move and delete data.
- Edit rows and columns in a worksheet; copy, move, delete and rename worksheets.
- Create mathematical and logical formulas using standard spreadsheet functions, use good practice in formula creation and recognise error values in formulas.
- Format numbers and text in a spreadsheet.
- Choose, create and format charts to communicate information meaningfully.
- Adjust spreadsheet page settings, and check and correct content before printing.
Who it is for
- Employees and managers at all levels, and ICT technicians
- Job seekers, graduates and students
Duration and certification
| Training hours | 24 |
| Sessions | 2 hours a day, three times a week (Sat, Mon & Wed or Sun, Tue & Thu) |
| Certificate | Certificate of Completion in Microsoft Excel, after the written and practical examination |