Data Visualization With Excel

Download Training Material

Training Material (Password Required)

Training Details

Training Format : OnDemand Webinar

Webinar Date: Monday, March 27, 2017

Webinar Time: Available All Day

Presenter(s):Mike Thomas

Training Duration:75 minutes

Training Material Download Training Material
(Password Required)

(6.59 MB)

Supporting File(s) Download Zip
(6.59 MB)

Training Description


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

Have a question? Ask your doubts at the Q&A session after the live event and get special advice pertaining to your specific situation, straight from our expert speaker.

About Trainer

Mike Thomas , ,

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in..

Read More >>

Order Now

We also recommend