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

Highlights

Chartered Professional Accountants of Canada (CPA Canada) annually offers its views on priorities for the federal budget. Review past submissions of pre-budget briefs and consultations, and post-budget release opinions and commentary.

Our Firm Directory allows you to search for Canadian CPA firms using our interactive map as well as other criteria.

Jointly presented by CPA Canada and CPA Ontario, The ONE is the must-attend, multi-track event of the year, designed for all CPAs who want to be at the top of their game.