Course Overview

Take your Excel skills beyond the basics and start working like a true data pro. This intermediate course focuses on productivity shortcuts, advanced formulas, data analysis tools, and automation techniques, giving you the skills to work faster, cleaner, and smarter.

Perfect for professionals who already use Excel but want to make it a real career asset.

So you can work smarter, not harder, across real-world business scenarios.

  • Master VLOOKUP, INDEX/MATCH, and array formulas

  • Create dynamic dashboards with PivotTables and charts

  • Automate repetitive tasks using macros and conditional formatting

  • Improve accuracy and speed with error checks and data validation

  • Boost productivity with shortcuts, templates, and best practices

Learning Structure

  • Delivery Modes

    Fully remote (live online, on-demand, or classroom-based)

  • Duration

    1 day to 3 days per course (or 40–60+ hrs self-paced per exam)

  • Experience Level

    Beginner to intermediate (no prerequisites required)

Modules

  • Advanced Formulas & Functions
  • VLOOKUP, INDEX/MATCH, and array formulas
  • PivotTables & Data Summaries
  • Data Validation & Cleaning
  • Conditional Formatting & Dynamic Charts
  • Automating with Macros
  • Creating Professional Dashboards

Prerequisite

  • Age

    16+ (Recommended 18+)

  • Technical Skills

    No prior knowledge required. Basic computer literacy recommended

  • Devices

    Laptop/PC with internet access

  • Motivation

    Suitable for career starters, professionals, and technical leaders alike

FAQs

Anyone with basic Excel knowledge who wants to level up their skills for professional use.

Yes — you’ll need Microsoft Excel 2019, 2021, or Microsoft 365 installed on your device.

Yes — you’ll receive a Step8Up completion certificate.

Available in both live online classes and self-paced formats.

We aim to consult within 24 hours of enquiry, then placing your team on a course within 7 days subject to our discretion.