Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Master Microsoft Excel.
Become an Excel expert by learning through interactive tutorials and simulation-based exercises with this advanced, online course. You will learn advanced formatting and formulas, and how to analyze data. The course also explores macros, and teaches you how to use PivotCharts and PivotTables. Enhancements for 2019 include an improved Power Query tool, the use of JavaScript to build custom functions and the ability to personalize the default PivotTable template.
Key Takeaways
By the end of the course, you will be able to:
- Enable, create, modify and copy macros.
- Create PivotCharts including adding options, styles and drill down data.
- Create PivotTables including adding fields, modifying calculations, and using functions and filters.
- Apply advanced formatting to customize and manage conditional formatting, work with international currency and formats, create custom themes, apply form controls and colour formats, and save form templates.
- Enable advanced formulas including IF function, nested functions, AND OR and NOT functions, SUMIF, AVERAGE IF and COUNTIF functions, VLOOKUP, INDEX and MATCH, UPPER LOWER AND PROPER, and RIGHT LEFT and MID formula calculation options.
- Troubleshoot, evaluate and correct formula errors.
- Analyze and consolidate data.
Who Will Benefit
Business professionals with an excellent understanding of Microsoft Excel looking improve productivity and functionality when managing and working with data.
Disclaimer
Most of CPA Ontario's 450+ on-demand courses are compatible with the mobile app. Unfortunately, this on demand course is not compatible. For the best learning experience, we suggest you use your computer.
How to Access the Course
To access your course, visit the CPA Ontario Blackboard site and sign in using the same username and password used for the Registration Portal. You can also access your course through the Blackboard Learn app (iOS or Android).
Important: Course access begins on the date of purchase and remains available for the Access Time specified for the course under Dates and Location. Please review the access time before purchasing. Note that it may take up to 15 minutes after registration for the course to appear in Blackboard.
Registration, cancellation, withdrawal, and other CPA Ontario PD policies can be found here.
Speaker(s)
This online, interactive training course is presented by CustomGuide, North America’s trusted provider of simulation-based learning for Microsoft products.