Microsoft Excel 202 Tutorial Outline

0. INTRODUCTION
Objectives
Pre-Requisites

1. REVIEW AND SHEET SETUP
Reconstruct Student Gradebook
Short review of important concepts

2. NAMED CELLS
Defining a named range
Insert, Name, Define
Refers To Box
Using the Name Box
Naming the PassingGrade cell
Jumping to a named cell
Using the named cell in functions
Collapse Dialog
Expand Dialog
Valid names for cells

3. NAMED RANGES, PART ONE
Defining a named range
Pasting a named cell or range
Insert, Name, Paste
Using named ranges in formulas
Jumping to named ranges
Range Intersections

4. NAMED RANGES, PART TWO
Deleting a named range or cell
Editing a named range or cell
Pasting a list of your named ranges
Paste List
Creating names based on your headers
Insert, Name, Create
Applying names to existing ranges
Insert, Name, Apply

5. NESTED IF FUNCTIONS
What is a Nested IF function
Using the COUNT function
Checking multiple conditions
Giving our students an Incomplete
Giving a letter grade using nested IFs

6. VLOOKUP, PART ONE
Creating a subtable (lookup table)
Grade values lookup table
Using VLOOKUP to return the letter grade
Using VLOOKUP to return a commission rate

7. VLOOKUP, PART TWO
Expanding our lookup table to three columns
Using VLOOKUP to return multiple columns
Creating a basic invoice using Excel
Using HLOOKUP to calculate a discount
Using the Function Wizard for HLOOKUP

8. REVIEW
Review Topics