Measuring and communicating the impact of a project or program often relies on effective data analysis and visualization. In this course, you will learn how to effectively use Excel to create beautiful static and interactive visualizations.
Course Description
Excel offers an interface most people are familiar with, as well as a valuable set of features that can be utilized to meet a wide range of data analysis and visualization needs. In this course you will learn the nuts and bolts of how to use Excel functions and features including: INDEX MATCH, PivotTables, Slicers, and more. In addition, you will learn key data visualization principles that will help you optimize your data visualizations to best communicate your data.
After exploring some case studies of how other organizations have used Excel to visualize data, you will get the opportunity to practice what you have learned through 2 scenario-based exercises.
Please note that alumni, early bird, and quick pay discounts do not apply for this course.
Course Objectives
- Basic data cleaning using Excel functions and formatting techniques, including column and table formatting, basic macros, and conditional formatting
- How to create a static report data using Excel functions and features, including INDEX MATCH, VLOOKUP, COUNTIF, sparklines, charts, and dot plots
- How to create an interactive dashboard using PivotTables, PivotCharts, and Slicers
- How to identify good vs. poor data visualizations using data visualization principles
- How Excel has been used in practice through 2 case studies
Course Methodology
This course will feature animations, screencasts, interactive presentations, case studies, and scenario-based exercises. A forum at the end of the course provides an opportunity for participants to interact and get feedback on course-related comments or questions.
Acknowledgements
TechChange would like to thank D3 Systems, Inc. and John Snow, Inc. for providing material for the case studies featured in this course.