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.
Key Takeaways
By the end of the course, you will be able to:
- Create PivotCharts: adding options, styles and drill down data.
- Create PivotTables: add multiple fields and modify calculations; use GETPIVOTDATA function; enable filter, timelines, layout, group values, refresh and format.
- Apply advanced formatting: customize and manage conditional formatting with formulas; work with international currency and formats; create custom themes; apply form controls, colour formats, body and heading options, and save form templates.
- Enable advanced formulas: IF function, nested functions, AND OR and NOT functions, SUMIF, AVERAGE IF and COUNTIF functions, VLOOKUP, HLOOKUP, INDEX and MATCH, UPPER LOWER and PROPER, and RIGHT LEFT and MID formula calculation options.
Who Will Benefit
Business professionals with little to no knowledge of Microsoft Excel who are responsible for managing and working with data.enable, create, modify and copy macros.
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
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.
To access the course 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 online, interactive training course is presented by CustomGuide, North America’s trusted provider of simulation-based learning for Microsoft products.