Logical and lookup functions in Excel

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 logical functions, from the ISBLANK() 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.

This online video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel certificate program.

*Special Member Pricing will be displayed for CPA Canada members upon login*

CPA Canada partners with external providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access in-person and virtually. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.