Microsoft Spreadsheets Excel - Stage 3 (online) [HPT]

Course intent

This advanced-level course is designed to increase your understanding and expertise in Microsoft Excel. By the end of the course, participants will have the knowledge and skills to effectively analyse, manipulate, and present data using Excel's advanced features.

If you use/have used a different spreadsheet programme, the skills learned here are easily transferrable.

What will I learn?

You will:

Create Pivot Tables and Pivot Charts and use the Pivot Table Slicer.

Naming Ranges.

Develop advanced skills with Formulas and Functions

Use =Lookup (using =VLookup and =HLookup).

Look at other useful Advanced Functions (including =Today and =Concatenate).

Import Files

Freeze Panes, Hiding/Un-hiding Rows/Columns and Workbooks

Link Data within and between Worksheets and Workbooks.

Protect and Unprotect Cells and Worksheets

Safeguarding, Prevent and British Values

Who is this course for? Is there anything I need to know before joining?

This course is for

Anyone with good computer, mouse and keyboard skills

individuals who have intermediate-level proficiency in Microsoft Excel and are looking to improve their skills to an advanced level.

If you are completely new to computers, please look at our Digital Skills & Confidence courses

To fully participate in this course, you will need:

An email address

A reliable internet connection

A computer/laptop /tablet with a fully updated browser

A working microphone and webcam.

Once enrolled on this course you will receive detailed instructions for taking part online

As our courses are taught in English, please contact us if you have any concerns about your level of English.

What do I need to bring to the first class? Will there be any extra costs?

To fully participate in this course, you will need:

Access to a computer/laptop/tablet with a reliable internet connection

A working microphone, and webcam

If you struggle to read printed text on a screen, you may find it beneficial to have access to a printer to make your own hard copies of resources.

What can I do when I finish the course?

You may like to progress onto another Surrey Adult learning course, such as:

Computer Programming & Introduction to Python Coding

Microsoft Word-processing

Microsoft Office 365 & The Cloud

Digital Skills & Confidence courses

Essential Digital Skills (EDSQ) Accredited courses

Or your tutor can direct you to ‘Next steps’ section, on our web site, if you wish to do something else

Additional information

We welcome learners with additional needs and disabilities. When you enrol, please let us know if you would like to discuss your extra support needs with a member of the Supported Learning Team who will then contact you as soon as possible. If you are enrolling within 10 days of the course start date, we may not be able to contact you before your first class.

We value and support equality, diversity and inclusion by promoting fairness and respect at all times.

How to enrol

Our courses are for adult learners aged 19 or over. If you are under 19, please call 0300 200 1044.

Find another course

If this isn't what you're looking for, then we've got plenty more courses to offer!