You will learn how to create and amend Excel spreadsheets to store and manipulate data which can be used for both personal and business purposes.
The purpose of this course is to introduce you to the most important features of Microsoft Excel, to reinforce what you already know about how to use a computer and to build your confidence. By the end of the course you should be able to produce and edit spread-sheets for home and office use.
You will learn:
how to build spread sheets
about the most frequently used features in Excel, including:
multiply and divide
‘drag and repeat’
formula and dates
sorting and ordering
saving files, opening existing files, printing
A workbook is provided containing exercises to give hands-on experience and general information. This is yours to keep.
You should have attended the Starting off with Windows course or have a basic knowledge of computers including the mouse and keyboard.
Four weeks x2 hours
Lesson 1 Introduction to Excel
Admin and Computer Ergonomics
Files – saving file, sheets
Tour of the desktop
Lesson 2 Introduction to + / * - %
$ facility and use of formula
Lesson 3 Personal Budget Cash Flow forecast
Tidy up layout / colours and printing
Simple database and using Mail merge Word letter
Lesson 4 Personal Budget
Summary Budget Notes
Production of charts and graphs
Use in Word documents
Simple Database and using Mail Merge with Word documents labels