To IT Level 2 Spreadsheets (IT for Life) >>>
The course shows you how to create and edit spreadsheets and how to use a workbook to analyse a wide range of numerical data.
Spreadsheets help you store, manage and analyse numbers. Want to keep track of your household budget or plan a holiday? Need to get to the bottom of sales figures at work?
Spreadsheets let you get to grips with a whole range of jobs quickly and easily! A simple, jargon-free introduction explains what a spreadsheet is and the sort of tasks it can help you with.
You’ll be given a step-by-step guide to creating a new spreadsheet, entering text and numbers and saving the data.
You’ll learn how to use formulas to add, subtract, multiply and divide numbers, how to analyse the information in your spreadsheet and how to print off different pieces of information from your spreadsheet.
A series of handy printouts and practice exercises throughout the course will ensure you have understood all the learning.
Duration
10 – 40 hours working at your own pace
Progression
Taking this course can count towards part of the following qualifications:
- ITQ
- OCR New CLAiT
See also IT Level 2 Spreadsheets
Course Content
On completion of this course you will be able to:
- Open, navigate and close Microsoft Excel
- Create, layout and save a simple spreadsheet
- Enter and format numbers and text in a spreadsheet
- Apply your new skill
- Copy, insert and delete data
- Print a spreadsheet to complete the final course activity
- Create formulas
- Copy, insert and delete data
- Print a spreadsheet
Project
This is a Learndirect Course, and is completed online: at home or at one of our centres.
See www.learndirect.co.uk for more details.
