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.

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 23th May
    • Thursday 20th June
    • Thursday 18th July
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
Support@ExcelTraining.ie
Book Online

Course Syllabus: Advanced Excel Course:

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

  • VLOOKUP
  • VLOOKUP + Helper columns,
  • INDEX and MATCH
  • SUMPRODUCT
  • SUMIF & SUMIFS
  • COUNTIF & COUNTIFS,
  • 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.