TechChange Course: Introduction to Excel for Data Visualization
Loading...
Date
2016
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Abstract
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 ObjectivesBasic data cleaning using Excel functions and formatting techniques including column and table formatting basic macros and conditional formattingHow to create a static report data using Excel functions and features including INDEX MATCH VLOOKUP COUNTIF sparklines charts and dot plotsHow to create an interactive dashboard using PivotTables PivotCharts and SlicersHow to identify good vs poor data visualizations using data visualization principlesHow 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
Description
Keywords
Capacity Building Learning, Capacity Building Learning, Capacity Building Learning