Advanced Excel Course

Our one day Advanced Excel public course will bring intermediate Excel users up to advanced level users.

It will focus on the  advanced  functions and features that you will use most in the workplace including   VLOOKUP, INDEX, MATCH , OFFSET , COUNTIF, COUNTIFS  and SUMIFS and on how to  create  powerful Pivot table  reports to analyze your data.
This course covers 2007, 2010 & 2013 Excel versions. See full syllabus below.

You will also for post course support , get full  access for one year to our complete online Excel Course.

See Course Syllabus Below.

Finally as our  advanced Excel course is quiet intensive, you can repeat this course for FREE within 6 months.

excel training courses dublin

Course Duration

One Full day

Course Requirments

You should have completed our Level 2 Intermediate course or you will have at a minimum a  knowledge of.

  • If Functions
  • Creating basic Vlookup Functions

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

Upcoming Advanced Excel Courses

Thursday  19th May
Thursday  23th June
Thursday   29th July

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.