Course 55269-A: Intermediate Microsoft Excel 2019

This Intermediate Microsoft Excel 2019 training class is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles.

Audience profile

This course is intended for students who have basic skills with Microsoft Excel 2019 who want to learn intermediate-level skills or students who want to learn the topics covered in this course in the 2019 interface.

Job role: Developer

Skills gained

  • Use formulas and functions.
  • Create and modify charts.
  • Convert, sort, filter, and manage lists.
  • Insert and modify illustrations in a worksheet.
  • Work with tables.

Prerequisites

Before attending this course, students must have:

  • Basic experience with Excel

Course outline

Module 1: Advanced Formulas

This module explains how to work with advanced formulas in Microsoft Excel.

Lessons

  • Using Named Ranges in Formulas
  • Using Formulas That Span Multiple Worksheets
  • Entering a Formula Using Data in Multiple Worksheets
  • Using the IF Function
  • Using the PMT Function
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the CONCAT Function
  • Using the TRANSPOSE Function
  • Using the PROPER, UPPER, and LOWER Functions
  • Using the PROPER Function
  • Using the LEFT, RIGHT, and MID Functions
  • Using the LEFT and RIGHT Functions
  • Using Date Functions
  • Using the ...