Table of contents

Return To Event Page
This is the agenda for Introduction
Introduction
This is the agenda for Logic Functions
Logic Functions
 
What we will cover

Logic Functions

Exploring Customer Reward Plans

Using AND( ), OR( ) and IF( ) - Part 1

Using AND( ), OR( ) and IF( ) - Part 2

What Have We Done

This is the agenda for Reference Functions
Reference Functions
 
Reference Functions

This is the agenda for Lookup Functions - CHOOSE( )
Lookup Functions - CHOOSE( )
 
Ranges and the CHOOSE() Function

The CHOOSE() Function

Lookup Functions

What Have We Done

This is the agenda for Lookup Functions - VLOOKUP( ): Approximate Matches
Lookup Functions - VLOOKUP( ): Approximate Matches
 
The VLOOKUP( ) Function

VLOOKUP( ) Approximate Matches

Using Approximate Matches - Part 1

Using Approximate Matches - Part 2

What Have We Done

This is the agenda for Lookup Functions -VLOOKUP(): Exact Matches
Lookup Functions -VLOOKUP(): Exact Matches
 
VLOOKUP(): Exact Matches

Using Exact Matches

Dealing with #N/A Errors

Using IFERROR()

What Have We Done

This is the agenda for Lookup Functions - MATCH( ) and INDEX( )
Lookup Functions - MATCH( ) and INDEX( )
 
The INDEX() Function

The MATCH() Function

Using MATCH() and INDEX() - Part 1

Using MATCH() and INDEX() - Part 2

Using MATCH() and INDEX() - Part 3

Dealing with Errors

What Have We Done

This is the agenda for Conclusion
Conclusion
 
In Review

Conclusion

Final Quiz