Improving your Skills in Microsoft Excel

Course Code: 25852

Teacher: This course is being taught by Paul.

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:

1. Freeze/unfreeze rows and columns. Split a worksheet.
2. Filter data. Apply multiple filters. Filter data with search. Apply advanced text/number/data filter. Use find and replace.
3. Create a conditional formatting. Sorting data. Custom sorting. Add multiple levels to any sort.
4. Group and ungroup worksheets. Make a drop downs. Modify tables. Functions and formulas.
5. 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 Excel and computer skills.

How you will be assessed?

Question & 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.

What learners need to bring/supply

Learners must have access to Microsoft Excel and a laptop or desktop with good wifi and a webcam.

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.

The next steps…

During this course we will talk to you about your next steps which could include attending other courses/workshops such as Introduction to MS Word, Improve your skills in MS Word, Introduction to MS PowerPoint and Improve Your Skills in MS PowerPoint. Please click here to see the full range of courses we offer.

We have programmes that can support you with your next steps in skills and employment. For further information please see our information, advice and guidance page.

NOTE: This course is for Hertfordshire Residents Only - *With the exception of the registration fee, this course/workshop is fully funded by The Education & Skills Funding Agency for adults who meet a set criteria - please see further details under the 'Further Information' heading.