Microsoft Excel Intermediate (6 hours)

✔ 0.6 CEUs

✔ Virtual Instructor-Led Training

✔ Master the Basics. Unlock the Power of Excel

IACET Accredited

VideoTile Learning Ltd is accredited by the International Accreditors for Continuing Education and Training (IACET) and offers IACET CEUs for its learning events that comply with the ANSI/IACET Continuing Education and Training Standard. IACET is recognized internationally as a standard development organization and accrediting body that promotes quality of continuing education and training.

View Our IACET Accreditation

Course Overview

Microsoft Excel is one of the most in-demand skills across industries — from finance and marketing to logistics and research. But if you’re only using it for simple spreadsheets, you’re missing out on its full potential.

This Intermediate Microsoft Excel course is a live, 1-day virtual training session designed to bridge the gap between basic Excel use and powerful, real-world application. You’ll move beyond data entry and dive into the tools that unlock true efficiency, clarity, and analytical impact.

Whether you’re managing reports, working with large datasets, or simply looking to become faster and smarter in your day-to-day tasks, this hands-on session will guide you through the formulas, functions, and features that professionals use every day.

Delivered online and led by an experienced instructor, this practical workshop combines expert guidance with real-time exercises — giving you the skills and confidence to work smarter with data right away.

By the end of the session, you’ll be able to:

Confidently work with complex spreadsheets and organise your data efficiently
Write accurate, error-free formulas using core Excel functions
Import and connect data from multiple sources for deeper analysis
Clean and prepare raw data to make it analysis-ready
Use lookup functions to link and reference related data sets
Format, filter, and highlight data to uncover insights quickly
Create dynamic charts that clearly communicate your message

Benefits & Real-Life Skills

By taking this course, you will gain practical, real-world Excel skills that improve your productivity, confidence, and professional value — all in just one focused day of training.

Work more efficiently by automating everyday tasks with formulas and functions
Import, clean, and prepare data from external sources for accurate analysis
Use VLOOKUP and HLOOKUP to connect and reference data without manual effort
Create visually clear and professional charts to present your data with impact
Apply filters, sorting, and conditional formatting to uncover insights quickly
Troubleshoot and fix common formula errors like a pro
Save time with smart spreadsheet structuring and formula techniques
Build reports and dashboards that others can understand, use, and trust
Improve decision-making by analysing data confidently and clearly

Target Audience

This course is ideal for professionals who use Excel regularly and want to advance their data analysis skills, small business owners seeking to streamline reporting, and students or recent graduates looking to boost their CVs with practical Excel knowledge. It’s also a great fit for job seekers preparing for roles in finance, administration, marketing, or data entry. If you already know the basics of Excel and are ready to take the next step, this intermediate course is designed for you.

Key Benefits

Master Excel’s Interface and Data Structure

Understand how to confidently navigate Excel, manage workbooks and worksheets, and organise your data for effective analysis.

Build Reliable Formulas and Functions

Learn to create essential formulas using functions like SUM, AVERAGE, and COUNT, and understand how to apply absolute and relative cell references correctly.

Import and Integrate External Data

Bring data into Excel from various sources and start working with it right away — a key skill for business, research, and reporting tasks.

Use LOOKUP Functions with Confidence

Gain hands-on experience with VLOOKUP and HLOOKUP to search, reference, and connect information across tables and sheets.

Clean and Prepare Data for Analysis

Learn practical techniques to clean your data — remove duplicates, fill missing values, and format datasets for accurate results.

Sort, Filter, and Format for Insight

Use Excel’s sorting, filtering, and conditional formatting tools to isolate patterns, highlight key metrics, and make your data easier to interpret.

Visualise Data with Impactful Charts

Create and customise bar, line, and pie charts. Learn how to choose the right chart type to tell a clear, compelling data story.

Topics Covered

Introduction to Excel for Data Analysis

Overview of Excel’s interface and essential tools
Working with workbooks, worksheets, and structured data

Essential Functions and Formulas

Core formulas: SUM, AVERAGE, COUNT, and more
Understanding and using absolute vs. relative cell references
Basic error-checking in formulas

Importing and Cleaning Data

Importing data from external files (CSV, text, databases)
Removing duplicates and handling missing values
Preparing raw data for analysis

LOOKUP Functions

Using VLOOKUP and HLOOKUP for referencing data
Common use cases and troubleshooting LOOKUP errors

Sorting, Filtering, and Conditional Formatting

Organising and sorting datasets
Applying filters to isolate key data
Highlighting insights using conditional formatting rules

Data Visualisation with Charts and Graphs

Creating bar, line, and pie charts
Customising chart elements (titles, labels, legends)
Choosing the right chart type for your data

Who Should Attend

This course is perfect for anyone who already knows the basics of Excel and is ready to take their skills to the next level.

You should attend if you are:

A professional who works with data and wants to save time and reduce errors
A business owner or entrepreneur looking to better manage finances, reporting, or inventory
A student or recent graduate wanting to boost your resume with practical Excel skills
An admin, coordinator, or support staff member seeking to streamline day-to-day tasks
A job seeker preparing for roles that require data handling or reporting
A beginner-level Excel user who’s comfortable with the basics but wants to grow

Whether you’re in finance, operations, marketing, HR, education, or any other field — if you use Excel, this course will help you use it better.

Free Demo

Please call toll free on 1800 656 0215 or complete the form below to arrange a free demo of our LMS and Online Training Courses.

Schedule Appointment

CEU Requirements

To receive CEU credit for taking this course, you must:

Pass the knowledge checkpoints and complete the entire course.

Upon successful completion, you will receive a certificate showing the CEUs earned.

Online training screenshots (click to view)

Mobile friendly

Unlimited usage & bulk credit

API: Use your own LMS

VideoTile obtains appropriate regulatory approvals and accreditations for all its video-based online training courses to US federal law standards

Distributor case studies

SME Advisor

HR Consultants

Embark Learning

Health and Social Care Sector

TSS Facilities

Facilities Management

Westminster Compliance

Health and Safety Consultants

Alfa

Training Provider

Darcy

Recruitment

Some of Our Users

Customer Reviews

SME Advisor Case Study

HR and Health and Safety Consultancy

From its base in Barnham, Sussex, SME Advisor provides a range of HR and Health and Safety consultancy services to small-to-medium-sized businesses, across a variety of sectors. Their highly experienced team works with businesses with between five and 100 employees where it isn't viable to employ a full-time HR or Health and Safety professional.

SME Advisor used classroom training, where necessary, to support its consultancy work, but found it usually wasn’t cost-effective for the company or its clients.

They looked for eLearning solutions, but couldn’t find what they were looking for.

‘We’d actually given up the search,’ says Director, Paul Beard, ‘then along came VideoTile!’

‘VideoTile courses feature a virtual classroom where a tutor talks to you, supported by animated information. This combination ticked the box which is why we think it’s a winning formula. Now, around 90% of our training revenue comes through VideoTile courses as opposed to traditional methods.’

‘We introduce VideoTile courses to existing and new clients to allow them to achieve compliance. SME Advisor proposals will also include suggested VideoTile topics and a couple of free courses for them to try out.’

‘VideoTile support is very good. Recently, they populated our website with their new courses, which was really helpful.’

‘Videotile was the missing link for us. Before, potential clients would have to go to another provider for some of their training requirements. Now, we have closed that gap by offering VideoTile solutions.’

‘After an 18 months search, we eventually found VideoTile - exactly what we were looking for!’

Paul Beard

Director, SME Advisor

Embark Learning Case Study

Health and Social Care Sector

On 1 August 2019, Fairway Training launched its exciting new trading style and brand ‘Embark Learning’.

Embark Learning will build on the outstanding performance and national reputation of Fairway Training, which has delivered almost a quarter of a million courses and qualifications across the nation, supplying training to many of the top 20 care providers in the UK. Clients include organisations such as national healthcare support services, the UK’s largest housing associations, city councils and small independent care homes.

‘Embark Learning is now focussing on the evolution of the ‘Learner Journey’,’ says Operations Director, Alex O’Neill.

‘It’s a concept which can be applied to people from the ‘hard to reach and unemployed’ to those looking for career change or career development.’

‘Embark Learning will offer sector-based work academies to the entire health and social care sector, through blended learning packages.’

‘Blended Learning packages are a mix of short-course, classroom-based training, online VideoTile training and Virtual Reality learning – the next big step in technological training development.’

‘This approach ensures clients receive maximum value from their training budget by tapping into the vast portfolio of online learning that Videotile and Embark have made available.’

‘Employees can complete VideoTile courses off-site, at their own convenience, freeing up precious time to concentrate on bespoke, classroom training.’

‘The working relationship with Videotile remains strong, open and communicative, with great ideas being shared across both businesses.’

‘All of this feeds seamlessly in to the formal qualification pathway. Allowing people to progress though apprenticeships at Level 2 and 3, as well as diplomas in health and social care – the journey really does become endless.’

‘Our relationship with Videotile continues to be one of creativity, openness and innovation. VideoTile online training gives learners and clients greater options and possibilities with regard to compliance and CPD. It’s a win-win for all concerned and means training really is seen as a huge positive in all organisations.’

Alex O'Neill

Operations Director, Embark Learning

TSS Facilities Case Study

Facilities Management

TSS Facilities Ltd is a facilities management company based in Hove, Sussex. The company has been trading for 47 years and covers four main disciplines - commercial heating, electrical, air conditioning and legionella. TSS Facilities holds maintenance contracts with universities, schools, hotels and local authorities.

‘Before we started using VideoTile,’ says Water Treatment Director, Steve Tugwell, ‘we offered classroom-based training which was only suitable for large groups. But, now, training is available as a mix of classroom training and VideoTile courses for everyone - right down to single people at separate or remote sites. Typically, we train premises managers, people in charge of office blocks, caretakers, and client staff who handle maintenance and need to be aware of other issues that could affect their role.’

The company also uses classroom training and VideoTile e-learning courses to explain large complex reports, such as Legionella risk assessments.

‘We encourage new clients to use VideoTile, as it goes hand-in-hand with our classroom training,’ explains Steve. ‘It’s particularly useful for clients who have to undertake risk assessments. Without the training, they often think of it as a chore. They never really buy into it. But after taking the VideoTile course, they understand the importance of the assessments, and instantly become more positive and enthusiastic.’

‘When there’s new legislation, technical enhancements or other industry changes, we use VideoTile to train our own staff. We also offer VideoTile courses to our admin people to give them a better idea of what the company does.’

We sell lots of VideoTile course to clients and they really do work. We would definitely recommend VideoTile. It’s a neat, cost-effective professional solution.

Steve Tugwell

Water Treatment Director, TSS Facilities Ltd

Westminster Compliance Case Study

Health and Safety and Fire Safety

Westminster Compliance LLP is a Hertfordshire-based consultancy dealing with all aspects of Health and Safety and Fire Safety, offering comprehensive systems to help organisations manage their compliance with legislation.

Its systems include basic and industry specific, face-to-face training.

However, there are times when certain client staff can’t make the face-to-face sessions, because they’re working away. That’s when VideoTile courses are used because they can be worked through remotely.

They’re also used where, for example, just a few people need specific training and the cost of arranging face-to-face sessions can't be justified, or because without the training, the client can’t work on a particular site or can’t get some specific accreditation.

‘We’ve been using VideoTile for three years,’ says, Senior Partner, Nigel Lack. ‘Their courses are professionally produced, up-to-date and economically viable and increasingly, our clients approach us to buy access to stand-alone online courses.’

‘I think VideoTile also makes Westminster Compliance look more professional, and we don't have to signpost clients to other companies to get things done.’

‘With VideoTile online courses we can offer the widest possible range of Health and Safety training with so many different options for clients. I think it’s been very good for us.’

‘Our existing clients like the VideoTile courses and we always feature them when presenting to new clients.’

‘Working with the VideoTile guys is really great. They know their stuff, are very friendly and always there when you need them.’

Nigel Lack

Senior Partner, Westminster Compliance

Alfa Consultancy Case Study

Health and Safety training and consultancy

Alfa Consultancy, based in Richmond, North Yorkshire offers nation-wide Health and Safety training and consultancy to clients across the UK.

The Alfa Consultancy team has over 20 years’ experience as Occupation Safety and Heath professionals in a variety of sectors, including major construction, building maintenance, retail construction, H&S consultancy, H&S training, behavioural safety training and leadership development.

‘We offer a mix of training to meet individual client needs,’ says Safety Consultant and Trainer, Neil Sheehan. ‘This could include face-to-face training at the client’s premises or in our own classrooms, plus highly cost-effective VideoTile online training.’

‘The VideoTile courses can be part of a package where they’re used before classroom training to cover the basics, so we hit the road running, or afterwards as a refresher courses to maintain awareness. VideoTile courses are increasingly being purchased as ‘stand-alone’ training which avoids pulling workers away from their productive jobs, and they can be completed at the workers own pace, in their own time.’

‘One of our recent clients is Asda, and they’ve bought 2000 licenses to give them access to all the VideoTile courses.’

‘VideoTile courses are an excellent way of showing clients how effective online training can be. Take the construction sector. They’re practical people and the culture tends to prefer face-to-face. But when I show them Videotile examples and explain how online training can be integrated with classroom sessions, the mindset changes. In fact, everybody I’ve shown VideoTile to thinks it’s a great tool.’

‘I think VideoTile is unique - the best sort of online training going. Because here are people teaching you. I’m a great believer in it, and when I introduce it to clients and trainees, they love it.’

Neil Sheehan,

Safety Consultant and Trainer, Alfa Consultancy

Darcy Associates Case Study

Construction Sector Recruitment Agency

Founded in 2015, Darcy Associates is a successful recruitment agency specialising in the construction sector. With offices in Bristol, London, Birmingham and Liverpool, the company has worked with over 200 clients in the last three years, registering 35,000 candidates and filling 97 per cent of vacancies.

‘Training and upskilling candidates, either before, or within a fortnight of them starting their new job, has always been a key part of the Darcy Associates philosophy,’ says Director, Nathan Ferris.

‘VideoTile has been a perfect fit for our approach. As well as using the courses to upskill our candidates, we sell them direct to our clients to train their own internal staff.’

‘VideoTile courses are high quality, cost-effective, easy to understand and the standard of training is excellent. They provide the right information and are very engaging, which is not what we see from most online training companies. Feedback from trainees and clients is always very positive.’

‘We use all their construction course videos, particularly Asbestos Awareness, Working at Height and Abrasive Wheels. And as everything is handled by VideoTile, its hassle-free for us.

Finally, their support is exceptionally good, although, to be honest, we haven't had any hitches. The software works as it’s meant to with no technical flaws. Communication is good from everybody at VideoTile.

‘VideoTile online training brings big benefits to our candidates and keeps our clients coming back for more. It’s an online platform that works without a hitch! It’s very good for the efficiency of our operation and my personal peace of mind!’

Nathan Ferris

Director, Darcy Associates