Data Visualization in Excel

Duration: 90 minutes

Data visualization is the art of representing numerical data in the best possible pictorial way so that your audience can quickly and easily understand it.

This session will help you raise the bar for your data. We’ll start with something familiar- traditional pie charts and bar graphs, then you’ll learn how to enhance, customize and tailor them to your data. (more details below)


WHY ATTEND

The old adage “A picture is worth a thousand words” is wrong.

A picture is actually worth 60,000 words because the human brain processes images 60,000 times faster than text.

Most professionals are already well aware of the need for visuals to represent their data, but many still rely on basic pie charts and bar graphs, confusing data structures, improperly placed labels and default colors.

Welcome to the age of Data Visualization.

Along with customizing your graphs and charts, you’ll learn how to use Excel to create Sparkline Charts (infographic style charts) and how to represent data graphically.

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. This session will get you started.

LEARNING OBJECTIVES

In this session you will learn how to:

  • Elevate your use of traditional charts using single key strokes, annotations, labels and notes
  • Lay two sets of data on top of each other with line-bar combination charts 
  • Use Sparkline Charts to create modern images of your data 
  • Stay flexible when data changes with dynamic charges and conditional formatting 
  • Look beyond charts and graphs to represent your data with Shapes and SmartArt

Prerequisite: Attendees should have an introductory knowledge of Excel and a desire to heighten their ability to present data visually.

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.

ABOUT THE SPEAKER

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 theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.

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

What You Get With Each Option

Live Recording

Live Only

Participation in the live upcoming webinar

Recording

Recording Only

Full MP4 recording of webinar, including Q&A. Choose digital download or CD-ROM by mail.

Live and Recording

Live + Recording

Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

Event Package

Event Value Pack

Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

What You Get With Each Option close

Live Recording

Live Only

Participation in the live upcoming webinar

Recording

Recording Only

Full MP4 recording of webinar, including Q&A. Choose digital download or CD-ROM by mail.

Live and Recording

Live + Recording

Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

Event Package

Event Value Pack

Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

About Webinar Connections close

Each purchase is for ONE computer to access the session.
A group may participate in a room together as long as only 1 computer is logged in.
If you need more than one computer to access the webinar, please call customer service at 888-479-2777.
A charge will apply for each connection.