Excel formulas and functions: Logic and lookups

Learn the purpose of logic and reference functions, and how to use them. Take a deep dive into lookup functions, including VLOOKUP(), and become a master of Excel functions.

Event Details

Location and date:
Online On-Demand Event

Become a master of Excel functions and receive a free ebook with registration.

Take Excel from a tool that simply reports historical results and configure it to respond dynamically to changes in scenarios and turn your spreadsheets into business intelligence tools.

This course begins with looking at logic functions, from the essential IF() function through a variety of others which can be leveraged at key times. Explore reference functions that allow you to pull information from different worksheet cells as required.

View Table of Contents

Additional options and pricing may be available. See pricing and registration for more details.



$209.00

3 CPD hour(s)
Pricing & registration

You will learn about:

  • the purpose of logic functions and how to use them in the real world
  • how to create an IF() function and nest AND() and/or OR() functions within
  • reference functions
  • how the CHOOSE(), VLOOKUP(), INDEX(), and MATCH() functions work
  • creating a VLOOKUP() function
  • the difference between approximate and exact matches

Follow along with extensive course resources, ebooks, and examples to enhance your learning experience — and they are yours to keep.

Who should attend?

  • advanced Excel users
  • IT professionals
  • business intelligence educators
  • consultants
  • financial analysts

More Details:

Session Descriptions

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

Reference Functions

Ranges and the CHOOSE() Function
The CHOOSE() Function

Lookup Functions

What Have We Done

The VLOOKUP( ) Function
VLOOKUP( ) Approximate Matches

Using Approximate Matches - Part 1

Using Approximate Matches - Part 2

What Have We Done

VLOOKUP(): Exact Matches
Using Exact Matches

Dealing with #N/A Errors

Using IFERROR()

What Have We Done

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

In Review
Conclusion

Final Quiz

Speakers/Presenters

Contacts

Please contact:

CPA Canada Professional Learning and Development Customer Service
Tel: 1-888-337-3242
Email: pld@cpacanada.ca

Highlights

Update your knowledge and strengthen your network at this must-attend conference covering the most important issues and trends affecting audit committee members.

It’s probable that someone you know is deep in debt. If you are observant, you might see one of these seven signs.