MICROSOFT® EXCEL® FORMULAS AND FUNCTIONS - Virtual (C69393)

Log In to Register

Cancellation Policy

Please note that this course is from a third-party vendor, The Carroll-Keller Group. If you cancel less than 7 days in advance of the session, fees are nonrefundable. We strongly recommend registering no later than 24 hours before the course begins. Please contact Sue Malan if you do not receive the event logistics via email at least 24 hours before the course begins: [email protected] or 630-495-0505. Thank you.

Date(s):

07/17/2025

Registration Open:

8:45 AM - 9:00 AM

Time:

9:00 AM - 4:30 PM

Facility:

 Online

Meeting Type:

Courses

CPE Credit:

6.50

Field(s) Of Study:

Personal Development (6.50)

Level of Knowledge:

Basic

Price:

Member: $325.00
Nonmember: $345.00

Individual Discounts:

Not Available

Group Discounts:

10+ Registrants - Discount: 5.00%
20+ Registrants - Discount: 10.00%

Overview

Easily automate calculations and tasks to increase efficiency, accuracy, and productivity

Are your worksheets giving you the wrong answers? Learn the need-to-know formulas and function formulas that will help you see deeper into your worksheet data. It’s time to ditch the old calculator approach to worksheet calculations and super-charge your formulas and function-formulas skillset to get the right answers from your worksheet data. We teach you how to solve simple to complex problems in creative ways by learning what formulas to use and why. Learn all the tips and tricks to best summarize and analyze your worksheet data.

What you will learn in this workshop:

  • Create formulas with combinations of addition, subtraction, multiplication, and division. 
  • Create function-formulas to perform mathematical, logical, and statistical calculations, that dig deep into your data. 
  • Nest of combine multiple formulas and function-formulas for dynamic calculative results. 
  • Learn the roles that absolute and relative referencing and parenthesis play in the formula creation process. 
  • Tools to edit and troubleshoot formula errors and oversights. 
  • Formula auditing tools to evaluate formulas, error checking and trace formula precedents and dependents. 
  • Perform worksheet calculations without the use of formulas. 
  • Link cell values within and between multiple worksheets and consolidate worksheets.

 

Other Information:

  • The session will be delivered on the Zoom platform so all participants will work from their own workspace and use their own computer. Zoom has video capability but, if the participant’s computer is not equipped with a camera, audio will also work. 
  • Participants should enter the Zoom training room at least 15 minutes (8:45 AM) before the start time.

Speaker(s)