Please choose between the following three options for navigation.
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.
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.
Additional options and pricing may be available. See pricing and registration for more details.
Follow along with extensive course resources, ebooks, and examples to enhance your learning experience — and they are yours to keep.
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
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
Conclusion Final Quiz
Member Development and Support
May 28, 2018
The rapidly evolving pace of technology is changing how we do business. Come together with technology investment decision-makers to develop strategic solutions and explore what the future holds.
October 1, 2018
The ONE is Canada’s must-attend, multi-track CPA event of the year. Stay at the top of your game with future-focused sessions, thought-provoking keynotes, prime networking opportunities and a first-class exhibition floor.
This event has multiple dates and locations. See event details for more information.
Attend the Public Sector Accounting Discussion Group meeting in-person or virtually via livestream. Virtual observers will be able to see and hear the discussion in real time along with those attending in person.