CALL FREE ON 0800 220454

Excel 2016 Expert

The Microsoft Excel 2016 Expert training course is available at the Edinburgh, Glasgow, Aberdeen and Inverness Pitman Training Centres or via Online Distance Learning through our Pitman Campus.

For those who have a basic grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use MS Excel at an advanced level.

Course Duration: 18 hours

CPD Points: 18


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

  • 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.

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

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.

Working knowledge of the Excel 2016 program, ideally having completed the Excel 2016 course

Flexible Workforce Development Fund (FWDF)

Claim up to £15,000 for Training your employees

This fund provides Levy Paying Companies an opportunity to up-skill or re-skill Employees and in turn, support economic growth.


Eligibility Criteria:

  • You must be a Levy Paying Employer
  • The Company must be based or operate in Scotland, wholly or partially
  • Employees must reside in Scotland


For more information on applying for this funding, contact our Course Advisors by clicking below:


 A funded training opportunity is now available to those facing redundancy or those who have been made redundant from March 2020 onward.

The National Transition Training Fund aims to tackle the rise in unemployment caused by Covid-19 by offering short sharp training opportunities for people to learn in-demand skills.

If you are currently under threat of redundancy, or have been made redundant at any time from the 1st March 2020 and are aged 25 or over, you can access an industry recognised qualification to help you gain employment.

For further information on how to proceed then contact us referencing the course(s) you are interested in.

For more information on this or any of our courses complete the form

Register for a course

Choose Centre (required)
Name (required) Telephone (required) Email (required) Which course are you interested in? (required) Enquiry Allow Future Contact?