CALL FREE ON 0800 220454

Excel 2016

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

The course is for anyone wanting to learn how to utilise the 2016 version of this powerful spreadsheet programme.  The course will teach you how to create and format worksheets, use functions, tables, formulas and more.

Course Duration: 24 hours

CPD Points: 24


There are 27 modules  in this course:

  •  Introduction Module: Welcome and course information
  •  Starting Excel
  •  Opening & closing Excel, Using SUM and Navigating Excel
  •  Formatting
  •  Number Formats and Different File Types
  •  Autofill, Formulas and Inserting/Deleting Columns & Rows
  •  Hiding & Unhiding and Aligning & Formatting Cells
  •  Cut, Copy & Paste, Drag & Drop, Format Painter and Auto Complete
  •  Text Orientation, Non-Adjacent Data, Freeze & Unfreeze, Zoom and Worksheets
  •  Styles and Themes
  •  Configure Worksheets and Workbooks
  •  Using Functions, Quick Analysis and Sort
  •  Headers and Footers
  •  Create and Manage Tables
  •  Worksheets and Viewing Workbooks
  •  Introduction to Charts
  •  Complex Formulas
  •  Now, Count, Today and If Functions
  •  Format and Modify Text Using Functions
  •  Perform Logical Operations Using Functions
  •  Hidden Worksheets and Financial Functions
  •  Using Formulas in Grouped Worksheets
  •  Charts
  •  Sparklines and Inserting Images
  •  Spell Check, Filter and Find & Replace
  •  Web Pages, Hyperlinks and Conditional Formatting
  •  Importing a Text File, Customising the Ribbon & the
  • Quick Access Toolbar and Tell Me What You Want To Do

The course is suitable for beginners with little or no experience of the programme; it will help you learn some of the fundamental actions you can carry out in Excel before advancing your knowledge to more in-depth features.

As Excel is widely used in a variety of job roles such as finance and accounting, management and office administration roles, it is suitable for a wide audience.

As Microsoft Excel is used across such a wide range of job roles, taking the time to learn the latest version of this spreadsheet programme will show your commitment to continuing professional development and help towards your career progression opportunities.

There are no pre-requisites for the study of this Excel 2016 course, it is suitable for beginners.

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?