Upskilling YOU
Empowering YOU

MS Excel (Advanced)

Thank you
Thank you
for your booking for {{COURSE_NAME}}
commencing on {{STARTING_DATE}}.

Thank you for your booking for {{COURSE_NAME}} commencing on {{STARTING_DATE}}.

We will be in touch a few days before the course starts to confirm details such as venue, start & finish time etc. Please feel free to contact us in the meantime if you have any queries.

Cancellations made in the final 72 hours before a course commences will be charged in full.

As an ongoing quality control measure and to ensure the highest possible standard of training, courses may be inspected from time to time.

Contacting the Cork Chamber Skillnet Team:

Kate Murray, Training Network Executive
Tel: 021-4530142

Garrett O’ Rourke, Training Network Manager
Tel: 021-4530141


This course is designed to follow-on from the MS Excel Intermediate course. Having already familiarised yourself with the most efficient way of performing everyday tasks, and having covered some intermediate tasks, it is now time to build on that knowledge.

A large proportion of the course is dedicated to using the Database Features in MS Excel – this is a very powerful side to Excel that not many people utilise to its fullest potential.

Useful functions such as IF and Lookups are covered in addition to automating tasks using Macros etc.

It is highly recommended that you first attend Level Two (Intermediate) prior to attending Level Three as some of the topics covered in Level Two are essential for successful completion of Level Three.

  • All participants will be provided with an E-Bridge email address and phone number for any queries or questions that may arise following the training.
  • All participants will be given access to a library of tutorials by way of an email containing the links to the relevant topics. As we record these tutorials ourselves the content / examples used will match those used during the classroom training. As a result the participants will find them to be relevant and easy to follow. The tutorials will be available to participants for a limited time period (6 months following the course).
  • A Cork Chamber Skillnet / E-Bridge Certificate of Attendance will be awarded to each participant on completion of all courses. A sample copy is attached for your approval.
  • This course is also a CPD accredited course accounting for 6 hours approved CPD credit.

Learning Objectives

On completion of this course participants will be proficient in the more advanced functionality of MS Excel including:

  • Advanced Data Analysis – Advanced Filtering, Creating Names Ranges, Sub-Totalling feature, Database Function, Pivot Tables
  • Recording Macros
  • IF, Lookup and other functions
  • Goal Seek & Scenario Manager
  • Protecting worksheets & workbooks

Schedule Outline

Essentials and shortcuts

  • An overview / recap of some essential Intermediate topics
  • Run-through of shortcuts

Named Ranges

  • Creating a named range
  • Redefining a named range
  • Using named ranges

Text Manipulation

  • Upper / Lower/ Proper Functions
  • Text to columns
  • Concatenation
  • Trim
  • Right / Left / Mid Function

Database Features

  • Sorting Records
  • Using AutoFilter
  • Removing duplicates
  • Subtotalling lists
  • Database Functions – DSUM / DAVERAGE / DMAX / DMIN / DCOUNT

Working with Pivot Tables

  • Creating the Pivot Table Layout
  • Refreshing Pivot Table Data
  • Using PivotTable AutoFormat
  • Filtering PivotTable Data
  • Creating calculated fields
  • Grouping dates and values

More on Functions

  • Using the COUNT Functions
  • Using LOOKUP Functions (Vlookup & Hlookup)
  • Using the IF Function
  • Using the SUMIFS Function / COUNTIFS
  • Using IS Functions
  • Creating Formulae with Nested Functions
  • PMT Function

What IF Analysis

  • Using Goal Seek
  • Scenario Manager


  • Using the Auditing Toolbar
  • Tracing Precedents & Dependents


  • Recording & Running Macros
  • Assigning a Macro to the quick access toolbar

Content, Worksheet & Workbook protection

  • Data Validation
  • Protecting Worksheets
  • Protecting Workbook Access
  • Assigning Password Protection
  • Removing a Password
  • Preventing Changes to a Workbook

Entry Requirements

A large proportion of this course is dedicated to using the Database features in MS Excel which many people don’t utilise to its full potential. It’s highly recommended that you first attend Excel Intermediate prior to this course.
Who Should Attend

This course is designed for experienced users of MS Excel. Ideally you should have completed an Intermediate training course prior to attending this advanced programme. Please review the course outline as this is the content that will be covered on the day.

This course can also be run as an in-company programme delivered on-site to meet your specific requirements. For more information on in-company delivery, or if you have any questions regarding this course, please Click Here.

About This Form

The purpose of this booking form is to gather profile information about participants on programmes funded by Skillnet Ireland from the National Training Fund through the Department of Education & Skills (DES). Only aggregated participant data will be reported to the DES.
As an ongoing quality control measure and to ensure the highest possible standard of training, courses may be inspected from time to time.

Pay Online

If you would like to pay online, you ca do so now by clicking on the appropriate button for your membership type


Non Member

The event is now sold out. If you’d like to be added to our waitlist, please email

Similar Courses

Empowering You
Growing your Business
Company Registration Number - 13918
In this section