Intermediate Microsoft Excel - Live Online Course (with expert trainer)

This live online course, delivered over three sessions, takes you beyond the basics to master powerful Excel tools and techniques.

Live, interactive and hands on - this is real-time, instructor-led training where you can interact, ask questions and get personal guidance throughout each session.

You will learn to present, manipulate, and analyse data more effectively, enhancing workplace efficiency and productivity. You will also develop valuable analytical and reporting techniques that will benefit you personally, as well as current and future employers.

Course Dates:

• Session 1 - Wednesday 3rd December, 10am-12pm (GMT)
• Session 2 - Wednesday 10th December, 10am-12pm (GMT)
• Session 3 - Wednesday 17th December, 10am-12pm (GMT)

Course Structure:

Format: Online using MS Teams, trainer-led

Duration: 3 sessions each lasting 2 hours (total of 6 hours). A 30 minute Excel Q&A on course content will also be offered immediately after each session finishes.

Includes practice files, interactive exercises and recordings of your sessions.

Dec offer: £125 per delegate (Standard price £250)

Why Choose This Live Course:

• Get direct support from a live trainer
• Small group - personalised attention
• Interactive learning - not just watching videos
• Ask questions and share your screen for real-time help
• Expert trainer

Course Overview*:

A.Formatting and Selection Techniques:

• Home menu formatting
• Conditional formatting
• Format painter and merge tools
• Number formatting
• Time Saving Shortcuts

B.Data Management:

• Cell referencing (Relative, Absolute, Mixed)
• Sorting and filtering data
• Flashfill
• Text concatenation

C.Working with Functions & Formulas:

• SUM, AVERAGE, MIN, MAX
• COUNT, COUNTA
• SUMIFS, COUNTIFS
• IF and IFS
• DATE and TIME functions

D.Also:

• Introduction to pivot tables
• Charts and data visualisation
• Page setup and printing
• Productivity tricks and shortcuts

*Content may vary depending on specific group level

Prerequisites:

• A computer with Microsoft Excel installed and a stable internet connection for live online sessions.
• Computer literacy: Learners should be comfortable with general computer operations. This includes navigating the operating system, launching applications, opening and saving files from emails and using Microsoft Teams.

In Excel, learners should understand the following:

• Creating and saving workbooks, and navigating worksheets
• Basic Data Entry Skills: Learners must be comfortable at entering, editing, and deleting data within worksheets. This includes knowledge of cell selection, copying, pasting, cutting, and using undo/redo features.
• Formatting Basics: Participants should be able to apply basic formatting to cells, columns, and rows. This encompasses changing font styles, sizes, and colours; adjusting cell alignment; applying borders and shading;
• Basic Formula Knowledge: Users should understand how to create and edit simple maths calculations in Excel. Familiarity with basic functions such as SUM is beneficial but not essential.