Microsoft Spreadsheets Excel - Stage 3

Course intent

Join our comprehensive and interactive course designed to elevate your Microsoft Excel skills from intermediate to advanced. You will explore advanced functionalities, techniques, and productivity boosters, enhancing your Excel proficiency. From mastering Pivot Tables to safeguarding data and optimising workflows, this course equips you with expertise for complex data analysis and automation. By the end, you'll be an Excel power user, capable of performing intricate analysis, automating tasks, and unlocking new possibilities in data management. Embark on this transformative journey towards Excel mastery and unleash your full potential.

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

How to Apply

There are three ways to apply on this course. You can:

• complete the form on our website;
• call us on 0300 200 1044, 9am to 3pm Monday to Friday; or
• visit one of our centres.

We'll evaluate your skills and provide a course offer, which you must accept to secure your place.

What will we cover?

• 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

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

For courses of more than one session, you will find you make the most progress if you attend every taught lesson and complete any self-directed study opportunities provided.

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

This course is designed for individuals who have intermediate-level proficiency in Microsoft Excel and are looking to improve their skills to an advanced level. It is suitable for professionals, students, analysts, data scientists, and anyone who regularly works with Excel and wants to enhance their data analysis, manipulation, and automation capabilities. Whether you need to analyse complex data sets, streamline workflows, or become more proficient in Excel for your job or academic pursuits, this course will provide the necessary knowledge and techniques for you to excel.

If you are completely new to computers, please look at our “Basic Digital Skills” courses first.

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?

• A notebook and pen.

Handouts and exercises will be provided.

What can I do when I finish the course?

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

• Microsoft – Word-processing – Word
• Microsoft - Organising with Outlook
• Microsoft - The Cloud - Office 365
• Microsoft - Presentations - PowerPoint
• Digital Skills for Work
• 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. Surrey Adult Learning values and supports equality and diversity 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!