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

1157 - Excel Course 1B: Basic Formulas