Excel Formulas

Introduction

• 1

  About This Tutorial

Formula and Function Basics

• 2

  Simple Formulas

  

  • Introduction

  • To create a formula:

  • Challenge!

  

  • Simple Formulas

    Learn how to create simple formulas in Excel.

    03:1311,401 views
• 3

  Complex Formulas

  

  • Introduction

  • Challenge!

  

  • Complex Formulas

    Learn to use the order of operations to create complex formulas.

    05:106,152 views
• 4

  Relative and Absolute Cell References

  

  • Introduction

  • Absolute references

  • Using cell references with multiple worksheets

  • Challenge!

  

  • Cell References

    Explore absolute and relative cell references, and the way they can affect formulas.

    05:267,595 views
• 5

  Functions

  

  • Introduction

  • Using functions

  • Working with unfamiliar functions

  • Other common functions

  

  • Functions

    An introduction to functions, including AUTOSUM, the Function Library, and more.

    05:177,680 views

Formula Tips

• 6

  Solving Real-Life Problems in Excel

  

  • Solving Real-Life Problems in Excel

    Learn how to turn real-life problems into formulas.

    04:195,037 views
• 7

  Double-Check Your Formulas

• 8

  Understanding Number Formats

  

  • What are number formats?

  • Using number formats correctly

  • Date formats

  • Number-formatting tips

• 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

Learn More

• Excel 2013

• Microsoft Office

• Google Sheets

• Math