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.
Length: 30-45 minutes
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.
Length: 40-50 minutes
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.
Length: 35-45 minutes
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.
Length: 30-40 minutes