Key course information
Computing and Information Technology
Apply for this course
This course is suitable for learners who have a basic knowledge of using a computer or laptop, with little or no experience of Microsoft Excel. It is also suitable for those who have not used Excel in some time, or who are familiar with older versions of the software. As a minimum learners should be competent using a keyboard and number pad. This is a five week course comprising 2.5 hours per week.
What will I learn?
The aim of the course is to give learners the basic skills to enable them to use Excel to create a variety of spreadsheets and perform straightforward formulae and functions.
The following topics will be covered during the course: Learning basic Excel terms; Creating spreadsheets to add, takeaway, multiply and divide; Using AutoSum; Learning how to replicate formulae; Formatting text, borders and background; Creating bar, line and pie charts; Formatting chart titles, axis, legends, colours and styles; Work with large worksheets including naming ranges, and sorting and filtering; Work with multiples worksheets including moving and copying sheets, renaming tabs, and linking between worksheets and workbooks; Using Conditional Formatting and Sparklines; Embedding spreadsheet or chart in other Microsoft package - Word for example
The minimum entry requirement for this course is that learners should be competent using a keyboard and number pad.
Study, Assessment and Qualifications
Assessment is informal, based on your personal targets and the learning outcomes and will be undertaken regularly with you by the course lecturer.
Additional Costs and Information
You should bring with you a notebook and pen, or other method of taking notes. There will be handouts and workbooks provided during the course. Please note that the course is a combination of lecturer taught and individual learning using the workbook with lecturer support.
This course runs on one day per week at the Chippenham Campus and the dates are:
27.04.21-25.05.21 Tuesday 18:30-21:00
What Could I Do Next?
On completion of your course you may choose to progress onto these following courses
You could enrol on our Computing for Work and Leisure - Excel Intermediate to Advanced course to develop your skills.