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

Course intent

This mid-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:

• Demonstrate proficiency in absolute and relative cell addressing.
• Construct pivot tables and charts to visually summarise and analyse data.
• Use validation techniques to minimise data entry errors.
• Apply advanced conditional formatting using the "If Formula Is" feature.
• Use Hlookup and Vlookup functions to cross-reference data.
• Manage multiple workbooks proficiently.
• Use templates and various file formats to streamline Excel workflow.
• Use advanced formatting and page layout options.
• Use advanced functions and addressing techniques, with a focus on the IF function.
• Enhance chart and graph formatting.
• 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 already possess a basic understanding of Microsoft Excel and want to elevate their skills to an intermediate 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:

• Microsoft Spreadsheets Excel – Stage 3
• 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

You can't currently enrol online for this course, so please call 0300 200 1044 to express your interest or to make an enquiry for further information.

Find another course

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