Lab Activity 1: Track elapsed time
Experiment with cell formats and dates
Use the Now function to keep the current date in a worksheet
Create formulas to calculate elapsed time
Use the Workday function to calculate project due dates

Lab Activity 2: Get the information you need from your Excel list
Use the Dsum function
Use the Dcount function
Use the Sumif function
Use the If function
Apply filters

Lab Activity 3: Simplify statistical analysis with functions
Use the Average, Median, and Mode functions
Use the Stdev function
Find highs and lows with the Max and Min functions
Count items in a list
Apply filters to a list

Lab Activity 4: Apply error-handling and auditing techniques
Use the Iserror function
Nest the Iserror function within the If function
Use Excel’s auditing features

Target student: Students participating in this Lab should be educated Excel worksheet users who are familiar with:

•  Creating and saving a worksheet.
• Opening an existing worksheet and using simple editing techniques.
• Creating formulas by using some of Excel’s basic built-in functions, including Sum and Average.
• Navigating and selecting ranges in a worksheet.
• Changing the appearance of data using formatting techniques.
• Moving and copying formulas and other data.