Special Notices

Shorter bite-size virtual sessions are available on key topics from this course. Please contact us for further details.

In this course you will use Microsoft Office Excel 2016 to streamline and enhance your spreadsheets with templates, charts, and formulas.

Target Audience

This course was designed for delegates who need to learn how to create, modify and manage complex data in Microsoft Excel 2016.

  • Create basic spreadsheets
  • Select and edit data
  • Perform basic formatting
  • Open, close and save files
  • Create basic formulas – AutoSum
  • Use Insert Function to create built-in functions
  • Work with absolute references
  • Use the AutoFill feature
  • Calculate with advanced formulas
  • Organise worksheet and table data
  • Create and modify charts
  • Applying Conditional Formatting
  • Create a basic PivotTable

Module 1: Calculating Data with Advanced Formulas

  • Using Excel’s Quick Analysis Tool
  • Apply Cell Range Names
  • Calculate Data across Worksheets
  • Use Specialised Functions (Text and Date Functions)
  • Analyse Data with IF and VLOOKUP Functions

Module 2: Presenting Data

  • Create, Modify and Format a Chart
  • Using Recommended Charts
  • Creating Sparklines

Module 3: Creating Excel Tables

  • Sort or Filter Excel Table Data
  • Create, Modify and Format Excel Tables
  • Summarise Data with SubTotals

Module 4: Creating a Basic PivotTable

  • Using Recommended PivotTables

Module 5: Applying Conditional Formatting

  • Apply Conditional Formatting

Sorry, we don't have any available dates! Please complete this form to be notified about new dates

Hide form
Please type in a preferred location or region...