Data Validation

EQ - How is data validation applied?

1. Work with a partner to complete the advanced organizer. The information to complete the organizer is found here --> DATA VALIDATION LEARNING MODULE
2. Use the data validation process on their last saved Excel Workbook “Salary Table”.
3. Save as Salary Table.
   
   

Data Validation

EQ - How is data validation applied?

1. Q&A
2. VLookup Quiz
3. Community Reading/Lunch
4. Activator: Error Messages
5. Advanced Organizer
6. Data Validation Learning Module
7. Budget Activity

VLookup

EQ - How is the VLookup Function important and how is it used?

1. Activator: VLookup Video
2. Advanced Organizer
3. Demo - VLookup Example
4. ABC Investment Company (Using Lookup Tables)
5. Excel Challenge - XYZ Company

Summarize Data Using Subtotals

EQ - How can I summarize data using subtotals?

1. Learning Module Review
2. Complete the Module
3. Lunch/Community Reading
4. Introduction to Data Subtotals
5. Demonstration
6. Practice

Applying The Payment Function

EQ - How can the Payment Function be used to complete financial analysis?

1. Hotseat Review
2. Payment Quiz
3. Learning Module