Introduction
Course overview
Administrative professionals use spreadsheets every day to track budgets, schedules, inventories, contacts, requests and performance data. Many still rely on manual copying, repeated typing and basic formulas, which takes time and creates errors.
This Advanced Excel for Administrative Professionals training course builds the practical spreadsheet skills that make office work faster and more reliable. Participants learn to structure data properly, use lookup, logical, text and date functions, create pivot tables and charts, apply data validation and conditional formatting, and build simple dashboards and tracking tools.
The course also introduces automation features such as Power Query and basic macros, together with good practices for protecting, sharing and documenting workbooks so that colleagues can use them safely.
Global Learning for Operational Leaders