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

EQ - How do I use a Web Query?

1. Activator: Stock Market Talk
2. Laying the Foundation (EX82-EX126)
3. Lunch
4. Conditional Formatting
5. Intro to Web Queries
6. Applying to our Project
7. Stock Market Project

Job 121 - Custom Sort

EQ - What is the process for customizing the sort feature of MS Excel?

1. Recap of Substitute Lessons
2. A closer look at Job 121
3. Demo - Custom Sort
4. Together - Job 121

EQ - How do I use a Web Query?

1. Activator: Stock Market Talk
2. Laying the Foundation (EX82-EX126)

Refreshing the Sort Function (Tuesday)

EQ - How do I analyze a worksheet using the sort function?

1. Complete the following tasks
1. Handout 1 - Use Functions; Sort
2. Job 114 - Create and Sort a Database
3. Corresponding Questionnaire - Sorting and Filtering a Worksheet
4. European Vacation Budget

**Please remember to complete community reading immediately following lunch**
(One student may pick up the Wall Street Journal newspapers from the office)