Excel 2016 for the workplace (intermediate)

Course Dates: 16/09/20 - 14/10/20
Time: 18:00 - 21:00
Location: Online

Do you want to learn some of Excel 2016's more sophisticated functions? Are you an adminstrator or manager who needs to use it for more complex tasks? With realistic workplace assignments, we will cover creating statistical information using functions such as average, minimum and maximum; creating calculations based on a condition; counting entries IF they meet a condition; using more advanced formatting; effective filtering; and creating basic pivot tables to present data in an easy-to-read way.

This course is FREE if one of the following applies:

a) You are employed and earn less than £20,962. 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. OR

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

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 020 7831 7831 for more information.

This course will be delivered online. For more information please see our guide to online learning.


What is the course about?

This course will help you make the most of Excel 2016 so that many of your complex workday tasks become easier. You will learn how to use tables and charts to present information more effectively as well as manipulate data using calculations, conditional formatting and effectively filtering. You will gradually learn how to work with quite complex data including working across multiple sheets and linking to other Microsoft programs.

This is a live online course. For more information please see our guide to online learning.
We will contact you with joining instructions before your course starts.

What will we cover?

• Enhancing the appearance of the data by changing the font, colour, size and style.
• Working with columns and rows.
• Entering fields into headers and footers.
• Using calculation such as Sum, Average, Maximum and Count.
• Working on multiple sheets simultaneously.
• Conditional formatting
• Basic pivot tables
• Effective filtering
• Linking across sheets and other applications such as word processing.
• Using spreadsheets in Word documents.
• Creating charts, graphs and enhancing their appearance.
• Using and creating templates.

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

•use Excel effectively in the workplace to handle complex data and create fully functioning spreadsheets
• Perform calculations in Excel using formulae and functions.
• Perform calculations across different worksheets
• Apply a condition to a cell or a group of cells that will change automatically once a criteria is met.
• Explain the different types of charts and which charts best represent the data used
• Summarise data using the basic pivot table commands
• Perform filtering by various headings and text and number filtering tools
• Convert numerical data into charts/graphs and make changes to them.
• Link a charts to a report in a Word document.
• Enhance the appearance of worksheets using various formatting features
• Prepare the document for print by selecting the orientation and a range of cells to be printed.

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

This is an intermediate level course. You should be confident in the basic functions of Excel and in general computer use. The course is specifically aimed at people who need to use spreadsheets in the workplace though it will also help you in everyday home use. You can call our administrator on 0207 492 2511 for more advice about your suitability for the course.

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

This is a practical hands-on course taught online using Zoom or Google Meet. You will perform tasks in class, which reflect office and work-based activities and be encouraged to practise as much as possible. You will receive regular handouts and information via Google classroom. You will have lots of opportunities to ask questions and address areas you need help in.
You will need your own computer with MS Office, a good internet connection and a microphone, the use of a webcam for video is optional. Mac users can also take part in this course but will have to adapt to some keyboard and tab differences. Your tutor will discuss the concepts of all the tools used and will demonstrate their uses. The course will challenge you to become more independent in your learning and less dependent on your notes/hand –outs and work colleagues.

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

There are no additional costs for doing this course. It is possible to sit an ECDL Excel Level 2 exam at the end of this course but you will need to pay for the BCS registration, the test and a proportion of the cost of an invigilator. To check if you are ready to take the exam an online sample test is also available at a small cost. Please ask your tutor for more information if you are interested I taking the exam.

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

TThere are many courses you can do at the same time or after this course. These include:
• Excel 2016 for the workplace - advanced
• Word 2016 for the workplace - intermediate or advanced
• Access 2016: essentials
• An introduction to PowerPoint 2016 in a Day
•Outlook 2016 for the workplace: managing your emails, tasks and priorities (intermediate)
•Outlook 2016 for the workplace: integrating Outlook, Excel and Word (advanced)
•IT skills for the Office: introduction or intermediate
• ECDL Level 2 or 3 (with a qualification - assessment needed)
You may also be interested in our How to be an Administrator series.

We have many other digital skills courses. Your tutor will advise you on the best course. For courses with an exam, you will need to complete a pre-course assessment. You can also call our administrator on 0207 492 2511 or email: universal.skills@citylit.ac.uk to arrange an assessment with one of our course advisors.


Customer Reviews 2 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.

Excel isn’t that difficult if you have an idea of what you’d like it to do for you. Simple processes are effective.
Course Rating
Review by Anonymous / (Posted on 22/10/2018)
The tutor is very knowledgeable. The content of the course is great. Totally worth attending.
Course Rating
Review by anonymous / (Posted on 04/10/2018)

Book your place

Course Code: CEX01

Wed, eve, 16 Sep - 14 Oct '20

Duration: 5 sessions (over 5 weeks)

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

Or call to enrol: 020 7831 7831

Any questions? skills@citylit.ac.uk
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 Help Center. You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.