Please choose between the following three options for navigation.
Discover how to make professional and visually appealing data visualizations in Excel that effectively tell a story and capture your readers’ attention.
The right data visualizations can transform financial statements from boring to brilliant. This online course reveals the techniques you need to create dynamic, eye-catching charts that suit a wide range of financial information. By learning to present financial data in more compelling ways, you will add incredible value to your work and be able to better serve your accounting clients or organization.
Additional options and pricing may be available. See pricing and registration for more details.
Displaying information using heat bars
• What We Will Cover• Data Visualization Overview• Conditional Formatting Tools• Creating Heat Maps with Conditional Formatting• Customizing Conditional Formatting• What Have We Done
Displaying information using data bars
• Visualizing Variances and Trends - Part 1• Visualizing Variances and Trends - Part 2• What Have We Done
Displaying information using icon sets
• Identifying Key Values - Part 1• Identifying Key Values - Part 2• What Have We Done
• Creating Customer Upload Fields• Creating Spark Lines• Using Formulas for Data Visualization - Part 1• Using Formulas for Data Visualization - Part 2• Creating Charts with Conditional Formatting - Part 1• Creating Charts with Conditional Formatting - Part 2• What Have We Done
Charts in Excel
• Built-in Chart Types• Custom Chart Types• Choosing a Chart Type• Considerations for Charting• Building an Effective Chart - Part 1• Building an Effective Chart - Part 2• Building an Effective Chart - Part 3• What Have We Done
Multiple column charts
• Multiple Column Charts - Part 1• Multiple Column Charts - Part 2• What Have We Done
• In Review • Conclusion • Final Quiz
Gain the fundamental information and tools needed to master making spreadsheets in Excel.
Learn how to create effective tabular data sets in Excel so that you can better organize and analyze financial information.
Learn how to use Excel to create interesting and impactful financial reports.
Member Development and Support
November 22, 2018
CPA Canada’s annual financial literacy conference is a must-attend for those who want to learn how to improve the financial health of Canadians.
October 1, 2018
The ONE is Canada’s must-attend, multi-track CPA event of the year. Stay at the top of your game with future-focused sessions, thought-provoking keynotes, prime networking opportunities and a first-class exhibition floor.
October 15, 2018
Stay up-to-date on critical indirect tax issues and network with other indirect tax professionals at Canada’s largest and longest-running indirect tax event.