Skip to content

MS Excel 2016 - Level 3

Find a Course
  • Or choose a specific course

MS Excel 2016 – Level 3

Course Cost £235 +VAT
Duration 1 DAY
  • Course focuses on advanced Excel features like PivotTables, Data Validation, and Advanced Formulas.
  • Students learn to validate data, use advanced formulas, and work with PivotTables.
  • Delegates should have prior knowledge of Excel functions like Charts and Conditional Formatting.
  • Course objectives include creating PivotTables, using Auditing Tools, and working with Templates.
  • Modules cover topics such as Data Validation, Advanced Formulas, Auditing a Worksheet, and PivotTables.

Overview

The Excel 2016 Training course is designed for delegates seeking to enhance their Excel skills with advanced features like PivotTables, Data Validation, and Advanced Formulas. Participants should have prior knowledge of various Excel functions. By the end of the course, students will be able to validate data, utilize advanced formulas, work with PivotTables, and more. The training covers modules on Data Validation, Advanced Formulas, Auditing a Worksheet, Creating PivotTables and PivotCharts, Working with Templates, and Inserting Illustrations.

Who should attend

Delegates

Course Content

Course Description

In this 1 day course you will build on the previous Excel courses, introducing more advanced topics.

Who is this course for:

Delegates who wish to learn more about some of the additional advanced features of Excel, including PivotTables, Data Validation and Advanced Formulas.

Delegate Requirements: Before starting this course, students are should be able to do the following:

  • Use Names Ranges
  • Calculate across worksheets/workbooks
  • Create and use Charts
  • Use Basic Sort and Filters
  • Work with Excel Tables
  • Apply Conditional Formatting
  • Protect Views
  • Track Changes
  • Merge Workbooks

Objectives

Upon successful completion of this course, students will be able to:

  • Validate Data
  • Use Advanced Formulas
  • Use Auditing Tools
  • Create and manipulate PivotTables and PivotCharts
  • Work with Templates
  • Insert Illustrations

Course Content:

Module 1: Work with Data Validation

Number Validation

Data List Validation

Message Prompts and Alerts

Conditional Data Validation

Data Validation Errors

Module 2: Advanced Formulas

Statistical Functions to include MAXIFS, MINIFS

Working with Text Functions

Calculating with Financial Functions

Date and Time Functions

Database Functions

Module 3: Auditing a Worksheet

Display formulas in worksheet cells

Show precedent and dependent cells

Finding and Resolving Errors

Using the Watch Window

Evaluating a Formula

Module 4: 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

Creating a PivotChart

Create and use Slicers

PivotTable Timelines

Creating from Tables and Related Tables.

Work with PowerPivot

Module 5: Working with Templates

Create a Hyperlink

Creating and adding Cell Comments

Module 6: Inserting Illustrations

SmartArt

Insert Images into a Spreadsheet and/or with correct orientation

Insert Shapes into a Spreadsheet

Group and Layer Graphics

Quick Shape Formatting

Duration:1 Day

Cost:£235 + VAT

Who Should Attend

Delegates
Course Cost £235 +VAT
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