Introduction to data visualization

This is the agenda for Table of Contents
Table of Contents
 
Introduction

Welcome

 
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

 
In-cell charting

• 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

 
Conclusion

• In Review
• Conclusion
• Final Quiz

Highlights

Canada is celebrating its 150th anniversary. We’re celebrating you, Canadian CPAs. Tell us why you’re proud to be a Canadian CPA. Then watch for our big celebration in July.

Gain practical organizational insights and learn from industry experts at this annual event for not-for-profit financial leaders.