Excel For Professional Users

About this course

The course develops Excel skills for workplace use, while also accommodating learners studying for personal development. Participants work with pivot tables for summarising and reporting, apply VLOOKUP, HLOOKUP and IF functions, and use absolute and relative cell references. The course also addresses some common Excel issues and includes a typical job interview exercise using the software. Tutor feedback is provided during the course.

What you'll learn

• Create pivot tables to summarise and report information
• Apply VLOOKUP, HLOOKUP and IF functions
• Use absolute and relative cell references
• Resolve some common Excel issues
• Complete a typical job interview Excel exercise

Is this course right for you?

This Improver-level course is intended for learners who are already familiar with Excel fundamentals, formulae and functions. It is aimed particularly at people developing Excel skills for work, although personal-development learners can also take part.

• Previous familiarity with Excel fundamentals, formulae and functions is stated as an entry requirement
• Suitable for work-related or personal-development aims
• Learners new to digital skills are advised to complete an Essential Digital Skills Programme first

Before you go

• A desktop or laptop is provided in the classroom; learners may bring their own laptop if they wish
• Bring a notebook and pen for note-taking