Find my training Basket 0
Microsoft Office

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

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

GK #7125Virtual Classroom LiveClassroom Live
FormatsVirtual Classroom Live · Classroom LiveTopicsGK Polaris

What you’ll learn

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

Upcoming training

Dates and availability are confirmed by Bolt when we follow up. All times are shown in the provider’s stated time zone.

2026-10-06 — 2026-10-0612:00 PM - 7:00 PM EDT
Virtual Classroom LiveONLINE · English
2026-10-20 — 2026-10-209:00 AM - 4:00 PM EDT
Virtual Classroom LiveONLINE · English

Related courses

Microsoft Office

Microsoft Excel 365: Part 3

By the end of this course, users should be comfortable in both the online and desktop environments, using automating functions, analyzing and presenting data, auditing and error checking your work, working in multiple workbooks, and accessing and distributing data.

Live onlineClassroom Live
View details