Unit 13: E7 - Date Functions and Conditional Formatting

Students will use a variety of methods to work with an important type of data in Excel: date and time information. Dates provide useful information for all kinds of data, such as when customer invoices are due and when payments were made, or recording company expenses, schedules, and reports. You will also explore creating and customizing conditional formatting rules to gain valuable insight into the data in your worksheet.

-Identify date serial numbers
-Apply custom date formatting
-Enter times
-Create functions using dates
-Perform date and time calculations
-Create customized conditional formatting rules
-Edit rules using the Conditional Formatting Rules Manager

Students will demonstrate learning by completing the following projects:

• R1-R2-FunRun
• A1-A2-Expenses
• R3-Donors
• A3-ClientEvents