You will increase your confidence in using Microsoft Excel so that you can produce a wide range of spreadsheets, whether for personal or business purposes.
The purpose of this course is to revise and reinforce the knowledge and experience you already have, and to introduce you to additional features of Microsoft Excel. By the end of the course you should be able to produce and edit attractive, professional spreadsheets suitable for most occasions and uses.
You will revise:
When to use the $ sign in formulae
When to use brackets in formulae
You will learn about:
Using more than one worksheet within a spreadsheet
Making one cell conditional on another cell
Handling and avoiding errors
You will also sample the wide range of uses that spreadsheets can be used for.
A workbook is provided containing exercises to give hands-on experience and general information. This is yours to keep.
You should have attended the Excel course or have a basic working knowledge of Microsoft Excel (i.e. the topics covered in the Excel course).
Five weeks x2 hours
Lesson 1 Time and Using $ sign and brackets in formulae
Rows, columns and Autofit
$ sign and brackets in formulae
Lesson 2 Sorting and using more than one Worksheet