Entering Formulas

Basic Formulas

Order of Operations (BODMAS)

Basic Mathematical Functions

Using SUM

Using AVERAGE

Using COUNT

Using MAX

Using MIN

Using AutoSum

 

Referencing Cells in Formulas

Referencing Cells in Formulas

Absolute references ($ symbol)

Fixing only the row/column

 

Multiple WorkSheets and WorkBooks

Referencing Cells in Other WorkSheets

Referencing Cells in Other WorkBooks

Opening WorkBooks with External References

 

Conditional Formatting

Introduction to Conditional Formatting

Highlighting Specific Values

Data Bars

Color Scales

Icon Sets

Fine-Tuning Conditional Formatting

Using Multiple Rules

Advanced Formulas and Functions

Inserting Functions

Formula Building Recommendations

Naming Cells and Ranges

Logical Statements

Conditional Formulas (AND, OR, NOT)

 

IF Functions

Understanding IF Functions

Nested IF Functions

Combining IF with AND, OR, and NOT

 

IS Functions

Understanding IS Formulas

Using IS with IF to Change Error Messages

 

Database Formulas and Functions

The LOOKUP Function

Array Lookup

Vector Lookup

The VLOOKUP Function

The HLOOKUP Function

 

Detailed Functions

Date and Time Calculations

Text and Data Functions

Mathematical Functions

Statistical functions