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® Excel® 365/Excel® 2019: Working with Formulas and Functions (WFAF)

Choose CPE Format:

Live WebinarSELECT

There are currently no upcoming dates scheduled for this webinar. Please fill out this short form to be notified when this webinar is next available. 

FIRST NAME
LAST NAME
EMAIL ADDRESS
COMMENTS (OPTIONAL)
Self-Study SELECT STARTING AT $65 (On Demand)

Downloadable PDF

Credits: 4

Qualifies For: CPE

$65

Textbook

Credits: 4

Qualifies For: CPE

$80
This new course has not yet been reviewed. Check back soon!

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.

Microsoft® Excel® 365/Excel® 2019: Working with Formulas and Functions (WFAF)

  • Customer Rating
    Not Yet Rated
  • Field of Study
    Spec. Knowledge
  • Level
    Intermediate
  • Credits
    4
  • Qualifies for

    CPE

Overview

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.

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

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

Designed for:

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

Prerequisite:

“Microsoft® Excel® 2019: Getting Started" or equivalent experience working with Excel 2019 in the Windows operating system environment

Advanced Preparation:

None

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.
loading

Loading...

Loading...

Thank You!

YOU HAVE ADDED THE FOLLOWING TO YOUR CART:


Loading...

Thank You!

Thank You! Your request has been submitted.



Get More with a Surgent CPE package

Unlimited Self-Study Package

  • Unlimited 24/7 access to 200+ downloadable self-study courses

  • Courses range from 2-20 credits

  • Provides online grading & CPE certificates by email

  • Does NOT include Premium courses

$499

Buy Now

Unlimited Webinar Package

  • Unlimited access to all non-premium live CPE webinars

  • Includes 1-, 2-, 3-, 4-, and 8-hour webinars, including Saturday and evening options

  • Access through December 31st of the year in which you purchase

  • Does NOT include Premium courses

$599

Buy Now

 

Unlimited Plus Package

  • Unlimited access to ALL live CPE webinars

  • Includes all premium courses and virtual conferences

  • Unlimited 24/7 access to all self-study courses

  • Includes all on-demand webcasts

  • Access for a year from purchase date

$799

Buy Now

Explore Additional Courses by Topic

  • CPE Continuing Professional Education for CPAs

  • IRS Continuing Education for EAs and the AFSP program

  • CFP Accepted by the CFP® Board

  • YB YellowBook Continuing Education

  • CTEC Approved for CE by CTEC

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.