Improving your Skills in Microsoft Excel

Course Code: 23520

What is this course about?

This is an intermediate level course which will help you improve your skills and give you confidence in using Microsoft Excel. The main areas that we will cover during this course are:

• Freeze/unfreeze rows and columns, split a worksheet
• Filter data - apply multiple filters, filter data with search, apply advanced text/number/data filter and using find and replace
• Create a conditional formatting, sorting data, custom sorting, add multiple levels to any sort
• Group and ungroup worksheets, make a drop downs, modify tables, functions and formulas
• Create more complex formulas, relative and absolute cell references

Who is this course for?

This course for people who are competent in using basic Excel and want to learn more features and functions to further improve their skills.

Entry Requirements to do this course:

A basic level of conversational and written English is needed to complete this course. You must also have a basic level of Microsoft Excel skills.

How you will be assessed?

Question and Answer, discussions, and observations. You will also be asked to complete Learner reflections.

How much studying will I need to do outside of the lesson?

It will be advised to use the skills learnt in the classes and practise on your own Excel documents and devices.

After this course you might like to… attend the workshops and courses in Introduction to Microsoft Word, Improve your skills in Microsoft Word, Introduction to Microsoft PowerPoint and Improve Your Skills in Microsoft PowerPoint.

What learners need to bring/supply

Learners must have access to Microsoft office and laptop/desktop for online delivery.

What happens after I book this course?

There are two steps to complete before studying with us and booking on here is the first step. Your next step will be to enrol on your chosen course following the instructions attached to your order confirmation email.

NOTE: This course is for Hertfordshire Residents Only - With the exception of the registration fee, this course is fully funded by The Education & Skills Funding Agency for adults who meet a set *criteria - please refer to the 'Further Information' tab.