Course Catalog
Microsoft Excel – Level 2 / Med (2013, 2016, 2019)
Code: EXCL2
Duration: 1 Day
$295 USD

OVERVIEW

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.

DELIVERY FORMAT

This course is available in the following formats:

Virtual Classroom

Duration: 1 Day
Classroom

Duration: 1 Day

CLASS SCHEDULE

Delivery Format: Virtual Classroom
Date: May 07 2024 - May 07 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: May 14 2024 - May 14 2024 | 12:00 - 19:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: May 29 2024 - May 29 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Jun 04 2024 - Jun 04 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Jun 11 2024 - Jun 11 2024 | 12:00 - 19:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Jun 18 2024 - Jun 18 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Jun 25 2024 - Jun 25 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Jul 02 2024 - Jul 02 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Jul 09 2024 - Jul 09 2024 | 12:00 - 19:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Jul 23 2024 - Jul 23 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Aug 01 2024 - Aug 01 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Aug 08 2024 - Aug 08 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Aug 15 2024 - Aug 15 2024 | 12:00 - 19:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Aug 22 2024 - Aug 22 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Sep 05 2024 - Sep 05 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Sep 10 2024 - Sep 10 2024 | 12:00 - 19:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Sep 17 2024 - Sep 17 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Sep 24 2024 - Sep 24 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Oct 10 2024 - Oct 10 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Oct 22 2024 - Oct 22 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Nov 05 2024 - Nov 05 2024 | 09:00 - 16:00 EST
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Nov 19 2024 - Nov 19 2024 | 12:00 - 19:00 EST
Location: Online
Course Length: 1 Day

$ 295

Delivery Format: Virtual Classroom
Date: Apr 05 2024 - Apr 05 2024 | 09:00 - 16:00 EDT
Location: Online
Course Length: 1 Day

$ 295

GOALS

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.

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

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

  • 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
  • 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
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.

PREREQUISITES

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