Skill Level: All levels
Duration: 1.5 hours
Excel is a very popular tool among all data users. It can be leveraged to unlock the value of open data of all kinds, and it is particularly well-suited to transforming, analyzing, and visualizing Census Bureau data. This course will show how to use Excel to access, utilize, and visualize Census Bureau data.
After completing this course, you will be able to:
All levels of data users who are interesting in exploring new ways of analyzing and visualizing Census Bureau data using unique features available in Excel.
Andy Hecktman is Microsoft’s Director of Technology & Civic Innovation for Chicago. He works with local organizations to em-power them through technology to achieve positive social impact and equity.
Alexandra Barker is a Supervisory Program Analyst with Data Dissemination and Training Program at the U.S. Census Bureau. She has over 10 years of experience working with data users and stakeholders on how to access and utilize Census Bureau data.
This tutorial introduces you to the instructor and list the objectives covered in the course.
This tutorial introduces you to accessing data, creating pivot tables and formatting data tables to your liking using Census Bureau data.
This tutorial will guide you on creating quick and effective data analysis in Excel.
This tutorial introduces data mapping using Census Bureau data in Excel.
This tutorial expands on 3D mapping in Excel using Census Bureau data.
This tutorial you will learn how to create various hierarchical charts in Excel using Census Bureau data.
This tutorial provides basic knowledge on how you can analyze Census Bureau data with ToolPak in Excel.
This video will show you where to locate and access Census Bureau data, and the various use cases of analyzing data in Excel.
Share your accomplishment on your social media by downloading this certificate or badge!
#CensusBureau #CensusAcademy #Data.census.gov #Excel #dataanalysis #advancedanalysis #statisticalanalysis #datavisualizations #DataTools #mapping #graphs #charts #SurveyData #HowTo #Researchers