Excel 2016 Level 2

Code: EX16L2
Duration: 1 Day
Delivery methods:   Classroom, Virtual Learning, Onsite Event
Price per delegate: $400.00
Microsoft Silver Partner
Trained over 60000 delegates
Delivered by world class instructors
Highly competitive pricing
Capped class sizes
Post course support

Course Description

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.

Target Student

This course is meant for those desiring to gain a more advanced skill set than the Level 1 course.


Before starting this course, students are recommended to take the following course or have equivalent knowledge:

Performance-Based 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

Lesson 1: 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

Lesson 2: 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

Lesson 3: Organizing Worksheet Data

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

Lesson 4: Analysing Selected Data

  • Applying Basic Filters
  • Advanced Filters
  • Use Outlines to organize data

Lesson 5: Mastering Excel Tables

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

Lesson 6: Applying Conditional Formatting

  • Conditional Formatting
  • Customizing Conditional Formatting
  • Sorting and Filtering by Conditional Formats

Lesson 7: Collaborate with Others

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

Request More Infomation

Inquiry for
This field is for validation purposes and should be left unchanged.
Learn how Elite helped Aimbridge Hospitality stay ahead of the competition.
View Study