Upcoming

1272 - Excel Course 1B: Basic Formulas

Tue, Oct 20, 2026, 1:30 – 4:30 PM EDT
1272 - Excel Course 1B: Basic Formulas

To take this course, you must be comfortable with most of Excel Course 1A

Get comfortable with the building blocks of Excel formulas. You'll learn how to use operators, understand the order of operations, work with built-in functions, and confidently handle relative and absolute references. By the end, you'll be ready to dive into more advanced formulas like IF and VLOOKUP with ease.

Includes:

Formulas / Functions

  • Entering a basic formula
  • Operators & order of operations
  • General Use of Excel Functions
  • Using Functions: Sum, Average Count, CountA, CountBlank Min, Max Round, Today, and Now

Absolutes ‐ $

  • What is a Relative Reference
  • What is an Absolute Reference
  • Using Full & Partial Absolutes

Trouble Shooting / Tips

  • Display Formulas
  • Editing Formulas
  • Finding Formulas
  • Errors & Error Checking

Register