Effective Data Communication in Excel (online training) with Jon Schwabish (USA)

Everyone who works with data needs to communicate their findings, their analysis, and their conclusions. It could be in an internal briefing or memo, a management report, an annual report or a scientific article.

But how do you present your data in a powerful way? How do you achieve the goal of your presentation? How do you tell a story with your data to convince your reader or your audience? Knowledge about effective data communication is essential.

In this 3 hour online workshop we explore how to expand the data visualization capacities of the Microsoft Excel software tool. Though there are more and more tools available to analyze and visualize data, Excel continues to be the leader in the field, used by millions around the world every day.

This training focuses on data visualization in Excel. You will learn how to extend the tool to create a number of new and exciting visualizations and templates, in which we look beyond the nondefault chart options.

Course description

In this hands-on training, you will learn how to create a number of new advanced graphs in Excel that not only will help you to bring your message across but will also expand your use of different graph types.

You will explore a variety of chart types that will help to bring your data to life without any programming or coding. We will explore the conditional formatting menu, learn how to combine chart types, and how to move away from the basic line, bar, and pie chart.

The workshop has two parts in order for you to fully focus on this online learning. On May 12 there is a 2 hour teaching class. On May 19 there is a 1 hour additional teaching and Q&A. In between the sessions you can try out different charts yourself based on the step-by-step guide provided by the trainer.

The focus of this online training is to make simple yet clear data visualizations. Increase your knowledge of dataviz in Excel, bring your data to life, choose the right visual form and convince your audience. The knowledge that you gain in this workshop can be applied directly in your daily work.

Attendees should have some basic working knowledge of Excel. You will receive a free copy of the ebook, Step-by-Step Guide to Advanced Data Visualization, which walks the reader through the lectures.

Trainer

Jonathan Schwabish is one of the leading experts in the field of data visualization. On his website PolicyViz he writes widely about the developments in the field. He also hosts the popular PolicyViz podcast and offers private and public data visualization and presentation skills workshops.

Jonathan is generally known for calling for clarity and accessibility in research and has written on various aspects of how to best visualize data including technical aspects of creation, design best practices, and how to communicate social science research in more accessible ways.

Jonathan Schwabish is currently working as a senior fellow at the Urban Institute’s Income and Benefits Center in Washington, DC.