Excel Formulas

Introduction

• 1

  About This Tutorial arrow_forward_ios ✓ Learn more about using formulas and functions in Excel or another spreadsheet application.

Formula and Function Basics

• 2

  Simple Formulas arrow_forward_ios ✓ Learn all about creating simple formulas.
• 3

  Complex Formulas arrow_forward_ios ✓ Learn all about creating complex formulas.
• 4

  Relative and Absolute Cell References arrow_forward_ios ✓ Learn how relative and absolute cell references work.
• 5

  Functions arrow_forward_ios ✓ Learn all about using functions.

Formula Tips

• 6

  Solving Real-Life Problems in Excel arrow_forward_ios ✓ Learn about solving real-life problems using Excel and other spreadsheet applications.
• 7

  Double-Check Your Formulas arrow_forward_ios ✓ Learn the importance of always double-checking your formulas.
• 8

  Understanding Number Formats arrow_forward_ios ✓ Better understand number formats so you can use them properly in your spreadsheet.
• 9

  Practice Reading Formulas arrow_forward_ios ✓ Get practice reading formulas.
• 10

  Interactive: Formula Flashcards arrow_forward_ios ✓ Use this interactive to practice an Excel formula.

Scenarios

• 11

  Over-Budget Items arrow_forward_ios ✓ Use a formula to determine which expenses are over budget in this interactive.
• 12

  Percent-Off Sale arrow_forward_ios ✓ Use a formula to determine how much everything will cost after a discount in this interactive.
• 13

  Basketball Team: Player Statistics arrow_forward_ios ✓ Use a formula to determine who scored the most points overall in this interactive.
• 14

  Movie Tickets arrow_forward_ios ✓ Use a formula to determine how much is left over after buying movie tickets for 4 in this interactive.
• 15

  Interactive: Pizza Party Panic arrow_forward_ios ✓ Use a formula to determine how much pizza is needed for a party in this interactive.
• 16

  Interactive: Birthday Budget Blues arrow_forward_ios ✓ Use a formula to determine how much a birthday party will cost in this interactive.
• 17

  Using the IF Function arrow_forward_ios ✓ Use the IF function to help solve this real-world problem.
• 18

  Using CONCATENATE to Combine Names arrow_forward_ios ✓ Use the CONCATENATE function to practice combining names in your spreadsheet.
• 19

  Buying a Printer: Cost Comparison arrow_forward_ios ✓ Use a formula to determine which printer is best in this interactive.

Advanced Scenario: Create an Invoice

• 20

  Invoice, Part 1: Free Shipping arrow_forward_ios ✓ Use a formula to determine free shipping if the subtotal is less than $100 for a particular order.
• 21

  Invoice, Part 2: Using VLOOKUP arrow_forward_ios ✓ Use the VLOOKUP function to help process invoices.
• 22

  Invoice, Part 3: Fix Broken VLOOKUP arrow_forward_ios ✓ Fix a broken VLOOKUP function someone else created to help pull in new data correctly.
• 23

  Invoice, Part 4: More Shipping Options arrow_forward_ios ✓ Use the VLOOKUP function to determine new shipping options.
• 24

  Invoice, Part 5: Data Validation arrow_forward_ios ✓ Use data validation to help solve a real-world shipping problem.

Quiz

• 25

  Excel Formulas Quiz arrow_forward_ios ✓ Test your knowledge of Excel formulas by taking our quiz.