Advanced Excel for Administrative Professionals (AS-029) Training Course

Advanced Excel for Administrative Professionals

Administrative professionals use spreadsheets every day to track budgets, schedules, inventories, contacts, requests and performance data. Many still rely on manual…

5 daysClassroom or online

49Upcoming dates

12Cities

£2,750Fees from

Course overview

Introduction

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.

Course Objectives

By the end of this training course, participants will be able to:

Structure data in tables that are easy to sort, filter and analyse
Use lookup, logical, text and date functions to automate calculations
Clean and combine data from different sources
Summarise information using pivot tables and pivot charts
Apply data validation and conditional formatting to reduce errors
Build trackers and simple dashboards for administrative reporting
Automate repetitive tasks using Power Query and recorded macros
Protect, share and document workbooks professionally

Target Audience

This training course is suitable for a wide range of professionals, including:

Administrative assistants and officers
Executive assistants and secretaries
Office managers and coordinators
HR, procurement and finance administrators
Project and programme support staff
Data entry and records staff
Anyone who uses spreadsheets regularly for office work

Training Methodology

The course is fully hands-on. Participants work on their own laptops through guided exercises based on realistic administrative tasks such as leave tracking, budget monitoring, event registration and supplier lists. Each technique is demonstrated, practised and then applied in a short challenge.

Target Competencies

Spreadsheet data management
Formula and function use
Data analysis with pivot tables
Dashboard and report building
Task automation
Data accuracy and control

Course outline

1Day One: Working Efficiently with Data

Spreadsheet Good Practice: Layout, naming and consistency
Excel Tables: Structured data, automatic expansion and formatting
Sorting and Advanced Filtering Techniques
Keyboard Shortcuts and Productivity Features
Data Validation: Drop-down lists and input rules
Conditional Formatting: Highlighting deadlines and exceptions
Practical Exercise: Building a structured request tracker

2Day Two: Essential Functions

Logical Functions: IF, IFS, AND and OR
Lookup Functions: XLOOKUP, INDEX and MATCH
Counting and Summing with Conditions: COUNTIFS and SUMIFS
Text Functions: Cleaning names, codes and addresses
Date and Time Functions: Deadlines, working days and durations
Error Handling: Finding and preventing formula errors
Practical Exercise: Automating a leave and absence tracker

3Day Three: Analysing and Presenting Information

Pivot Tables: Summarising large lists quickly
Grouping, Filtering and Slicers in Pivot Tables
Pivot Charts and Standard Charts: Choosing the right visual
Formatting Reports for Managers
Printing and Page Layout for Professional Documents
Building a One-Page Dashboard
Workshop: Creating an office budget monitoring dashboard

4Day Four: Cleaning and Combining Data

Removing Duplicates and Correcting Inconsistent Entries
Splitting and Combining Columns
Introduction to Power Query: Importing and transforming data
Combining Data from Multiple Files or Sheets
Refreshing Reports Automatically When Source Data Changes
Checking Data Accuracy: Reconciliations and controls
Practical Exercise: Consolidating supplier lists from several departments

5Day Five: Automation, Sharing and Protection

Recording Simple Macros for Repetitive Tasks
Running and Editing Recorded Macros Safely
Protecting Sheets and Workbooks: Locking cells and permissions
Collaboration: Shared workbooks, comments and version control
Documenting Workbooks for Other Users
Personal Productivity Plan: Applying skills at work
Final Challenge: Building a complete administrative tracking tool

Frequently asked questions

How long is the Advanced Excel for Administrative Professionals course?

The course runs over 5 days of classroom training, usually Monday to Friday.

When is the next Advanced Excel for Administrative Professionals course?

The next public date is 7 - 11 Dec 2026 in Barcelona. There are 49 upcoming dates in total.

Where is this course held?

Upcoming sessions run in Barcelona, Frankfurt, London, Amsterdam, Cape Town, Dubai, Geneva, Istanbul, Madrid, Munich, Rome, Vienna.

Can I take Advanced Excel for Administrative Professionals online?

Yes. Every date can also be joined live online in a virtual classroom with the trainer, for £1,280 per participant. Choose "Live online" in the dates table when you register.

How much does the course cost?

Fees start from £2,750 per delegate, depending on the city. Fees include tuition and course materials.

Do participants receive a certificate?

Yes. Delegates who complete the course receive a London Leadership Management Innovation certificate of completion.

Can this course be delivered in-house for our team?

Yes. LLMI can tailor and deliver this course privately for your organisation at your premises or in one of our training cities.

Course information last updated 14 November 2026.

Advanced Excel for Administrative Professionals

Course overview

Introduction

Course Objectives

Target Audience

Training Methodology

Target Competencies

Course outline

Dates and fees

Frequently asked questions

More Administration and Secretarial courses

Achieving Administrative Excellence

Administrative Performance Review and Office Audit

AI Tools for Administrative Professionals

Training a team?