OBJECTIVES

After completing these classes, students will be able to:

• Select cells and ranges in Excel
• Format cells as date, percentage, currency, etc.
• Format fonts
• Format alignment
• Rotate cell contents
• Insert formulas and functions into an Excel worksheet
• Use Min, Max, Average and Sum functions
• Use the IF function to make decisions
• Understand absolute versus relative cell referencing
• Use conditional formatting
• Use Precedence correctly (PEMDAS)
• Navigate an Excel worksheet
• Format Cells, Rows and Columns
• Insert and delete Rows, Columns and Worksheets
• Use Page Setup to print headers on multiple pages
• Use Page Setup to print gridlines
• Use Page Setup to center worksheets, align margins, and change to landscape mode
• Use cut, copy and paste commands
• Use the Autofill option
• Use the Find/Replace command
• Create and format charts
• Add headers and footers to worksheets
• Insert dates, page numbers, clipart, page breaks, etc.
• Use templates

lmayer@elgin.edu