Excel Expert 2016

This course will help you learn the more advanced workings and features of Microsoft Excel 2016. You will look at functions such as macros, pivot tables, functions in formulas and more.

Quick Enquiry

Is this for you?

Excel has such wide scope for use, you’ll find it used both personally and professionally by many worldwide. 

You will find this online advanced Excel course to be advantageous if you spend a good deal of your time working on Microsoft Excel and want to enhance your abilities and understanding of the programme. It’s also a great follow-on from our Excel 2016 course.  

Award and Associated Qualifications

Awarded 18 CPD points upon successful completion

Start Date


Study Type

In centre, online, or a combination

Training Type



18-20 hours

About this course

Microsoft Excel is likely the most commonly used spreadsheet programme across the world. Not only can you create simple spreadsheets to hold your data but advanced Excel courses online also offers a wealth of features and functionality that could make you more efficient and productive.

The course is accessible online so you study at a time and place that suits you best. On successful completion of the full course you’ll receive a Pitman Training certificate. 

There are 17 modules in this course, below is a breakdown of what each one covers: - 

Introduction Module: Welcome and course information

- Data calculations, watermarks, converting text to columns and flash fill. 

- Consolidating data, paste special, custom formats and working with ranges.

- Hyperlinks and formatting charts.

- Applying functions in formulas.

- Conditional formatting.

- Sort and filter data, subtotals and database functions.

- Macros.

- Data validation, precedent/dependent cells, tracing errors, evaluating formulas and the watch window.

- Protecting worksheets and workbooks, passwords and file properties.

- Sharing and merging workbooks and grouping and ungrouping data.

- Pivot tables.

- Pivot charts.

- VLOOKUP, HLOOKUP, embedding and linking objects.

- Scenario manager and data tables.


- Using financial, nested and the CONCATENATE functions.

- Create and modify custom workbook elements.

Aims and Objectives

This advanced Excel course will help advance your understanding of the 2016 version of this renowned Microsoft Office programme to an expert level. 

The course has been designed to provide you with all the knowledge required to gain a Microsoft Office Specialist (MOS) qualification or take the BCS ECDL Advanced Excel exam. 



We’d recommend that you study our Excel 2016 course before, or have equivalent experience before starting this course.

Finance Options

Wherever possible our training is tailored to your needs. The cost of our training programmes depend on the course(s) you choose and varies according to duration and breadth. Rest assured we have a number of payment options available to ensure the cost of training is affordable and can be worked alongside your other financial commitments. Common ways people fund their training include: - 



  • Flexible payment plans to help you spread the cost* available at many of our centres;
  • You could opt to pay upfront.



Company Funded:

Requesting funding from your employers needn’t be a daunting task. Many employers support and encourage their employees with their professional development and consider it a worthwhile investment to fund any training required.

What we can help with:

  • Providing a comprehensive training programme outlining learning outcomes
  • Tailored personnel letters
  • Communication with finance departments to arrange payment options (upfront or payment plan*).

* Terms and Conditions apply. Speak to a Course Advisor for full information on the options available to you.



Career Path

Microsoft Excel is a programme used in a variety of occupations, particularly in finance, accounts and data analysis roles. However, having specific knowledge in Excel is advantageous in any position. Many employers look for people that are confident in using Microsoft Excel, giving you an advantage over other candidates if you do this course.

Excel Expert 2016 Course Training Centres

Region Training Centre Date
Carlow, Cork, Dublin, Dundalk, Galway, Kerry, Limerick, Maynooth, Mullingar, Naas, Sligo, Swords, Waterford, Wexford, Laois, Courses available
Enquire &
Book Now

Looking for prices?

Request more details or call the team on 1800 532632

Download a Course Factsheet Now!

Simply enter your details below and we'll email you a copy of all the course details straightaway. 

Whats the difference?

We offer a range of training packages in a range of subject areas and can offer blended learning opportunities to best meet your needs.


Our courses are practical in nature and focus on a single subject and can last anywhere from a few hours to a few days.


Diplomas are designed to give you a complete skillset mapped to a specific career path and contain a number of core and elective courses.

Course Fees?

Click below for more details or call us on 1800 532632.

Ready to improve your career?

Personal Training?

Quick Enquiry

Group or Corporate?

Quick Enquiry

Call us now and transform your career today

1800 532632

Connect with us on