1.
Readings
Read Lesson
3 in the Intermediate Excel guide, page 83-107.
Watch the video
Project
A spreadsheet that uses Defined Names
in formulas to conditionally summarize data.
Downloads
Employee Data.xlsx
2. Practice
Complete the Practice Activity on page 108.
3.
Assessment
Do the Test Yourself questions on page 108.