Click Here to Get Started
Intermediate Excel
Set Up a Timesheet
page 2
Calculate the
Total page 4
Create a Reference List
page 10
Make a Drop-Down
List page 13
Use Conditional Formatting page 15
Merge and
Center Cells page 17
Activity:
Create a time sheet that uses a reference list for
a drop down list. Use Conditional Formatting to highlight the overtime