Course Content

Lesson 1: Working with Multiple Worksheets and Workbooks

1. Creating Linked Formulas
2. Using 3-D References
3. Consolidating Information by Position or Category
4. Viewing Multiple Worksheets
5. Viewing Worksheets in Different Workbooks
6. Using Absolute Cell References
7. Creating Linked Formulas between Workbooks

Lesson 2: Understanding Functions

1. Creating and Using Absolute Named Ranges
2. Creating a Relative Named Range
3. Working with Functions, Insert Function

Lesson 3: Working with Financial and Date Functions

1. Using Financial Functions
2. Using Date Functions
3. Working with Auditing and Error Checking Tools

Lesson 4: Working with Logical Functions

1. Using the IF Function
2. Nesting Functions
3. Using Multiple Conditions with the IF Function
4. Nesting IF Functions

Lesson 5: Working with Lookup and Reference Functions

1. Using HLOOKUP and VLOOKUP Functions
2. Using the MATCH Function
3. Using the INDEX Function
4. Nesting the INDEX and MATCH Functions
5. Using INDEX MATCH MATCH
6. Using INDEX MATCH & MATCH