Data Visualization With Excel

Training Format: Recorded Webinar

Format Type: DVD

Speaker(s): Mike Thomas

Supporting File(s) : Download Zip (7.25 MB)

Webinar Date: Tuesday, March 21, 2017

Training Duration : 75 minutes

Training Material Download : Training Material (Password Required) (6.59 MB)


Untitled Document

Explore, Visualize and Present Data in Excel

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. 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 Visualisation 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.

In this power-packed session Data Visualization with Excel, Mike Thomas will show 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.

Learning Objectives

After attending this webinar, you’ll be able to learn the quickest and best ways to explore, visualize and present your data:

  • 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
  • Using Excel add-ins to create Infographics
  • Using Conditional Formatting to present data visually
  • Presenting geographic data visually

Session Highlights
You will learn the quickest and best data visualization tricks, including these capabilities:

  • Understanding built-in charts, formatting, PivotTables, and PivotCharts
  • Learn the power view
  • Learn the power map
  • Color in Excel 2010 charts -- leveraging Office themes
  • The worksheet as a charting canvas
  • Learn to convert an idea into a chart
  • Export charts quickly with these tips
  • Dos and don’ts of building successful dashboards in Excel
  • Conditional formatting and Sparklines

Who Should Attend

Novice or expert Excel users who Any Excel user who want to know how to represent data visually..

  • Data analysts
  • Finance professionals
  • Leaders
  • Human Resource Professionals
  • Office Managers
  • Staff
  • All Excel users



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. In 2012 Mike founded where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for plural and .. Read More >>



( * ) Single User Price Only.

For Multiple Users/Group, Call 1-800- 270-5740.


How to Create High-Impact Excel Reports
by Mike Thomas

Business Intelligence Using Microsoft Excel Power Pivot & Power Query
by Mike Thomas

How To Build An Effective Dashboard With Microsoft Excel
by Mike Thomas

Mastering Microsoft Excel Pivot Tables & Pivot Charts
by Mike Thomas