Chat with us, powered by LiveChat

Advanced Excel Course:

Course Description:

Our advanced Excel Public Course  is a one day instructor-led  intensive course that  will focus on the  advanced  functions and features that allow you manipulate  data effectivly.

These  includes functions like   VLOOKUP, INDEX, MATCH , OFFSET ,  COUNTIFS  and SUMIFS.
Great emphasis is placed on mastering  Pivot tables  to analyze your data.

This course covers 2010 , 2013 & 2016  Excel versions.

Why use for your advanced Excel Course:

1.  We realize that there is an awful lot to take in when doing an advanced  Excel course, so we, uniquely, also  give each  student access to our online Excel course for one full year.

The online course  is great  for revising what you learnt during the day  but also for further study as it covers extra advanced topics like Arrays formula , complex nested formulas, macro examples  and extra pivot table techniques. This CPD certified course also comes with  live chat support .


2.  You can repeat our 1 day Advanced Excel Course for free within 6 months of your initial course.

See full syllabus below

What Excel Level am I ?

Our Free ‘Testing Workbook’ will test and time your Excel skills and then creates a personalized detailed report of them . Watch the video and Read More..

What will the course do for me ?

In the video below  watch a trained and untrained Excel user tackling common Excel tasks. Notice the huge difference in time and effort and please note this video only covers intermediate Excel skills not somebody with advanced Excel Skills.

CPD Certified Course

This course is  CPD certified
by the CPD Standards office

Upcoming Advanced Excel Courses

Level 3  Course Dates:

    • Thursday 21st February
    • Thursday 28th March
    • Thursday 23th May
    • Thursday 20th June
    • Thursday 18th July
    • Thursday 22nd August
    • Thursday 19th September
    • Thursday  17th October
    • Thursday 21st November
    • Thursday 19th December


Course Duration

One Full day

Course Requirments

Students should be able to create and manipulate worksheets and workbooks containing formulae.  They should be able to create a basic chart.  Ideally they will have completed an  Excel Intermediate course.

Course Location

GEC center, Taylor’s lane, Dublin 8
(beside the Guinness Storehouse)

Course Price

€298 Inclusive
5% discount for three or more Bookings.
Book Place Online

Our Clients

Training Rooms

Contact Us

GEC Centre, Taylor’sLane, Dublin 8
01 429 8724
Book Online

Course Syllabus: Advanced Excel Course:

Module 1: Automate your spreadsheet analysis by using the power of combining these functions.

  • VLOOKUP + Helper columns,
  • OFFSET & INDIRECT FunctionsCase studies:
    We will look at real life examples and models using these techniques.

Module 2: Automate Decision making processes:

  • IF and nested IF Functions
  • AND, OR, NOT Functions

Module 3: How to build complex powerful Formulas with an easy step by step method.
Module 4: Cleaning your data:

Text and Date Functions with examples of combining Text functions.

Module 5: Data Analysis: Use techniques to analyze your data instantly.

  • Advanced Filters
  • Using List Features
  • Dynamic Lists
  • The new Sumifs and Countifs Functions

Pivot Tables

  • Using the Pivot Table Wizard
  • Changing the pivot table layout
  • Formatting
  • Grouping items
  • Inserting calculated fields
  • Pivot Table Options
  • Display and hide data in fields
  • Lay out reports directly on worksheet
  • Pivot Charts
  • Pivot Tables Slicers
  • 20 Pivot Tables Recipes for powerful reports
  • Pivot Tables Macros
  • Creatng Independent Pivot table

Module 6: What If Analysis

  • Scenarios
  • Custom Views
  • Reports
  • Goal Seek
  • Data Tables

Module 7: Macros

  • Purpose of Macros
  • Recording macros
  • Where to save macros
  • Absolute and relative record
  • Running macros:
  • Custom buttons, menu items, keyboard shortcuts

Case Studies: Examination of Macros to save time and automate your work.