Introduction

• 1

  About This Tutorial ✓

  Learn more about using formulas and functions in Excel or another spreadsheet application.

Formula and Function Basics

• 2

  Simple Formulas ✓

  Learn all about creating simple formulas.

• 3

  Complex Formulas ✓

  Learn all about creating complex formulas.

• 4

  Relative and Absolute Cell References ✓

  Learn how relative and absolute cell references work.

• 5

  Functions ✓

  Learn all about using functions.

Formula Tips

• 6

  Solving Real-Life Problems in Excel ✓

  Learn about solving real-life problems using Excel and other spreadsheet applications.

• 7

  Double-Check Your Formulas ✓

  Learn the importance of always double-checking your formulas.

• 8

  Understanding Number Formats ✓

  Better understand number formats so you can use them properly in your spreadsheet.

• 9

  Practice Reading Formulas ✓

  Get practice reading formulas.

• 10

  Interactive: Formula Flashcards ✓

  Use this interactive to practice an Excel formula.

Scenarios

• 11

  Over-Budget Items ✓

  Use a formula to determine which expenses are over budget in this interactive.

• 12

  Percent-Off Sale ✓

  Use a formula to determine how much everything will cost after a discount in this interactive.

• 13

  Basketball Team: Player Statistics ✓

  Use a formula to determine who scored the most points overall in this interactive.

• 14

  Movie Tickets ✓

  Use a formula to determine how much is left over after buying movie tickets for 4 in this interactive.

• 15

  Interactive: Pizza Party Panic ✓

  Use a formula to determine how much pizza is needed for a party in this interactive.

• 16

  Interactive: Birthday Budget Blues ✓

  Use a formula to determine how much a birthday party will cost in this interactive.

• 17

  Using the IF Function ✓

  Use the IF function to help solve this real-world problem.

• 18

  Using CONCATENATE to Combine Names ✓

  Use the CONCATENATE function to practice combining names in your spreadsheet.

• 19

  Buying a Printer: Cost Comparison ✓

  Use a formula to determine which printer is best in this interactive.

Advanced Scenario: Create an Invoice

• 20

  Invoice, Part 1: Free Shipping ✓

  Use a formula to determine free shipping if the subtotal is less than $100 for a particular order.

• 21

  Invoice, Part 2: Using VLOOKUP ✓

  Use the VLOOKUP function to help process invoices.

• 22

  Invoice, Part 3: Fix Broken VLOOKUP ✓

  Fix a broken VLOOKUP function someone else created to help pull in new data correctly.

• 23

  Invoice, Part 4: More Shipping Options ✓

  Use the VLOOKUP function to determine new shipping options.

• 24

  Invoice, Part 5: Data Validation ✓

  Use data validation to help solve a real-world shipping problem.