Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Excel 2016 Level 2

Become familiar with intermediate features and functionality of Microsoft Excel 2016.

GK# 5001

Course Overview


In this course, you will become familiar with intermediate features and functionality of Microsoft Excel 2016.

This course includes access to our exclusive Microsoft Office Online Support Program, enabling you to build your skills and expertise after class. The program provides 24x7 access for 60 days to online mentoring via chat from Microsoft Office experts.


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:


What You'll Learn

  • Organize, protect, and display data using various tools
  • Use the IF function, create linking formulas, and manage links
  • Manage and arrange multiple workbooks, insert and manage multiple worksheets within a workbook, and consolidate data from multiple sources
  • Create and modify charts to present data effectively
  • Customize charts to enhance their appearance
  • Create, apply and modify styles to format worksheets consistently and quickly
  • Use comments, text boxes to annotate worksheets, and sparklines to highlight and explain data


Viewing outline for:

Classroom Live Outline

1. Worksheet Organization

  • Managing Range Names
  • Creating and Using Workbook Templates
  • Applying Worksheet Security
  • Creating and Using Outlines

2. Advanced Formulas

  • Using the IF Function
  • Linking Formulas
  • Modifying and Restoring Links

3. Using Multiple Workbooks and Worksheets

  • Working with Multiple Workbooks
  • Working with Multiple Worksheets
  • Consolidating Data

4. Working with Charts

  • Creating Charts
  • Changing Chart Data
  • Modifying Chart Elements
  • Creating Custom Charts

5. Applying Formatting

  • Working with Styles
  • Annotating Worksheets
  • Using Sparklines



Microsoft Excel 2016 – Level 1 course or possess an equivalent skillset

Who Should Attend


Individuals familiar with Microsoft Office Excel 2016

Follow-On Courses


This course is one of four recommended to help you prepare for Microsoft Exams 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation, and 77-728: Excel Expert 2016: Interpreting Data for Insights. Those exams are required for the Microsoft Office Specialist (MOS): Microsoft Office Excel 2016 and the Microsoft Office Specialist – Expert (MOS): Microsoft Office Excel 2016 certifications.

Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Request this course in a different delivery format.