Text

4 CPE

Surgent's Microsoft® Excel® 2019: Working with Formulas and Functions

This is a text-based course

Text
4 CPE

This is a text-based course. To receive credit, you are required to review all content and achieve a minimum score of 70% on the final exam.

This course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel 2019 using step-by-step, hands-on activities.

Learning Objectives

  • Describe formula and function syntax and create basic formulas
  • Copy/paste and fill formulas
  • Enter formulas on grouped worksheets
  • Use multiple methods to build formulas
  • Apply conditional formatting to formulas’ results
  • Find and correct formula errors using a variety of tools, such as the Error Checking feature and Trace Error icon, the Formula Auditing tools, and the Watch Window

Major Topics

  • Identify basic formula and function syntax
  • Recognize formulas pasted with relative references
  • Select status bar options and sum (AutoSum) for quick calculations
  • Recognize formulas pasted with mixed or absolute references
  • Identify formula results pasted as values
  • Select worksheets for grouping and entering formulas
  • Identify ways to link worksheets and workbooks with 3D formulas
  • Select the insert function button or buttons from the function library to insert functions in formulas
  • Recognize defined names as function arguments
  • Apply conditional formatting to formulas’ results
  • Identify and correct common errors using the trace error icon and the formula auditing tools
  • Identify and correct circular references
  • Select color-coded cell borders to correct a cell reference error in a formula
  • Identify how to step through a nested formula
  • Identify how to use the Watch Window and other tools to analyze, protect, and hide formulas

CPE Credits Available

4 CPE
4
Computer Software & Applications

Things to Know About This Course

Course Level

  • Intermediate

Professional Area of Focus

  • Technology

Prerequisites

Experience working with Excel 2019 in the Windows operating system environment

Advanced Preparation

None

Intended Audience

Users experienced with using Excel 2019 in the Windows 10 operating system environment or experienced Excel users switching from earlier versions of Excel.

Provider

Surgent CPE

Purchase This Course

  • COCPA Member

    $ 79 79
    Join

  • COCPA Non-Member

    $ 103 103
    Your Price

Please login to register.