About This Tutorial ✓

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

Simple Formulas ✓

Learn all about creating simple formulas.

Complex Formulas ✓

Learn all about creating complex formulas.

Relative and Absolute Cell References ✓

Learn how relative and absolute cell references work.

Functions ✓

Learn all about using functions.

Solving Real-Life Problems in Excel ✓

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

Double-Check Your Formulas ✓

Learn the importance of always double-checking your formulas.

Understanding Number Formats ✓

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

Practice Reading Formulas ✓

Get practice reading formulas.

Interactive: Formula Flashcards ✓

Use this interactive to practice an Excel formula.

Over-Budget Items ✓

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

Percent-Off Sale ✓

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

Basketball Team: Player Statistics ✓

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

Movie Tickets ✓

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

Interactive: Pizza Party Panic ✓

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

Interactive: Birthday Budget Blues ✓

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

Using the IF Function ✓

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

Using CONCATENATE to Combine Names ✓

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

Buying a Printer: Cost Comparison ✓

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

Invoice, Part 1: Free Shipping ✓

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

Invoice, Part 2: Using VLOOKUP ✓

Use the VLOOKUP function to help process invoices.

Invoice, Part 3: Fix Broken VLOOKUP ✓

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

Invoice, Part 4: More Shipping Options ✓

Use the VLOOKUP function to determine new shipping options.

Invoice, Part 5: Data Validation ✓

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