Course Overview

Take your Excel skills beyond the basics. In this Intermediate course, you’ll learn advanced functions, analytical tools, and efficient spreadsheet practices—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.