Excel Formulas
Introduction
Formula and Function Basics

2
Simple Formulas

3
Complex Formulas

4
Relative and Absolute Cell References

Cell References
Explore absolute and relative cell references, and the way they can affect formulas.


5
Functions

Functions
An introduction to functions, including AUTOSUM, the Function Library, and more.

Formula Tips

6
Solving RealLife Problems in Excel

Solving RealLife Problems in Excel
Learn how to turn reallife problems into formulas.


7
DoubleCheck Your Formulas

8
Understanding Number Formats

9
Practice Reading Formulas

10
Interactive: Formula Flashcards
Scenarios

11
OverBudget Items

12
PercentOff Sale

13
Basketball Team: Player Statistics

14
Movie Tickets

15
Interactive: Pizza Party Panic

16
Interactive: Birthday Budget Blues

17
Using the IF Function

18
Using CONCATENATE to Combine Names

19
Buying a Printer: Cost Comparison
Advanced Scenario: Create an Invoice

20
Invoice, Part 1: Free Shipping

21
Invoice, Part 2: Using VLOOKUP

22
Invoice, Part 3: Fix Broken VLOOKUP

23
Invoice, Part 4: More Shipping Options

24
Invoice, Part 5: Data Validation
Formula and Function Basics

Simple Formulas
03:1311,401 viewsLearn how to create simple formulas in Excel.

Complex Formulas
05:106,152 viewsLearn to use the order of operations to create complex formulas.

Cell References
05:267,595 viewsExplore absolute and relative cell references, and the way they can affect formulas.

Functions
05:177,680 viewsAn introduction to functions, including AUTOSUM, the Function Library, and more.