Surgent's Microsoft Excel 2016: Working with Formulas and Functions (Self-Study)

Code: JSDLFF16

Date Valid for one year from purchase date
Format Self-Study (Downloadable PDF)
CPE credits CPE 4.0
of study
Computer Software & Applications - Non-Technical (4.0)
Standard member fee $65.00
checkmarkStandard nonmember fee $65.00

Members: Please log in to receive member fee.


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

Who should take this program?

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

Major subjects

  • 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
  • Select Formula AutoComplete to create formulas with 3-D references
  • Select buttons from the Function Library to insert functions in formulas
  • Select defined names as function arguments
  • Select conditional formatting to formulas' results
  • Recognize the Error Checking feature and the Trace Error icon; identify and correct common errors
  • Select the Formula Auditing tools to trace a formula's precedent and dependent cells
  • Identify and resolve a circular reference
  • 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 objective(s)

  • 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


Course code Code JSDLFF16
Sponsor Surgent
NASBA ID#: 103212
Level Intermediate
Format Self-Study (Downloadable PDF)
Prerequisites Prereq. "Microsoft Excel 2016: Getting Started" or equivalent experience working with Excel 2016 in the Windows operating system environment