PRICE
€ 179 (VAT exempt)FOR WHO
The training is suitable for anyone who wants to gain more insight into the possibilities of (data) visualizations and ways to communicate effectively with the target group. The training is interesting for communication or marketing experts, data analysts, researchers and business intelligence experts who work a lot in Excel and want to expand the possibilities of data visualisation.PRACTICAL INFORMATION
-Training Effective Data Communication in Excel
Everyone who works with data, needs to present it every once in a while. This could be in 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 in a way that it is convincing to your target audience? Knowledge about effective data communication is then essential.
In this training we will explore how communication with data works most effectively when using Excel. Even though there are many tools nowadays in data analysis and data visualization, Excel continues to be the most commonly used tool.
The training focuses on the visualization options of Excel. You will create a number of new and exciting visualizations and templates, in which we look beyond the nondefault chart options.
Content
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 also expand your use of different graph types.We start with some basic skills in Excel, but quickly move to more advanced data visualization techniques. The training covers formulas such as INDEX, MATCH, and VLOOKUP; data importing features; in-cell charting and conditional formatting; and advanced data visualization techniques.
We will also pay attention to the graphic design. How do you make sure that your visualization is powerful and has the desired effect on your target audience? How do you ensure that all unnecessary information (clutter) is removed from the graph? Attention is paid to the redesign of graphs, so that you as a participant experience how you can change an existing visualization into a more powerful one. We apply this redesign in an exercise using Excel.
The focus of this training is to make simple but 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 the training can be applied directly in your daily work.
For this training some basic knowledge of Excel is essential.
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 is the author of Better Presentations (2016) and Better Data Visualisations (2021).
Jonathan Schwabish is currently working as a senior fellow at the Urban Institute’s Income and Benefits Center in Washington, DC.
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 is the author of Better Presentations (2016) and Better Data Visualisations (2021).
Jonathan Schwabish is currently working as a senior fellow at the Urban Institute’s Income and Benefits Center in Washington, DC.