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 Real-Life Problems in Excel
-
Solving Real-Life Problems in Excel
Learn how to turn real-life problems into formulas.
-
-
7
Double-Check Your Formulas
-
8
Understanding Number Formats
-
9
Practice Reading Formulas
-
10
Interactive: Formula Flashcards
Scenarios
-
11
Over-Budget Items
-
12
Percent-Off 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 views
Learn how to create simple formulas in Excel.
-
Complex Formulas
05:106,152 views
Learn to use the order of operations to create complex formulas.
-
Cell References
05:267,595 views
Explore absolute and relative cell references, and the way they can affect formulas.
-
Functions
05:177,680 views
An introduction to functions, including AUTOSUM, the Function Library, and more.