Five-day professional programmes in 14 citiesClassroom, online and in-house info@aractech.com +31 85 7444446

Course AS-029

Advanced Excel for Administrative Professionals

Administrative professionals use spreadsheets every day to track budgets, schedules, inventories, contacts, requests and... The outline covers Working Efficiently with Data, Essential Functions, Analysing and Presenting...

  • 5 daysClassroom or online
  • 49Upcoming dates
  • 12Cities
  • €1,825Fees from

Choose your format and date

  • 5 days
  • 09:00–14:00
  • Certificate of attendance

Classroom sessions

  1. 7–11 Dec 2026

    Barcelona

    Next date
    €2,275 + VAT
    Register
  2. 14–18 Dec 2026

    Frankfurt

    €2,175 + VAT
    Register
  3. 21–25 Dec 2026

    London

    €2,915 + VAT
    Register
  4. 4–8 Jan 2027

    Amsterdam

    €3,215 + VAT
    Register
  5. 11–15 Jan 2027

    London

    €2,915 + VAT
    Register
  6. 18–22 Jan 2027

    Barcelona

    €2,275 + VAT
    Register
  7. 25–29 Jan 2027

    Frankfurt

    €2,175 + VAT
    Register
  8. 1–5 Feb 2027

    Frankfurt

    €2,175 + VAT
    Register
  9. 8–12 Feb 2027

    Cape Town

    Lowest fee
    €1,825 + VAT
    Register
  10. 15–19 Feb 2027

    London

    €2,915 + VAT
    Register
  11. 22–26 Feb 2027

    Barcelona

    €2,275 + VAT
    Register
  12. 1–5 Mar 2027

    Barcelona

    €2,275 + VAT
    Register
  13. 8–12 Mar 2027

    Frankfurt

    €2,175 + VAT
    Register
  14. 15–19 Mar 2027

    Dubai

    €2,845 + VAT
    Register
  15. 22–26 Mar 2027

    London

    €2,915 + VAT
    Register
  16. 5–9 Apr 2027

    London

    €2,915 + VAT
    Register
  17. 12–16 Apr 2027

    Barcelona

    €2,275 + VAT
    Register
  18. 19–23 Apr 2027

    Frankfurt

    €2,175 + VAT
    Register
  19. 26–30 Apr 2027

    Geneva

    €3,315 + VAT
    Register
  20. 3–7 May 2027

    Istanbul

    €2,825 + VAT
    Register
  21. 10–14 May 2027

    London

    €2,915 + VAT
    Register
  22. 17–21 May 2027

    Barcelona

    €2,275 + VAT
    Register
  23. 24–28 May 2027

    Frankfurt

    €2,175 + VAT
    Register
  24. 7–11 Jun 2027

    Barcelona

    €2,275 + VAT
    Register
  25. 14–18 Jun 2027

    Frankfurt

    €2,175 + VAT
    Register
  26. 21–25 Jun 2027

    London

    €2,915 + VAT
    Register
  27. 5–9 Jul 2027

    Barcelona

    €2,275 + VAT
    Register
  28. 12–16 Jul 2027

    Frankfurt

    €2,175 + VAT
    Register
  29. 19–23 Jul 2027

    Madrid

    €3,400 + VAT
    Register
  30. 26–30 Jul 2027

    London

    €2,915 + VAT
    Register
  31. 2–6 Aug 2027

    London

    €2,915 + VAT
    Register
  32. 9–13 Aug 2027

    Barcelona

    €2,275 + VAT
    Register
  33. 16–20 Aug 2027

    Frankfurt

    €2,175 + VAT
    Register
  34. 23–27 Aug 2027

    Munich

    €2,425 + VAT
    Register
  35. 6–10 Sep 2027

    Barcelona

    €2,275 + VAT
    Register
  36. 13–17 Sep 2027

    Frankfurt

    €2,175 + VAT
    Register
  37. 20–24 Sep 2027

    London

    €2,915 + VAT
    Register
  38. 4–8 Oct 2027

    Frankfurt

    €2,175 + VAT
    Register
  39. 11–15 Oct 2027

    Rome

    €2,830 + VAT
    Register
  40. 18–22 Oct 2027

    London

    €2,915 + VAT
    Register
  41. 25–29 Oct 2027

    Barcelona

    €2,275 + VAT
    Register
  42. 1–5 Nov 2027

    Barcelona

    €2,275 + VAT
    Register
  43. 8–12 Nov 2027

    Frankfurt

    €2,175 + VAT
    Register
  44. 15–19 Nov 2027

    Vienna

    €3,425 + VAT
    Register
  45. 22–26 Nov 2027

    London

    €2,915 + VAT
    Register
  46. 6–10 Dec 2027

    London

    €2,915 + VAT
    Register
  47. 13–17 Dec 2027

    Barcelona

    €2,275 + VAT
    Register
  48. 20–24 Dec 2027

    Frankfurt

    €2,175 + VAT
    Register
  49. 27–31 Dec 2027

    Amsterdam

    €3,215 + VAT
    Register

Online / Live sessions

  1. 7–11 Dec 2026

    Live virtual classroom

    Next date
    €1,625 + VAT
    Register
  2. 14–18 Dec 2026

    Live virtual classroom

    €1,625 + VAT
    Register
  3. 21–25 Dec 2026

    Live virtual classroom

    €1,625 + VAT
    Register
  4. 4–8 Jan 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  5. 11–15 Jan 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  6. 18–22 Jan 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  7. 25–29 Jan 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  8. 1–5 Feb 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  9. 8–12 Feb 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  10. 15–19 Feb 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  11. 22–26 Feb 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  12. 1–5 Mar 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  13. 8–12 Mar 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  14. 15–19 Mar 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  15. 22–26 Mar 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  16. 5–9 Apr 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  17. 12–16 Apr 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  18. 19–23 Apr 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  19. 26–30 Apr 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  20. 3–7 May 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  21. 10–14 May 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  22. 17–21 May 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  23. 24–28 May 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  24. 7–11 Jun 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  25. 14–18 Jun 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  26. 21–25 Jun 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  27. 5–9 Jul 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  28. 12–16 Jul 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  29. 19–23 Jul 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  30. 26–30 Jul 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  31. 2–6 Aug 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  32. 9–13 Aug 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  33. 16–20 Aug 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  34. 23–27 Aug 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  35. 6–10 Sep 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  36. 13–17 Sep 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  37. 20–24 Sep 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  38. 4–8 Oct 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  39. 11–15 Oct 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  40. 18–22 Oct 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  41. 25–29 Oct 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  42. 1–5 Nov 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  43. 8–12 Nov 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  44. 15–19 Nov 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  45. 22–26 Nov 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  46. 6–10 Dec 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  47. 13–17 Dec 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  48. 20–24 Dec 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  49. 27–31 Dec 2027

    Live virtual classroom

    €1,625 + VAT
    Register

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.

View full course outline

What you will achieve

Learning objectives

  • 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

Who should attend

Target audience

  • 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

Methodology

Learning approach

  • 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.

Complete course outline

Five focused days of learning and application

The timings provided are estimates and may vary depending on the number of participants and the discussions taking place during the sessions. They are indicative only and do not constitute a binding commitment.

Day 1

Working Efficiently with Data

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

Day 2

Essential Functions

  1. Logical Functions: IF, IFS, AND and OR
  2. Lookup Functions: XLOOKUP, INDEX and MATCH
  3. Counting and Summing with Conditions: COUNTIFS and SUMIFS
  4. Text Functions: Cleaning names, codes and addresses
  5. Coffee break
  6. Text Functions: Cleaning names, codes and addresses (continued)
  7. Date and Time Functions: Deadlines, working days and durations
  8. Error Handling: Finding and preventing formula errors
  9. Practical Exercise: Automating a leave and absence tracker

Day 3

Analysing and Presenting Information

  1. Pivot Tables: Summarising large lists quickly
  2. Grouping, Filtering and Slicers in Pivot Tables
  3. Pivot Charts and Standard Charts: Choosing the right visual
  4. Formatting Reports for Managers
  5. Coffee break
  6. Printing and Page Layout for Professional Documents
  7. Building a One-Page Dashboard
  8. Workshop: Creating an office budget monitoring dashboard

Day 4

Cleaning and Combining Data

  1. Removing Duplicates and Correcting Inconsistent Entries
  2. Splitting and Combining Columns
  3. Introduction to Power Query: Importing and transforming data
  4. Combining Data from Multiple Files or Sheets
  5. Coffee break
  6. Combining Data from Multiple Files or Sheets (continued)
  7. Refreshing Reports Automatically When Source Data Changes
  8. Checking Data Accuracy: Reconciliations and controls
  9. Practical Exercise: Consolidating supplier lists from several departments

Day 5

Automation, Sharing and Protection

  1. Recording Simple Macros for Repetitive Tasks
  2. Running and Editing Recorded Macros Safely
  3. Protecting Sheets and Workbooks: Locking cells and permissions
  4. Collaboration: Shared workbooks, comments and version control
  5. Coffee break
  6. Collaboration: Shared workbooks, comments and version control (continued)
  7. Documenting Workbooks for Other Users
  8. Personal Productivity Plan: Applying skills at work
  9. Final Challenge: Building a complete administrative tracking tool

Ready to book?

Advanced Excel for Administrative Professionals

Next session: 7 - 11 December 2026, Barcelona

Course FAQs

Questions about this course

What participants and training managers usually ask before booking Advanced Excel for Administrative Professionals. Can't find your answer?

WhatsApp
What does Advanced Excel for Administrative Professionals (AS-029) cover?

This course covers Administration and Secretarial through a structured five-day outline focused on practical application, discussion, and implementation planning.

When is the next available session?

The next scheduled session starts on 21 - 25 December 2026. See the course schedules section for the available dates and delivery formats.

Who should attend this course?

Administrative assistants and officers, Executive assistants and secretaries, Office managers and coordinators

Is bilingual course delivery available?

Yes. All course materials and presentations are provided in English, while bilingual explanation and discussion support may be available depending on the selected location and trainer availability. For example, when attending a course in Istanbul, you may request a Turkish-speaking trainer to explain the English course content in Turkish. Arabic explanation support may also be requested at this location. Other languages are available in selected cities. You can choose your preferred language support as an optional preference during registration.

How can I register for a session?

Use any Register button next to the available course dates to open the participant registration page and submit your booking request for the selected session.

Is this course available online as well as classroom-based?

Check the course schedules section for currently published classroom and Online / Live sessions.

Where are classroom sessions delivered?

Current classroom venues include London, Barcelona, Frankfurt, Amsterdam, Cape Town, Dubai, Geneva, Istanbul, Madrid, Munich, Rome, Vienna.

How long is the training programme?

The programme runs for five days from 09:00 to 14:00, which gives 25 contact hours, including a daily 30-minute break (22.5 hours of instruction).