Skip to content

MS Excel 2016 - Level 3 - Online Course

Find a Course
  • Or choose a specific course

MS Excel 2016 – Level 3 – Online Course

Course Cost £150 +VAT
Duration 1 DAY
Online
  • Course focuses on advanced Excel features, formulas, PivotTables, illustrations, and templates.
  • Aims to enhance Excel 2016 skills for better data manipulation and application use.
  • Targeted at individuals needing in-depth Excel 2016 knowledge.
  • Prerequisites include attending Excel 2016 Level 1 and/or Level 2 courses.
  • Objectives include data validation, advanced formulas, auditing, and PivotTables.

Overview

This one-day online Microsoft Excel 2016 training course focuses on enabling participants to explore advanced features of Excel, such as advanced formulas, data validation, auditing tools, PivotTables, illustrations, and templates. The course aims to enhance the manipulation of data within Excel 2016. Targeted at individuals seeking a deeper understanding of Excel 2016, it requires prior completion of Excel 2016 Level 1 and/or Level 2 courses or equivalent knowledge. The course covers topics like data validation, advanced formulas, auditing worksheets, creating PivotTables, working with templates, and inserting illustrations.

Who should attend

Excel Users

Course Content

Online Microsoft Excel 2016 Training

Course

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.

Objectives:

  • 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
  • • Mixed cell references BODMAS
  • • Date and Time Functions
  • Auditing a Worksheet
  • • Display formulas in worksheet cells
  • • Show precedent and dependent cells
  • • Finding and Resolving Errors
  • • Using the Watch Window
  • • Evaluating a FormulaCreating PivotTables, PivotCharts, Slicers and Timelines
  • • Creating a PivotTable
  • • Amending the fields in a PivotTable
  • • Updating the PivotTable
  • • Adding Calculations to a PivotTable
  • • Add Grouping to a PivotChart
  • • Pivot Tool Gear Settings
  • • 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

Who Should Attend

Excel Users

Location

This course supports online training.
Course Cost £150 +VAT
Online
Duration 1 DAY

Experts in Construction and Infrastructure Training

1000+

Training courses available

250000+

Course hours completed

50+

Expert trainers

CITB, APS, IEMA

Accreditation training centres

12

Accreditations

Testimonials

We’ve helped thousands of professionals grow their skills and confidence. Hear directly from the people who’ve taken our training courses.

The course was exceptional, well run in terms of delivery of information, IT online course but seamless. Very interesting examples of temporary works failures applicable to the businesses we worked in. Break out activities / group examples worked very well and were again well managed by the trainer. Fantastic course, I will recommend to others! Best course I have attended in years!

CITB Temporary Works Co-Ordinator

Black & Veatch

The trainers knowledge was excellent and I liked his examples and how he could relate them to every day relatable examples that we could all understand. Coming from different industries and sectors his examples were a common ground. It was handled very well virtually and the engagement worked with his questioning and answering

Contract Management

The Pension Regulator

The training was very interactive and the tutor was excellent in engaging every course attendee and ensuring that the course content was tailored to each attendees Organisation and Company requirements

CITB Temporary Works Awareness

Kone – H &S Advisor

Contact an Expert Trainer