Data Visualization with Excel

Part of the "Business Intelligence with Excel" Series


There is a saying, “a picture is worth 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 in Excel. 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.

Preview Video

Why you should attend

Until a few years ago it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on We’re constantly hearing words like Data Visualization and Infographic. It’s time to get your Excel-related business and communication skills up to date and learn how to use it to present data in the modern world.

Topics covered

  • Creating a traditional chart with a single keystroke
  • Annotating a chart with labels, titles and notes
  • Creating a line-bar combination chart
  • Creating a dynamic chart based on a Table
  • Creating Sparkline charts
  • Creating data visualisations using Shapes and SmartArt
  • Using Excel add-ins to create Infographics
  • Using Conditional Formatting to present data visually
  • Presenting geographic data visually

Who should attend / Level

Any Excel user who wants to know how to represent data visually. 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.