Date and Time: June 15, 2026 - 10:30 am - 12:00 pm MT (90 Minutes)

Location: Zoom - Virtual Instructor Led Training by OpenCircle.

Cost: $80.00 (OpenCircle Members get 25% off)

Course Description: Excel 2: Advanced Formula & Conditions

This intermediate Excel course builds on the foundational skills covered in Introduction to Spreadsheets.

Learners will work with a preformatted spreadsheet and advance their skills by creating complex formulas using both relative and absolute cell references. The course introduces conditional functions such as IF, enabling users to generate dynamic results based on specific conditions. Participants will also explore conditional formatting techniques to visually highlight key data points and improve spreadsheet clarity. By the end of the course, learners will be equipped to design responsive, data-driven spreadsheets that adapt to changes automatically.

Learning Objectives:

• Apply relative and absolute cell referencing in formulas to ensure accurate calculations across various spreadsheet structures.

• Use logical functions such as IF to return results based on specified conditions.

• Use conditional formatting tools to visually highlight cells that meet defined criteria, enhancing data readability.

• Design responsive spreadsheets that automatically adapt to changing data inputs using dynamic formulas and formatting techniques.

Course Outline:

1. Welcome and Review of Key Concepts

   • Review of cell referencing and formatting

   • Recap of formulas vs. functions
     

2. Order of Operations

   • Explanation of PEMDAS (Parentheses, Exponents, Multiplication/Division, Addition/Subtraction)

   • Writing formulas that follow Excel’s calculation rules

   • Identifying and troubleshooting common order of operations errors
     

3. Introduction to Conditional Functions

   • Understanding the purpose and syntax of the IF function

   • Creating logical tests to return to different values based on criteria
     

4. Conditional Formatting

   • Modifying fonts, colors, and cell styles to improve readability

   • Applying built-in and custom rule types

   • Customizing fonts, colors, and cell styles
     

Refund Policy - by OpenCircle

A 50% refund is offered for cancellations within 5 business days from scheduled start date. No refund offered for non-attendance. OpenCircle reserves the right to cancel or re-schedule classes due to unforeseen circumstances including not achieving minimum classroom registration requirements.  Registrants will receive a full refund or be offered enrollment in the next scheduled course.

System Requirements:

Computer or tablet, internet connection, audio and camera. ZOOM link and instructions will be emailed to participants closer to the start date.

Certificate of Completion:

Upon successful completion of this course, a certificate of completion will be available for download and printing.

Please register here.