Skip to content

MS Excel 2016 - Level 2

Find a Course
  • Or choose a specific course

MS Excel 2016 – Level 2

Course Cost £235 +VAT
Duration 1 DAY
  • Course focuses on advanced Excel skills, data analysis, chart creation, and collaboration.
  • Designed for those seeking a higher skill level than Level 1 Excel course.
  • Students will learn advanced formulas, data organization, chart modification, and collaboration.
  • Content includes working with formulas, charts, data analysis, and conditional formatting.
  • Participants will gain skills in data calculation, chart creation, and data organization.

Overview

The Excel 2016 Training course is designed for individuals seeking to enhance their skills beyond the Level 1 course. Participants will learn to use advanced formulas, analyze data, create and modify charts, apply formatting conditions, and collaborate with others. The course covers topics such as advanced formulas, chart creation and modification, data analysis, worksheet organization, Excel tables, conditional formatting, and collaboration tools. The course duration is 1 day.

Who should attend

Delegates

Course Content

Course Description

In this 1 day course you will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, collaborate with others and work with conditional formatting.

Who is this course for:

Delegates desiring to gain a more advanced skill set that the Level 1 course.

Delegate Requirements:

Before starting this course, students are recommended to take the following course or have equivalent knowledge: Microsoft Office Excel 2016: Level 1.
Objectives

Upon successful completion of this course, students will be able to:
• use advanced formulas
• organize worksheet and table data using various techniques
• create and modify charts
• create and use formatting conditions
• collaborate with others

Course Content

Calculating Data with Advanced Formulas

Work with Range Names
Calculate across worksheets and workbooks
Analyze Data with Logical and Lookup Functions
IFS and Switch Functions

Presenting Data Using Charts

Understanding Charts and Chart types
Create a Chart
Modify and Format Charts
Add and remove Chart data
Add a Trendline to a Chart
Analyse Data using Sparklines

Analysing Data

Applying Basic Filters
Advanced Filters
Use Outlines to organize data

Organizing Worksheet Data

Apply basic sorting to a Data Range
Advanced Sorting
Summarise Data with Subtotals

Working with Excel Tables

Introducing Excel Tables
Creating calculated columns
Formatting a Table
Using Slicers
Converting Tables to Ranges

Creating and Applying Conditional Formatting

Conditional Formatting
Customizing Conditional Formatting
Sorting and Filtering by Conditional Formats

Collaborate with Others

Protected View
Track Changes
Workbook Merging
Adding and working with INQUIRE Add-In

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