logo
MICROSOFT IT ACADEMY AT WSU

Excel 2010 - Interactive Guide

Make the switch to Excel 2010

Do you already know how to use Microsoft Excel? Are you making the switch to Excel 2010 from Excel 2003 or earlier? If so, you’ve come to the right place to get familiar with the new version and to see how to do everyday tasks.

Level: Intermediate
Length: 30-45 minutes

Get to know Excel 2010: Create your first spreadsheet

Are you new to Excel? If so, learn how to create a spreadsheet, to do basic math in Excel, to add and delete columns and rows, to keep column titles in sight as you scroll, and to prepare a spreadsheet for printing.

Level: Beginning
Length: 40-50 minutes


Get to know Excel 2010: Create formulas

Learn how to use formulas to do basic math in Excel, how to make formula results update automatically, and how to use predefined formulas called functions that do things like calculate the amount of monthly payments.

Level: Beginning
Length: 35-45 minutes

vLookup: What it is and how to use it

Learn how to use VLOOKUP to look up a value you want to find in an Excel list or table. Using VLOOKUP is similar to looking up a person’s name in a telephone book to get a telephone number. VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.

Level: Intermediate
Length: 30-40 minutes