Lesson 2.2 Essential Excel Formulas
Mathematical Formulas
- SUM() Â Â Adds a range
- AVERAGE() Â Â Calculates mean
- MAX() and MIN() Â Â Find highest and lowest values
Conditional Formulas
- IF(logical_test, value_if_true, value_if_false)
- COUNTIF(range, condition)
- SUMIF(range, condition, sum_range)
Text Functions
- LEFT(), RIGHT(), MID() Â Â Extract characters
- TRIM() Â Â Removes extra spaces
- CONCAT() Â Â Combines text
Date Functions
- TODAY() Â Â Returns current date
- MONTH(), YEAR() Â Â Extract components from dates
These formulas help analysts transform raw datasets into meaningful summaries.