Upcoming Sessions

June 23, 2025 14:30:00 BST


July 30, 2025 14:30:00 BST

Course Overview

1-day virtual instructor-led training

Led by an experienced instructor, this hands-on workshop combines expert guidance with real-time exercises, giving you the skills and confidence to work more efficiently with data right away. You'll master essential formulas and functions, confidently use VLOOKUP and HLOOKUP, clean and prepare data like a pro, and create impactful charts to tell compelling data stories.

What will you learn

Skills and knowledge you will gain after completing this course:

  • Confidently navigate Excel's interface and manage workbooks and worksheets for effective analysis.

  • Build reliable formulas using functions like SUM, AVERAGE, and COUNT, and apply absolute and relative cell references.

  • Import and integrate external data from various sources.

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

  • Learn practical techniques to clean your data, remove duplicates, and handle missing values.

  • Use Excel's sorting, filtering, and conditional formatting tools to isolate patterns and highlight key metrics.

  • Create and customise impactful bar, line, and pie charts to tell compelling data stories.

  • Troubleshoot and fix common formula errors.

Course curriculum

    1. Introduction to Excel for Data Analysis

    1. Essential Functions and Formulas

    1. Importing and Cleaning Data

    1. LOOKUP Functions

    1. Sorting, Filtering, and Conditional Formatting

    1. Data Visualisation with Charts and Graphs

About this course

  • £150.00
  • 6 lessons
  • Virtual Instructor-led Training
  • 6 hours

Course FAQ

  • My job involves working with large datasets. Will this course teach me how to manage them more effectively?

    Absolutely! This course teaches you practical techniques to import data from various external sources, clean messy datasets by removing duplicates and handling missing values, and effectively sort and filter large amounts of information. These skills are crucial for managing and making sense of large datasets.

  • I struggle with creating clear reports and presenting data effectively. Will this course address that?

    Yes! A key component of this course is learning to use conditional formatting to highlight insights and creating visually impactful charts (bar, line, pie) that effectively tell your data story. You'll gain the skills to build reports and dashboards that others can understand, use, and trust.

  • Is VLOOKUP really that important, and will I learn how to use it confidently?

    VLOOKUP (and HLOOKUP) are essential functions that allow you to search, reference, and connect information across different tables and sheets without manual effort, saving significant time. This course provides hands-on experience and common use cases, ensuring you gain confidence in applying these powerful functions.

  • How quickly can I expect to see improvements in my work after taking this course?

    Our 1-day, live, instructor-led format is designed for immediate impact. With practical examples and real-time exercises, you'll gain skills and confidence to work smarter with data right away. Many participants report significant improvements in efficiency and productivity almost instantly by automating everyday tasks and better managing their data.

Want to explore more?

Others are doing these courses

View more products