Data Visualization with Excel
There is a saying, “a picture paints a thousand words”. In Excel that means finding ways to represent numerical data pictorially so that your audience can quickly and easily understand it. It's often easier to look at a chart or graph that interprets trends in a set of data, than to just look at a set of figures.
In this session you’ll learn how to create and enhance the appearance of traditional charts such as pie charts and bar charts. You’ll also learn how to use Excel to create Sparkline charts (really useful in dashboards), infographic-style charts and how to represent data graphically without using the charting feature at all.
Among the topics covered in this training session are:
- Creating a chart with a single keystroke
- Selecting the most appropriate chart type (i.e. pie chart, line chart, etc.)
- Adding labels, gridlines, titles and backgrounds to a chart
- Creating a combination chart
- Creating a dynamic chart (based on a Table)
- Adding annotations to a chart
- Creating Sparkline charts
- Creating infographics
- Using Conditional Formatting to present data visually
Who should attend?
Any Excel user who needs to know how to create charts and graphs. You should have an introductory level knowledge of Excel. The training will be delivered using Excel 2016 for Windows although much of the functionality is available in earlier versions of Excel on both Windows and Mac