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 , 365 & 2019  Excel versions.

Special Offer this Month only.

If you book a place in our Advanced  course for  this month only ,  you  will also get access to  our award winning  Online Excel Course  “WorkPlace Excel” for one full  year.
This not just allows you revise  what you learnt in the day course  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 until 10.00 each night. (Monday-Friday’s).

Also you can also repeat the day course for free within 6 months of the original Course.

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 28th October
Book Place Online

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.

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.

  • 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 the substitution method.
Module 4: Cleaning your Data:

Text and Date Functions with examples of combining Text functions.

Module 5: Data Analysis using Pivot Tables.

  • Understanding the Table structure in Excel.
  • 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
  • Pivot Charts
  • Pivot Tables Slicers
  • Examples of  Pivot Tables Recipes for powerful reports
  • Pivot Tables Macros
  • Creating Independent Pivot tables.

Module 6: What If Analysis

  • Scenarios
  • Goal Seek
  • Data Tables

Module 7: Macros

  • Purpose of Macros
  • Recording macros
  • Understanding  the Macro Recorder and its limitations.
  • Where to save macros
  • Absolute and relative record
  • Running macros:
  • Custom buttons, menu items, keyboard shortcuts