Not sure where to start? Our combo foundation is perfect for SME’S
Our brochures are a one-stop-shop for all your HR, Health & Safety and Training needs.
Want to talk to us? Get in touch!
Join our 1-day virtual Excel class and take your spreadsheet skills to the next level with expert-led training designed for real-world data challenges. Whether you’re working in finance, marketing, operations, or administration, Excel is a critical tool that can unlock powerful insights and streamline your workflow. This course is built for professionals who already know the basics and are ready to dig deeper into data analysis, automation, and professional-level reporting. You’ll go beyond formulas and charts—learning how to build dashboards, automate calculations,
and work confidently with large, complex datasets. The training is highly practical, hands-on, and focused on real business scenarios, so you can apply your new skills immediately.
This course is designed for professionals who already have a basic understanding of Excel and want to advance their skills. It’s perfect for anyone who works with data regularly and wants to improve efficiency, reporting, and decision-making using advanced Excel tools.
Topics Covered
Introduction to Excel for Data Analysis
• Excel interface overview
• Workbooks and worksheets
• Data organisation basics
Basic Excel Functions and Formulas
• SUM, AVERAGE, COUNT, and other core functions
• Absolute vs. relative cell references
• Basic error checking in formulas
Data Import, LOOKUP, and Cleaning
• Importing data from external sources
• Using VLOOKUP and HLOOKUP
• Removing duplicates and handling missing data
Sorting, Formatting, and Filtering Data
• Sorting techniques
• Applying conditional formatting
• Using filters to isolate data
Data Visualisation with Charts and Graphs
• Creating bar, line, and pie charts
• Customising chart elements (titles, labels, legends)
• Choosing the right chart for your data
PivotTables and PivotCharts
• Building PivotTables
• Creating PivotCharts
• Grouping, slicers, and calculated fields
Dashboard Building and Design
• Principles of effective dashboard design
• Integrating charts, PivotTables, and slicers
• Enhancing interactivity and dynamic reporting
Operating System: Windows 7+ or Mac OSX (10.8+)
Browser: A modern and up to date web browser
Video: Up to date video drivers
Memory: 1 Gb+ RAM
Additional Software: Flash Player (latest version)
Download Speed: Broadband (3Mb+)
Course details:
* The course duration is based on the amount of video content shown and is rounded off. It does not account in any way for loading time or thinking time on the questions
