Excel 2016: essentials

Course Dates: 24/09/19 - 22/10/19
Time: 10:00 - 13:00
Location: KS - Keeley Street

Do you need to use Excel for work, in the office, or to keep track of your finances? Learn the key parts of creating spreadsheets: entering text and numbers, formulae, formatting, modifying and linking sheets and creating charts. Knowledge required: basic computer skills and the ability to use a mouse and keyboard.

This course is FREE if one of the following applies:

a) You are employed and earn less than £20,572.50 . You need to have lived in the UK or EU for the last 3 years and be a citizen of the UK or a country within the EU. You may also be eligible for this funding in other circumstances. When you come for assessment or enrolment, bring a pay slip dated within 3 months of the course start date, or a current employment contract that shows your gross salary.


b) You are either on Jobseekers' Allowance or Employment & Support Allowance (WRAG). Please bring proof of income to your assessment or enrolment.


c) You receive other state benefits (including Universal Credit), earn less than £338 a month (individual claims) or £541 a month (household claims) and are doing the course to become employed or move into more sustainable employment.

Call 222-66-889-99 for more information.


What is the course about?

This course will give you the skills and confidence in Excel 2016 to create a well-presented spreadsheet. You will learn important terms, concepts and functions of the Excel spreadsheets and be astonished at how powerful and useful Excel is. We will focus on how to create spreadsheet s which are formatted with the right fonts, colour, text size and style including headers and footers. You will learn about entering data and using formulae and functions to make calculations. You will practise creating charts and graphs and enhancing their appearance so that data can be presented in an easy to read way. We will also practise using and creating templates, printing to maintain formatting and managing your files.

What will we cover?

• identifying key features of a worksheet.
• entering data.
• enhancing the appearance of the data by changing the font, colour, size and style.
• entering and deleting a column, row or sheet.
• adding and deleting headers and footers.
• using common formulae
• using key functions used in calculation such as Sum, Average, Maximum and Count.
• working on multiple sheets simultaneously.
• creating charts, graphs and enhancing their appearance.
• using and creating templates.
• print preparation
• managing your files and maintaining security.

What will I achieve?
By the end of this course you should be able to...

•use all the main essential features of excel to create attractive and accurate documents such as budget sheets
• identify the key features of a excel window
• create, open and save files
• enter and edit text and data by inserting, deleting, moving, copying and pasting
• create and edit spreadsheets so they have appropriate formatting including use of headers and footers and change the page layout and orientation
• enhance the appearance of worksheets by changing font type, font size, font colour, bold, italics and alignment
• perform calculations in Excel using formulae and functions
• convert numerical data into charts/graphs and make changes to them
• using spell check and grammar check so your documents are accurate
• print documents including headers and footers
• organise your files so they are easy to find and secure.

What level is the course and do I need any particular skills?

This is a course suitable for beginners including those who have just started to use Excel. If you are a complete beginner, you might like to try our Introduction to Excel course. You will need to have basic mouse and keyboard skills and a degree of confidence on a computer.

How will I be taught, and will there be any work outside the class?

Each student has their own computer and you will be encouraged to practice as much as possible. An interactive whiteboard will help make demonstrations easy to understand. It will be a relaxed learning environment and step by step learning will help you become more skilled. You will have lots of opportunities to ask questions and address areas you need help in.

Are there any other costs? Is there anything I need to bring?

You will need to bring a pen and paper and a folder for your notes.

When I've finished, what course can I do next?

There are many courses you can do at the same time or after this course. We have a range of courses on using Microsoft Office 2016 programs in the workplace and at home - from beginner to advanced - including Excel for the workplace (intermediate). We also run an IT Skills for the Office programme at introductory or intermediate level. Other suitable courses include:
• Touch-tying and keyboard skills
• Making sense of Windows 10
• Pathway to ECDL level 1 and 2 / Pathway to ECDL Level 3
• ECDL Level 1, 2 or 2 (assessment needed). You might also be interested in our How to be an Administrator series. For less confident learners some of our Becoming Confident series will be helpful:
a) Becoming confident on your computer
b) Becoming confident on the Internet: setting up, searching, security, safety
c) Becoming confident with emails and internet communication
c) Becoming confident on Facebook, Twitter and Instagram: for complete beginners
d) Becoming confident in file management on your PC
e) Becoming confident with mobile data: managing and syncing your files across your laptop, smartphone and tablet
f) Becoming confident on the cloud: a new way of sharing and collaborating

Your tutor will advise you on the right course for you.
For all courses with an exam, you will need to complete an assessment. Call our administrator on 0207 492 2511 to arrange an assessment with one of our course advisors or email [email protected]

General information and advice on courses at Build is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00.
See the course guide for term dates and further details


Customer Reviews 1 item(s)

Write a review

Reviews below are by students who have attended this course, regardless of the course teacher. Please be aware you may not be booking onto a course with the same teacher.

Definitely go for it. The tutor brought a dry subject to life and I not only learnt a lot but enjoyed it too.
Course Rating
Review by Anonymous / (Posted on 29/10/2018)
Tutor Biographies
We’re sorry. We don’t have a bio ready for the tutor of this class at the moment, but we’re working on it! Watch this space.

Book your place

Course Code: CEX12

Please choose a course date 

Tue, day, 24 Sep - 22 Oct '19

Duration: 5 sessions (over 5 weeks)

Full fee: £179.00
Senior fee: £143.00
Concession: £90.00

Or call to enrol: 222-66-889-99

Download form & post

Any questions? [email protected]
or call 020 7492 2511

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online . You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.