Cart () Loading...

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


Microsoft Excel - Level 2 / Med (2013, 2016, 2019)

Learn how to use formulas and advanced functions while creating workbooks.

This course will teach you how to use formulas and advanced functions, create and format tables, sort and filter, add and format graphics, and protect and finalize a workbook.


Instruction will be personalized by version. Students have the option to progress through the course using, Microsoft Excel- Level 2 2013, or Microsoft Excel Level 2 2016.

GK# 7125 Vendor# EXCL2
Vendor Credits:
  • Global Knowledge Delivered Course
  • Training Exclusives
No matching courses available.
Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.
Access Period:
Scheduling a custom training event for your team is fast and easy! Click here to get started.
Your Selections:
Access Period:
No available dates

Who Should Attend?

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

What You'll Learn

Upon successful completion of this course, you will be able to leverage the power of data calculations and presentation in order to make informed, intelligent organizational decisions. You will work with functions and lists, create advanced formulas, protect your spreadsheets and work with custom view.

Course Outline

Creating Advanced Formulas

  • Apply Range Names
  • Use Specialized Functions

Analyzing Data with Logical and Lookup Functions

  • Use Text Functions
  • Use Logical Functions
  • Use Lookup Functions
  • Use Data Functions
  • Use Financial Functions

Organizing Worksheet Data with Tables

  • Create and Modify Tables
  • Sort and Filter Data
  • Subtotal and Database Functions in Calculate Data

Visualization Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts

Labs Outline

  • Range Names
  • Specialized Functions
  • Lookup Functions
  • Working with Tables
  • Create and Customize Tables
  • Virtualizing Data with Charts
  • How to Create and Modify Charts
  • Working with Trendlines


The prerequisites for this course are an introductory Excel course, or equivalent working knowledge of the software.