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