Help  |  Pay an Invoice  |  My Account  |  CPE Log  |  Log in

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

Valid for one year from purchase date
Self-study - Downloadable PDF
4 CPE (4 non-technical)

If the organization paying for the purchase is exempt from sales tax, call us at 952-831-2707 to complete your purchase.

Add to cart

Alternate dates & more options

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.

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

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.

Fees

Our records indicate you are a nonmember. If you register, you will be charged $65.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.
Standard Member Fee $65.00
checkmark Standard Nonmember Fee $65.00

More program information

Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (4.0)
Level Intermediate
Format Self-study - Downloadable PDF
Sponsor Surgent
NASBA ID#: 103212
Prerequisites Prereq. "Microsoft Excel 2016: Getting Started" or equivalent experience working with Excel 2016 in the Windows operating system environment
Advance
prep
None

If the organization paying for the purchase is exempt from sales tax, call us at 952-831-2707 to complete your purchase.

Add to cart

Not a member? Join the MNCPA to start saving on CPE and accessing members-only benefits.

Search CPE catalog