Module 10: The IF Function - What it is and how to use it - The IF Function - What it is and how to use it Learning Outcomes

We offer unlimited learning for free. Be a part of our mission.

If you've ever been grateful for your free courses, now is the moment to pass it forward. Every contribution, big or small, helps us keep education free for all.

Continue Learning for Free

Contribute Now

Support us in our mission to keep education free for all.

Pick Your Contribution Amount.

$1

Support 30 learners globally

$5

Support 150 learners globally

$

Support:

Select Contribution Method

Contribution Amount$2

Select Payment Method

Credit/Debit Card

PayPal

Thank you for being part of our mission!

Your contribution has made a difference to learners across the globe.

Continue Learning

Module 10: The IF Function - What it is and how to use it

Module 1: Making the switch to Excel 2010

Making the switch to Excel 2010 Learning Outcomes

Making the switch to Excel 2010

Work with files in the Backstage view

Do the basics on the home tab

Math, Anywhere

Commands when you need them

Keyboard shortcuts

Keep your favorite buttons visible

Work between new and old Excel versions

Making the switch to Excel 2010 Lesson Summary

Module 2: What's new in Excel 2010

What's new in Excel 2010 Learning Outcomes

Access the right tools, at the right time

Backstage view in Excel 2010

Access workbooks in new ways

Make fast, effective comparisons from lists of data

Introduction to Sparklines

Obtain powerful analysis from your desktop

Changes made to functions

Create an Excel table

Create workbooks with more visual impact

Paste with live preview

Collaborate on workbooks in new ways

Collaborate on a worksheet in the browser

Find and fix accessibility issues

Extend workbooks in new ways

What's new in Excel 2010 Lesson Summary

Module 3: Basic Tasks in Excel 2010

Basic Tasks in Excel 2010 Learning Outcomes

What is Excel?

Create, save, print, and apply templates to a workbook

Format numbers in a worksheet

Create an Excel table, formula and chart your data

Filter and sort your data

Basic Tasks in Excel 2010 Lesson Summary

Module 4: Create your first spreadsheet

Create your first spreadsheet Learning Outcomes

Meet the Excel spreadsheet

Do basic math in Excel

Create column titles

Let Excel type for you

Get more(or less) columns, rows, spreadsheets

Keep column titles in sight as you scroll

Prepare to print

Create your first spreadsheet Lesson Summary

Module 5: Create Formulas

Create Formulas Learning Outcomes

Formulas in Excel

Cell references in formulas

The SUM and AVERAGE functions

More about cell references and formulas

More about functions

Create Formulas Lesson Summary

Module 6: VLOOKUP - What it is and when to use it

VLOOKUP - What it is and when to use it Learning Outcomes

What is VLOOKUP

How, and when to use VLOOKUP

Using more than one spreadsheet with VLOOKUP

Using absolute cell references with VLOOKUP

Avoiding VLOOKUP errors

VLOOKUP - What it is and when to use it Lesson Summary

Module 7: Understand Data at a glance with Conditional Formatting

Understand Data at a glance with Conditional Formatting Learning Outcomes

Format cells to make data stand out

Quick formatting

Work with rules

Make your own rules

Understand Data at a glance with Conditional Formatting Lesson Summary

Module 8: Sparklines - Use tiny charts to show data trends

Sparklines - Use tiny charts to show data trends Learning Outcomes

Introduction to Sparklines

Line sparklines

Column sparklines

Win, Loss sparklines

Sparklines - Use tiny charts to show data trends Lesson Summary

Module 9: Use Excel tables to manage information

Use Excel tables to manage information Learning Outcomes

Introduction to tables