By the end of the Excel exercises and videos each student will be able to ...

Skills introduced in Excel Basics (pg 2-7)

• Specify a cell address using its row and column
• Determine the active cell in a spreadsheet
• Use the tab key to move right in a spreadsheet
• Use the name box on a sheet
• Create a new workbook
• Create a valid formula
• Add or remove decimal precision from a number
• Use the sum formula to compute a total
• Use the fill handle to copy a formula
• Resize columns
• Center text in a cell
• Format cells as currency
• Add and remove columns and rows
• Add and remove a spreadsheet to a workbook
• Rename a sheet
• Freeze the top row of a spreadsheet so you can always see column titles

Skills introduced in Absolute and Relative References

• Contrast the terms "relative reference" and "absolute reference"
• Use relative and absolute references
• Recognize a mixed reference

Skills introduced in class/exercises

• Merge cells
• Sort data
• Use an IF function in a formula
• Specify a cell range using ":"