🛠️ Essentials & Syntax

The building blocks of Excel. Master operators, references, wildcards, and error handling to write robust formulas.

➕ Basics
01. Math Operators
Add (+), Subtract (-), Multiply (*), Divide (/), and Power (^). The foundation of all calculations.
⚖️ Comparison
02. Logical Operators
Compare values using Equal (=), Greater Than (>), Less Than (<), and Not Equal (<>).
📍 Vital
03. Cell References
Relative (A1) vs Absolute ($A$1). Understand how formulas behave when copied to new cells.
🔗 String
04. Text Join (&)
The ampersand operator (&). Join text strings and cell values together without using CONCAT.
🃏 Search
05. Wildcards (* ?)
Use the Asterisk (*) to match many characters or Question Mark (?) to match one.
⚠️ Debugging
06. Error Types
Decode common errors: #DIV/0!, #N/A, #REF!, #VALUE!, #NAME?. Know what they mean and how to fix them.
🔲 Selection
07. Range Operators
The Colon (:) for ranges, Comma (,) for unions, and Space ( ) for intersections.
🏗️ Structure
08. Structured References
Using Table syntax like [@Column] instead of cell addresses. Cleaner and auto-expanding formulas.
⬅ Back to Excel Menu