*VIRTUAL* – MS Excel 2016 – Level 3

Request info

Online Microsoft Excel 2016 Training

Course Duration: 1 day


In this virtual, Instructor-Led course you use the more advanced features of Excel with advanced formulas, use Data Validation and Auditing tools along with working with PivotTables, Illustrations and Templates.

Course Aim

Enable delegates to examine the more complex components of Excel 2016 and allow for better use of the application and manipulation of data.

Target Student:  Anyone requiring a more in-depth knowledge of Excel 2016.

Prerequisites: Delegates should have attended the Excel 2016 Level 1 and/or Excel 2016 Level 2 course or have the equivalent knowledge.


  • explore ways of validating data
  • use more advanced formulas
  • use auditing tools
  • create and use PivotTables
  • save documents as templates
  • use illustrations in your spreadsheets

Data Validation

  • Number Validation
  • Data List Validation
  • Message Prompts and Alerts
  • Conditional Data Validation
  • Data Validation Errors

Advanced Formulas

  • Statistical Functions to include MAXIFS, MINIFS
  • Working with Text Functions
  • Calculating with Financial Functions
  • Date and Time Functions
  • Database Functions

Auditing a Worksheet

  • Display formulas in worksheet cells
  • Show precedent and dependent cells
  • Finding and Resolving Errors
  • Using the Watch Window
  • Evaluating a Formula



Creating PivotTables, PivotCharts and Slicers

  • Creating a PivotTable
  • Amending the fields in a PivotTable
  • Updating the PivotTable
  • Adding Calculations to a PivotTable
  • Add Grouping to a PivotChart
  • Create a PivotChart
  • Create and use Slicers
  • Create from Tables and Related Tables
  • PivotTable Timelines
  • Create from Tables and Related Tables.
  • Work with PowerPivot Add-In

Working with Templates

  • Create a Template
  • Create a Hyperlink
  • Adding Cell Comments/Notes

Inserting Illustrations

  • SmartArt
  • Insert Images into a Spreadsheet
  • Insert Shapes into a Spreadsheet
  • Group and Layer Graphics
  • Quick Shape Formatting


Cost: £150 + Vat

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2022-05-28' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (18018) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC