358 Google Reviews 01501 750900
Download course directory

Sibbald Training

Microsoft Excel - Intermediate - Virtual Learning

Microsoft Excel - Intermediate is a tutor led online course designed to teach you how to use Excel effectively, whether you are brand new or need to refresh your skills.

6 hours
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.

Course Aims

At the end of this course you will be able to work more efficiently by automating everyday tasks with formulas and functions, use VLOOKUP and HLOOKUP to connect and reference data without manual effort, create visually clear and professional charts to present your data with impact, conditional formatting to uncover insights quickly, save time with smart spreadsheet structuring and formula techniques, build reports and dashboards that others can understand.

Course Content

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)

Additional Information

All Virtual Classes will be conducted over Zoom.

System requirements
• An internet connection – broadband wired or wireless (3G or 4G/LTE)
• Speakers and a microphone – built-in, USB plug-in, or wireless Bluetooth
• A webcam or HD webcam - built-in, USB plug-in
• macOS X with macOS X (10.11) or later
• Windows 11
• Windows 10 Note: Devices running Windows 10 must run Windows 10 Home, Pro, or Enterprise. S Mode is not supported.

Note: On Windows devices, Zoom utilizes WebView2 and Chromium Embedded Framework (CEF) for certain features. If not available, these are downloaded automatically by Zoom, but admins should ensure these are whitelisted on managed devices.