Skip to main content
    Improving Skills in Excel
    for Improving your Skills in Microsoft Excel

    Tickets from £25

    Closed

    Improving your Skills in Microsoft Excel

    DateMonday, 17 June, 9:45am

    LocationOnline live streamed

    PriceTickets from £25

    About this event

    Course Code: 23524

    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' heading.

    Venue

    Online live streamed

    Further information

    *Except for the registration fee, this course is fully funded by The Education & Skills Funding Agency for adults who meet the following criteria:

    • A Hertfordshire Resident
    • Aged 19 years or older on 1st September 2023
    • UK National and lived in the UK for the last 3 years or EEA National with settled/pre-settled status and lived in the UK/EEA for the last 3 years

    There are some exceptions to this, for example the Homes for Ukraine scheme. If you do not meet the above criteria, please contact us on 01992 556194 or email step2skills@Hertfordshire.gov.uk

    Can’t see what you’re after?

    Map of Hertfordshire

    We work with partner organisations across Hertfordshire to offer workshops and courses so do visit their websites/social media.

    Are you currently out of work?

    Man in orange hi vis

    We offer a range of employment support services to help support you back into work. Read more and apply.

    Want to hear when new courses and workshops land?

    Update me logo

    Subscribe to our monthly emails and follow us on Facebook, X, LinkedIn or Instagram.