Surgent's Microsoft 365: Working with Excel Formulas and Functions

Description

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.

Highlights

• 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

Objectives

Designed For

Users experienced with using Microsoft 365: Excel in the Windows operating system environment, or experienced Excel users switching from earlier versions of Excel.