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 with expert Mike Thomas, 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.
Creating a traditional chart.
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 visualizations using Shapes and SmartArt.
Using Excel add-ins to create Infographics.
Using Conditional Formatting to present data visually.
WHY YOU SHOULD ATTEND
Get your Excel-related business and communication skills up to date and learn how to use it to present data in the modern world.
Learn Data Visualisation and Infographics using Excel.
Learn to use Sparkline Charts in Excel.
WHO SHOULD ATTEND
You should have an introductory level knowledge of Excel. Any Excel user who wants to know how to represent data visually should attend including:
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.
Ask your question directly from our expert during the Q&A session following the live event.
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organisations across a diverse range of sectors.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.