PRDV252: Intermediate Excel

Unit 5: Lookup Functions and Review of FunctionsThis unit will introduce the VLOOKUP and HLOOKUP functions as well as
how to create a web query that imports stock prices to your worksheet
from a website.

Unit 5 Time Advisory
Completing this unit should take you approximately 3 hours.

☐ Subunit 5.1: 1 hour

☐ Subunit 5.2: 0.5 hours

☐ Subunit 5.3: 0.25 hours

☐ Subunit 5:4: 1.25 hours

Unit5 Learning Outcomes
Upon successful completion of this unit, you will be able to:
- use the VLOOKUP and HLOOKUP functions;
- create a web query that imports stock price data from a website; and
- use Goal Seek to answer a what-if scenario.

Instructions: Read Chapter 3, Section 3.3: Lookup Functions, which
starts on page 265. You will continue to use the follow-along file
from Unit 4 above (Excel® Text Chapter 3) as you finish this
chapter.

Instructions: Go through the 5 pages, watching the video on page 2.
This review uses the PMT function that you learned in subunit 3.3.
The last page also introduces Scenarios and Data Tables. The class
will not dig any deeper into these tools but you can use Help to
learn more if these are features you would find useful. If you have
Excel® 2010, when you have finished, there is a practice document at
the end of this presentation that you can open and follow the
instructions to practice the skills you learned. If you have an
older version of Excel®, open your version and create the
spreadsheet you see on page 3. Find Goal Seek in your program to
practice what you learned here.

Completing this assignment should take approximately 30 minutes.

Terms of Use: Please respect the copyright and terms of use
displayed on the webpage above.

5.3 Printing Formulas and FunctionsSo now you know a lot about writing formulas in Excel®. If you want to
share your formulas with someone in a printed format, you will need to
be able to see them in the spreadsheet for them to print.

Instructions: Open the accompanying PDF document and follow the
directions to complete the Practice for the skills you just learned.
This file is quite comprehensive and it reviews many of the
functions you learned in Chapters 3-5. Think of it as a test of what
you have learned so far.