Upcoming Sessions

June 26,2025 09:00:00 BST


July 24, 2025 14:30:00 BST


August 8, 2025 14:30:00 BST

Course Overview

1-day virtual instructor-led training

Move beyond everyday formulas and charts, learning how to build interactive dashboards, automate calculations, and confidently manage large, complex datasets. Discover how to create powerful PivotTables and PivotCharts, design visually appealing dashboards with slicers, and streamline repetitive tasks to boost your productivity and impress stakeholders

What will you learn

Skills and knowledge you will gain after completing this course:

  • Master Excel's interface and navigation for improved workflow and efficiency.

  • Create and troubleshoot advanced formulas, including SUM, IF, VLOOKUP, and HLOOKUP.

  • Import and effectively clean external data by removing duplicates and handling blanks.

  • Organise and analyse large datasets using sorting, filtering, and conditional formatting.

  • Understand absolute vs. relative cell references for dynamic, reusable formulas.

  • Build and customise powerful PivotTables and PivotCharts, including grouping, slicers, and calculated fields.

  • Design interactive dashboards that are visually appealing and easy to use.

  • Present data with clear visualisations, choosing the right charts for impact.

Course curriculum

    1. Introduction to Excel for Data Analysis

    1. Basic Excel Functions and Formulas

    1. Data Import, LOOKUP, and Cleaning

    1. Sorting, Formatting, and Filtering Data

    1. Data Visualisation with Charts and Graphs

    1. PivotTables and PivotCharts

About this course

  • £200.00
  • 7 lessons
  • Virtual Instructor-led Training
  • 6 hours

Course FAQ

  • My job requires me to create a lot of reports. Will this course help me make them more professional and impactful?

    Absolutely. A core focus of this course is on designing clean, interactive dashboards and visualisations that present your data clearly and impress stakeholders. You'll learn to choose the right charts and combine them with PivotTables and slicers to tell a compelling data story.

  • I spend a lot of time on repetitive tasks in Excel. Can this course help me automate them?

    Yes! A key benefit of this course is learning to automate data processes, reuse formulas, and build templates to significantly reduce manual work and boost your productivity. You'll gain skills to streamline your workflow and save valuable time.

  • I often deal with messy data from various sources. Will this course teach me how to clean and manage it better?

    Yes, you'll gain the ability to import data from external sources and clean it effectively by removing duplicates, handling blanks, and preparing it for accurate analysis. This ensures your data is reliable for all your reporting and decision-making.

  • How will mastering advanced Excel skills impact my career trajectory or promotion potential?

    Advanced Excel skills are highly valued across all industries, from finance to HR to marketing. Adding these skills to your toolkit will significantly boost your resume, enhance your promotion potential, and even open doors to freelance opportunities by demonstrating your ability to make data-driven decisions and create professional reports.

  • I'm comfortable with basic Excel. How will this advanced course truly enhance my current skills?

Want to explore more?

Others are doing these courses

View more products