| Course |
Excel
Intermediate - More on Formulas and Functions |
| Length |
Three
hours |
| Audience |
This course is for those people who have mastered Excel on at least
an introductory level and need to create larger, more complex worksheets.
Learn about range names and how to use them in formulas. Discover
how to link data from one sheet to other sheets using 3-D and array
formulas. Learn to use the functions NOW, IF, PMT and VLOOKUP. Understand
formula errors and how to fix them. |
| Prerequisites |
Windows Basics, Excel Basics and Formula Building or comparable
experience. (Participants must be proficient in Excel on at least
an introductory level.) |
| Topics
|
Module 1: Range Names
- Creating
range names
- Using range
names in formulas
- Making changes
to range names
|
|
|
Module 2: Functions
- Review of
common functions SUM, AVERAGE, MIN, MAX, COUNT
- NOW and TODAY
- PMT
- IF
- VLOOKUP
- Nested Functions
|
|
|
Module 3: Array and 3-D Formulas
- Working with
multiple sheet data
- Linking data
from multiple sheets with 3-D formulas
- Linking data
from multiple sheets with array formulas
|
|
|
Module 4: Errors in Formulas
|
