Dates and location
Hours
Dates and location
Hours
Description
Welcome to the “Data Analysis with Excel” course, which provides quick instructions on the most useful functions and formulas for analyzing data in Microsoft’s Excel. This course, comprising 15 lessons, covers functions including VLOOKUP, HLOOKUP, MATCH, INDEX, and more. Viewers will also learn about various aspects of data analysis in Excel, such as formatting data properly, conditional formatting, and how to accommodate changing or updated data. This course is perfect for any professional looking to excel with their Excel-based analysis!
Note: Retired members eligible to receive free PD should be aware that this course does not qualify.
Unlock learning anytime, anywhere with the Blackboard Learn app
Seamlessly access your on demand courses, assignments, and get PD hours on the go. Learn how to download now and elevate your education experience with the convenience of mobile learning.
Key Takeaways
By the end of this course, you will learn:
- How to format data.
- Data analysis tips.
- How to use functions including HLOOKUP, VLOOKUP, MATCH & INDEX.
- How to use MATCH with VLOOKUP.
Who Will Benefit
Professionals who want to enhance their excel skills.
How to Access the Course
This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.
However, you will only have access to the course for 90 days after REGISTRATION.
New mobile learning! Download Blackboard Learn from your app store (iOS or Android). Learn more.
To access the course on your computer please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
This course is presented by BizLibrary. At BizLibrary, we’re on a mission to elevate employees’ skills, create better places to work, and do our part to build a more compassionate and competent future. We lean into these goals every day by supporting organizations’ learning and development needs through our innovative platforms and best-in-class content.