Excel 2019 - Level 5 Formulas and Functions

Excel 2019 - Level 5 Formulas and Functions

Regular price
Sale price
Shipping calculated at checkout.

Seat time: 3 hours

About the course:

This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to use formulas and functions in Excel including Informational, Logical, Financial, Text functions, data tables and using named ranges.


  • Formulas and Referencing
  • Working with Functions
  • Logical and Informational Functions
  • More Logical Functions
  • Named Ranges
  • Financial Functions and Data Tables
  • Text Functions

You'll learn:

Formulas and Referencing

  • Identify Formula Operators
  • Understand Operator Precedence
  • Over-ride Operator Precedence
  • Enter Formulas
  • Copy Formulas
  • Use AutoFill
  • Update Formula Results
  • Use Absolute References
  • Apply Percentage Values

Working with Functions

  • Identify Function Components
  • Enter Functions
  • AutoSum Numbers
  • Use the AutoSum List
  • Use the ROUND Function
  • Apply the IF Function

Logical and Informational Functions

  • Use the IF Function
  • Use the OR Function
  • Use the AND Function
  • Use Help for Error Messages
  • Use Nested IF Functions
  • Understand IS Functions
  • Use the ISERROR Function

More Logical Functions

  • Use the SUMIF Function
  • Use the COUNTIF Function
  • Use the AVERAGEIF Function

Named Ranges

  • Name Cells
  • Name Cell Ranges
  • Add to and Edit Named Ranges
  • Change Range Names
  • Use Go To
  • Navigate using Cell Names
  • Use Names in Formulas
  • Display Cell Formulas
  • Delete Named Ranges

Financial Functions and Data Tables

  • Understand Financial Arguments
  • Use the FV Function
  • Use the PMT Function
  • Use the NPV Function
  • Use the Pv Argument
  • Use the RATE Function
  • Use NPV Function
  • Use the Guess Argument
  • Use Data Tables

Text Functions

  • Understand Text Functions
  • Use the CONCATENATE Function
  • Use the LOWER Function
  • Use the LEFT Function
  • Add Function Arguments
  • Use the PROPER Function
  • Use the UPPER Function
  • Understand TRIM Function