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.
The authority to decide what learning program constitutes acceptable CPD and evidence of CPD hours to meet regulatory requirements remains solely with your provincial or regional CPA body
NOTE: You will receive an email within the next hour with your log-in access to the CPA Canada online learning environment (D2L) at: https://education.cpacanada.ca. Check and ensure you have access to the D2L platform.
If you do not receive this email, please email D2Lsupport@cpacanada.ca or contact the helpdesk portal at https://cpacanada.service-now.com/support
Due to the online availability of the course materials, no refunds will be processed once the registrant has accessed these materials.
Terms and Conditions | Privacy Policy | Shipping and Store Policies | AODA | Anti-Harassment Policy | Advocacy | Vulnerability Disclosure
Help Desk: Mon-Fri, 9am-5pm ET | 1-866-256-6842 | Contact us
© 2001-2023, CPA Canada | EYEP. All rights reserved.