| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Excel 2007: Advanced Functions and List Management (Half-Day) |
| Course Number: APH0009 |
| Category: Business & Office Applications |
| Duration: 0.50 days |
Description
This half-day course builds on the skills and concepts taught in the Excel 2007 Introduction half-day course. Participants will work with advanced formulas and lookup functions such as VLOOKUP, MATCH, and INDEX. Participants will also learn about data validation and database functions such as DSUM.
Outline
- Unit 1: Advanced functions
- Topic A: Logical functions
- A-1: Using the IF function
- A-2: Using OR, AND, and NOT as nested functions
- A-3: Using nested IF functions
- A-4: Using the IFERROR function
- Topic B: Math and statistical functions
- B-1: Using SUMIF
- B-2: Using COUNTIF
- B-3: Using AVERAGEIF
- B-4: Using SUMIFS, COUNTIFS, and AVERAGEIFS
- B-5: Using ROUND
- Topic C: Financial functions
- C-1: Using the PMT function
- Topic D: Displaying and printing formulas
- D-1: Showing, printing, and hiding formulas
- Topic A: Logical functions
- Unit 2: Lookups and data tables
- Topic A: Using lookup functions
- A-1: Examining VLOOKUP
- A-2: Using VLOOKUP to find an exact match
- A-3: Using VLOOKUP to find an approximate match
- A-4: Using HLOOKUP for exact matches
- A-5: Using HLOOKUP for approximate matches
- Topic B: Using MATCH and INDEX
- B-1: Using the MATCH function
- B-2: Using the INDEX function
- Topic C: Creating data tables
- C-1: Creating a one-variable data table
- C-2: Creating a two-variable data table
- Topic A: Using lookup functions
- Unit 3: Advanced list management
- Topic A: Validating cell entries
- A-1: Observing data validation
- A-2: Setting up data validation
- Topic B: Exploring database functions
- B-1: Examining the structure of database functions
- B-2: Using the DSUM function
- Topic A: Validating cell entries