Microsoft Excel 2016 - Intermediate

I.T. Training

Course Duration: One day

Course Overview

This course is ideal for individuals who wish to explore intermediate excel skills, enhancing their current knowledge of this spreadsheet tool by understanding how to use the applications more complex features. Delegates will learn how to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional looking format.  Our intermediate excel classes are available as virtual classrooms or inperson.


Module 1 – More Functions

  • IF
  • AND/OR
  • Nested IF
  • Text Functions
Module 2 – Sorts, Filter and Security
  • Sorts & Filters
    • Basic Sorts
    • Multiple Sorts
    • Custom Sorts
    • AutoFilter
    • Advanced Filter
  • Protection/Security
    • Data Validation
    • Protected Sheets/workbooks
Module 3 – Linking
  • Linking Sheets
  • Linking Files
  • Managing
Module 4 - Charts
  • Chart Types
  • Chart Elements
  • Modifying Chart Elements
  • Combo Charts

Learning outcomes

Who should attend


Course benefits

Pre-course work

Further courses to consider

Looking For Pricing Information?

Call +44 (0) 28 9043 9624
Or Book Online

View Full Course List

View Full Course List

Microsoft Excel 2016 - Intermediate

Book Now

We are here to help!

For any queries regarding any of our courses please Contact us at enquiries@cosensa.co.uk

Please click here for more information on how we use cookies on this website