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

Our Firm Directory allows you to search for Canadian CPA firms using our interactive map as well as other criteria.

Jointly presented by CPA Canada and CPA Ontario, The ONE is the must-attend, multi-track event of the year, designed for all CPAs who want to be at the top of their game.