Text

4 CPE

Surgent's Microsoft 365: Working with Excel 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 is a three-lesson intermediate level course. This course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel using step-by-step hands-on activities. This course emphasizes using a standard keyboard and mouse actions to perform tasks in Excel.

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

  • Basic formula and function syntax
  • Formulas pasted with relative references
  • Status bar options and Sum (AutoSum) for quick calculations
  • Formulas pasted with mixed or absolute references
  • Formula results pasted as values
  • Worksheets for grouping, entering formulas, and formatting
  • Ways to link worksheets and workbooks with 3-D formulas
  • The Insert Function button or Buttons from the Function Library to insert functions in formulas
  • Defined names as function arguments
  • Conditional formatting for formulas’ results
  • Common errors using the Trace Error icon and the Formula Auditing tools
  • A circular reference
  • Color-coded cell borders to correct a cell reference error in a formula
  • How to step through a nested formula
  • 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 365 or earlier versions in the Windows operating system environment

Advanced Preparation

None

Intended Audience

Users experienced with using Microsoft 365: Excel in the Windows 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.