data-visualization-with-excel

Data Visualization with Excel

Live Webinar

  • 60 minutes

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.

SESSION HIGHLIGHTS

  • 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:

  • Accountants

  • Bankers

  • Business Analysts

  • Economists

  • Financial Analysts and Directors

  • Insurance Experts

  • Investment Bankers

  • Managers

  • Statistician

  • Valuation Experts

  • Tax Professionals

  • Book Keepers

  • IT Professionals

  • Administrative Personnel

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

Mike Thomas

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.

No Reviews Found

Want to attend in a Group? Call 844-810-1151 and Save upto 50%

Share this course with a friend
           

We Also Recommend

Technology

Working with Pivot Tables in MS Excel (2010 - 2016)

Pre Recorded
ROMAN KONDRATIUK
(Speaker)
Duration:
90 minutes

Newsletter

Get Notified about News, Webinars, Community & More