Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Excel is a powerful tool to process and analyze business data. To unleash that power, attendees will learn not only those individual Excel functions, but also learn how to combine functions together logically to create nested formulas to solve complex problems.
This hands-on course is designed to help attendees to learn and use the most needed, important, and essential advanced Excel functions to work effectively and efficiently in a business environment. Attendees will be guided step by step, from using simple functions to complex nested formula hands-on. Attendees will combine various advanced functions to plan business activities and solve complex business problems.
Schedule
- March 3, 2025, 9:00 a.m. - 1:00 p.m.
- March 4, 2025, 9:00 a.m. - 1:00 p.m.
- March 5, 2025, 9:00 a.m. - 1:00 p.m.
- March 6, 2025, 9:00 a.m. - 1:00 p.m.
Key Takeaways
Upon completion of this course, you will learn:
- VLOOKUP to look up with one or multiple criteria INDEX and MATCH to look up and match one specific value or a range of values SUMIFS and COUNTIFS based on exact or partial matching criteria.
- Multiple layers of IF function and IF with multiple criteria Logical combination of LEFT, RIGHT, MID, LEN, SEARCH, SUBSTITUTE to manipulate text.
- The thought process and strategy to write complex multiple layers nested formula.
Who Will Benefit
This course is designed for people who already have basic level Excel skills to process and analyze large volume of data with functions/formulas effectively and efficiently.
How to Access the Course
This CPA Ontario course is a live webinar. You must attend the live course to receive verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time. To get the full experience of this interactive course, use a computer with video and microphone capabilities.
Electronic material can be accessed one week prior to the course and should be downloaded in advance.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Steve Huang, is the Excel instructor at Super Excel Inc. with over 10 years of experience teaching individuals and corporations in Toronto. As a former senior analyst, he is able to simplify complex Excel concepts and teach them in a clear, concise, easy-to-understand, and engaging way. Attendees quickly master practical, real-life Excel skills, enhancing their capabilities and productivity at work.