Sound Advice

Excel 2010: Applying Formulas and Functions


Intermediate Excel Objectives

In this lesson, you will learn how to:

1. Create a Lookup Table

2. Name the Lookup Table

3. Use a VLookup Table in a Formula

4. Use an HLookup Table in a Formula

5. Use Logical Functions: IF, AND, OR, NOT

6. Use a Logical Function to find an error: IFERROR