Description

In an age now driven by "big data", we need to cut through the noise and present key information in a way that can be quickly consumed and acted upon making data visualization an increasingly important skill. Visualizations need to not only present data in an easy-to-understand and attractive way, but they must also provide context for the data, and tell a story, achieving that fine balance between form and function.

Excel is a commonly used and easily available tool for data analysis and working with data. However, when you think of data visualization, you might not think of Microsoft Excel. However, Excel offers a large number of charts and graphing tools that complement its data analysis toolset. Combining the best of power query and power pivot, Excel can help to create data visualization and dashboard very effectively.

Area Covered:

• Charting 101 - create a basic chart
• From drab to fab - enhance and customize a basic chart
• Combination charts - line and bar in a single chart
• Dynamic charts - automate adding new data to a chart
• Creating in-cell Sparkline charts
• Creating infographics with Excel
• Creating a heat map using Conditional Formatting
• Data Visualization using symbols and icons

Learning Objectives

• To discuss principles of data analysis & visualizations.
• To discuss the most commonly used charts, power pivots, and queries.
• To describe how to create custom charts in Excel.
• To describe data connections and models.
• To explain the process for generating dashboards and creating interactivity.

Who should attend?

• Accountants
• Data Analysts
• Business Analysts
• All Excel Users