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.

ITA (Individual Training Account) funding may be available for this course subject to eligibility. Please contact us for more information.

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?