Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Expand your knowledge of Microsoft Excel. In this online course you will learn how to take your financial and data analysis to a deeper level through interactive tutorials and simulation-based exercises. Explore intermediate formulas and formatting, charts and tables. You will also learn how to manage data, print and distribute, and collaborate.
Key Takeaways
By the end of the course, you will be able to:
- Use intermediate formulas: cell and range names, absolute and relative references, order of operations as well as display and date formulas.
- Apply intermediate functions: insert cells, CONCATENATE and PMT function, reference external worksheets.
- Use intermediate formatting: cell styles, find and replace, conditional formatting, apply themes.
- Create and work with charts: move and resize, add titles and legends, modify data, create dual-axis charts and sparklines.
- Manage data: flash fill, data validation, outline and subtotal, quick analysis, and importing and exporting data.
- Work with tables: sort and filter data, add rows and columns, modify styles, remove duplicates, and add slicers and structured references.
- Format pages: set print area and page breaks, monitor page size and scale, set margins and orientation and inspect print documents for quality control.
- Edit workbooks and worksheets: share and co-author documents, add cell comments and version history, and protect your worksheets and workbook structure.
Who Will Benefit
Business professionals with little to no knowledge of Microsoft Excel who are responsible for 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
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.