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 cell styles to format
• Use Page Setup to print headers on multiple pages
• Use Page Setup to print gridlines
• Use Page Setup to center worksheets, align margins, 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.

Challenge Yourself Skills:

• Use templates
• Use PMT function (and other functions) correctly
• Use Goal seek
• Create Pivot Tables

In-Class assignments:

• Sunny Day Pizza - page 451
• Car Loan - Page 487
• Payroll
• Grades

On-Your-Own Assignment:

• Semi-Annual Sales

lmayer@elgin.edu