Excel in a Day - Advanced Print this page

Dates: 22/02/19 - 22/02/19
Days: Friday 09:30 - 14:30
Sessions: 1
Centre: Sutton - Sutton
Course Code: S50002C06NV
Fees: Standard - £40.00
Concessionary - £40.00

Course Information

Introductory info

An opportunity to establish knowledge of common functions and develop further level 2 skills and knowledge.

What are the overall aims of the course?

This course will show you how to work with data that is provided, to format content to a more advanced level, to use still more complex formulae and reinforce those already known and appreciate why these work as they do to be confident in their future use.

Further graphs will be covered in this course to extend knowledge and skills of this important aspect of data work within the work on Pivot Tables. You will also be exposed to database work on larger than normal files.

What will I learn on the course?

Perform advanced formatting and conditional formatting
Appreciate the purpose of Lookups
Use more complex functions and formulae
Name and edit data and work with large quantities of data using Pivot Tables and Charts

Your tutor will give you more information at the start of the course

Are there any entry requirements?

To benefit from this course participants must have a good knowledge of the topics at Intermediate level of Excel.

Also, an understanding of the order of mathematical operations is important but will be covered.

Do I need to attend a course approval interview/assessment before I can join this course?
NO but the note above is very important - this is a challenging level which requires intermediate learning to be instilled.

How will I be taught?

Classroom based practical work following demonstration
Flexible Learning follows on through the materials handed out on the course as homework

How will my progress be checked?

Informal assessment in class
Tutor and peer observation

Does the course have any features I should be aware of?

As a computer based course a good knowledge of the computer is a paramount.

The progress of the whole class can be hindered without this knowledge.

What do I need to bring with me to class?

A notepad and pen would be useful to make additional notes on top of those provided. An encrypted memory stick would be useful to take away your work for further practice but not vital as files will be emailed after the course. Email address is important.

How do I find out if I can get some support for my learning?

Additional Learning Support (ALS) may be made available for learners who, at the time of assessment and/or enrolment, declare a difficulty or disability that may affect their learning. Our service can support learners in English, maths, who are dyslexic, deaf or hearing impaired or who have evidence of other medical issues impacting on learning.

Learners can also find information about financial and child care support from the Customer Enquiry Centre or at www.suttoncollege.ac.uk/enrol/help-with-fees

All learners are entitled to use our iCLICK - Computer & Digital Learning Centre. For more information please see www.suttoncollege.ac.uk/college/iclick or contact iclick@suttoncollege.ac.uk

You will be issued with a Sutton College e-mail address, which will give you access to Sutton College’s Virtual Learning Environment, called VERA.

There is free guest Wi-Fi available in the College

Can I receive advice and guidance about further education opportunities and careers?

To find out more about what may be available to you please contact our Advice Team. See www.suttoncollege.ac.uk/college/advice-centre

What can I do after the course has finished?

Further IT courses with Sutton College leading to nationally recognised qualifications.
Excel Masterclass

What should I do if I have any questions?

If you can’t find the answer to your query on the College website, please contact the Customer Services Team on 020 8289 4700 or complete an online query at www.suttoncollege.ac.uk/contact-us

For course content queries, please contact curriculum@suttoncollege.ac.uk


If you cannot find the course you are looking for, please contact our Customer Enquiry Centre on 020 8289 4700 or click below to search.

Please click here to search
Sutton College, St Nicholas Way, Surrey, SM1 1EA | 020 8289 4700 | enrol@suttoncollege.ac.uk

Copyright 2018 - Sutton College. All rights reserved | Sitemap | Privacy Policy | Cookies
Sutton College