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

Financial Functions

EQ – How do I use Financial Functions in Excel?

1. Activator:  Find a Used Car
1. Description
2. Features
3. Cost
4. Advantages
5. Disadvantages
2. How much is it going to Cost Us?
1. Rate
2. Nper
3. PV
4. FV
5. Type
3. Calculate?
4. Intro to Payment Function - Click Here 
5. Examples In Action (Mortgage, Credit Card Debt)
6. Try It Out

More If Statement Fun

EQ - How are nested if statements used and why are they necessary?

1. If Statement Hot Seat
2. Quick Refresher
3. Lunch/Community Reading
4. Intro to Nested If Statements Assistance
5. Try it out