Skip to content

MS Excel 2016 - Level 2 - Online Course

Find a Course
  • Or choose a specific course

MS Excel 2016 – Level 2 – Online Course

Course Cost £150 +VAT
Duration 1 DAY
Online
  • Course focuses on advanced Excel functions, formulas, data analysis, and visualization.
  • Delegates learn to manipulate complex Excel components effectively.
  • Prerequisites include basic Excel knowledge or completion of Level 1 course.
  • Students will use advanced formulas, organize data, create charts, and apply filters.
  • Course covers topics like Conditional Formatting, Charts, Sorting, Filtering, and Tables.

Overview

The Online MS Excel Training is a one-day course focusing on advanced Excel 2016 features to manipulate and analyze data effectively. The course aims to enhance delegates' skills in using advanced functions, creating charts, sorting, filtering, and applying conditional formatting. Prerequisites include basic Excel knowledge or completion of Excel 2016 Level 1. Objectives include using advanced formulas, organizing data, creating charts, sorting and filtering, and applying conditional formatting techniques. The course covers topics such as working with range names, logical functions, charts, data analysis, Excel tables, and conditional formatting.

Who should attend

Data Analysts, Financial Analysts, Business Analysts

Course Content

Online MS Excel Training

Course Duration: 1 day

Course

In this virtual, Instructor-Led course, you will use advanced formulas and work with various tools to analyse data in spreadsheets. You will also organize table data, present data as charts, along with applying Conditional Formatting, Sorting and Filtering.

Course Aim

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

Target Student:  This course is meant for those desiring to gain advanced skills necessary for calculating data using advanced functions and formulas, charting your data, use filter and sorting techniques, use conditional formatting to change the look of cells.

Prerequisites:Before starting this course, students are recommended to take the Excel 2016 Level 1 course or have equivalent knowledge.  Delegates will be expected to be able to perform simple formulas prior to attending this course.

Objectives:

use advanced formulas.

• organize worksheet and table data using various techniques

• create and modify charts

• sort and filter data

• apply Conditional

Formatting Calculating with Advanced Formulas

• Use Excel’s Quick Analysis Tools

• Work with Range Names

• Calculating across Worksheets (3D)

• Using Logical Functions (IF, AND, OR)

• IFS and SWITCH

• Applying Lookup Functions

Charts

• Understanding Charts

• New Charts in 2016

• Create a Chart

• Modify and Format a Chart

• Add and Remove Chart Data

• Add a Trendline to a Chart

• Analyse Data Using Sparklines

Organising Worksheet Data

• Apply Basic Sorting to a Data Range

• Advanced Sorting

• Summarise Data with Subtotals

Analysing Selected Data

• Applying Basic Filters

• Advanced Filters

Mastering Excel Tables

• Introducing Excel Tables

• Formatting a Table

• Creating Calculated Columns

• Using Slicers

• Converting Tables to Ranges

Apply Conditional Formatting

• Conditional Formatting

• Customising Conditional Formatting

• Sorting and Filtering by Conditional Formats

Cost:£150 + Vat

Who Should Attend

Data Analysts, Financial Analysts, Business Analysts

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