close
search
search
menu
Topics
close
I want to...
Get started with computers
Learn Microsoft Office
Apply for a job
Improve my work skills
Design nice-looking docs
More...
Microsoft
Office 2019
|
2016
|
2013
Word
Excel
PowerPoint
Access
Excel Formulas
More...
Basic Skills
Computers
Smartphones & Tablets
Typing Tutorial
Windows
More...
Internet Skills
Internet
Online Safety
Social Media
Email
Search Better
More...
Google
Gmail
Google Docs
Google Sheets
More...
Work & Career
Career Planning
Resume Writing
Cover Letters
Job Search and Networking
Business Communication
More...
Skills for Today
Adapting to Change
3D Printing
Wearables
Freelance Work
Personal Finance
Sharing Economy
Decision-Making
More...
Creativity & Design
Graphic Design
Creativity
Photography
Image Editing
Photoshop
More...
Core Skills
Math
Reading
Grammar
Language Learning
More...
For Educators
Translations
Staff Picks
All Topics
English
expand_more
expand_less
English
expand_more
expand_less
Español
Português
search
menu
All Topics
My Account
About Us
FAQ
Contact Us
EN
ES
PT
search
55e88168166282983499813a
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.