Customer Service: 800-778-7436     

To access your product click the Log In link at the top right of the screen. Once inside your account, you will be able to access your Packages, Self-Study Product, and Webinar Registrations.

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Microsoft 365: Working with Excel Formulas and Functions (365F)

  • Format Self-Study Download
  • Credits 4.00
  • Level Intermediate
  • Field of Study Computer Software & Applications (4)

Overview

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.



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

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

Who should take this course:

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

Experience working with Excel 365 or earlier versions in the Windows operating system environment

None

No

No

No

QAS Approval Surgent
IRS Approval Surgent
CFP Approval Surgent
CTEC Approval Surgent
CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.