Excel formulas are useful in all types of spreadsheet applications. This tutorial includes information on creating formulas and uses real-world scenarios for practice.
-Introduction
About This Tutorial
-Formula and Function Basics
Simple Formulas
lesson contentslesson videos
Complex Formulas
lesson contentslesson videos
Relative and Absolute Cell References
lesson contentslesson videos
Functions
-Formula Tips
Solving Real-Life Problems in Excel
lesson videoscheck mark
Double-Check Your Formulas
check mark
Understanding Number Formats
lesson contents
Practice Reading Formulas
Interactive: Formula Flashcards
-Scenarios
Over-Budget Items
Percent-Off Sale
Basketball Team: Player Statistics
Movie Tickets
Interactive: Pizza Party Panic
Interactive: Birthday Budget Blues
Using the IF Function
Using CONCATENATE to Combine Names
Buying a Printer: Cost Comparison
-Advanced Scenario: Create an Invoice
Invoice, Part 1: Free Shipping
Invoice, Part 2: Using VLOOKUP
Invoice, Part 3: Fix Broken VLOOKUP
Invoice, Part 4: More Shipping Options
Invoice, Part 5: Data Validation