Unit 12: E5 Organizing Large Worksheets
Duration of Days: 7
Students will learn how to effectively manage worksheets containing large amounts of data. You will use some exciting Excel tools to organize and view data, perform calculations, and restrict data entry.
- Create a template
- Start a workbook from a template
- Change worksheet view options
- Sort and filter data
- Create IF functions
- Apply data validation rules
- Use the Scale to Fit printing options
- Create and modify tables
Students will effectively manage worksheets containing large amounts of data. Projects to be created in this unit are:
- R1-R2-DonorList
- A1-A2-ExpensesQ3
- R3-StudentHours
- A3-Feedback
| Lesson # | Lesson Title | Duration of Days |
|---|