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


We realize that there is an awful lot to take in when doing a one day advanced  Excel course, so we, uniquely give every student access to our online course as well . This is great not just for revising  but also for further study as our online course covers all levels of Excel.


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  19th April
    • Thursday  17th May
    • Thursday  21st June
    • Thursday 26th July
    • Thursday 23th August


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 and pivot table.  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.