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

Available Anytime

Location: Online

4Credits

Technical Business

Registration is Open

FICPA Members

~~$79.00 Regular Price~~

Nonmembers

$109.00 Regular Price

Please Login to Register

Please Select co-workers you wish to register from the list:

	Name	Email	Firm Office

Product Code: SU24-365F-SSDL

Level: Intermediate

Vendor: Surgent

Field of Study: Computer Software and Applications

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.

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

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

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.

Prerequisite:

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

Additional Info:

You will receive an email from [email protected] with instructions on how to log onto your course shortly. If you do not receive the email within the hour, please check your spam filter.

For technical support, registration questions or other customer service-related inquiries, please call (800) 778-7436 or email [email protected]. Phones are staffed from 8:30 a.m. to 5:00 p.m. Eastern Time, Monday through Thursday, and 8:30 a.m. to 4:00 p.m. Eastern Time on Friday.