U.S. flag

An official website of the United States government

Skip Header
Webinars
Resources
REQUEST A DATA TRAINING

Webinars
Live and recorded classes led by Census Bureau instructors on a variety of topics.

Analyzing Census Data with Excel

Learn how to use Excel to summarize, analyze, and visualize Census Bureau data.

Skill Level: All levels

Duration: 1.5 hours

Description

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:

  • Access data from the Census Bureau using data.census.gov
  • Format tables for data analysis
  • Perform basic and advanced analysis of Census Bureau data using Excel
  • Create data visualizations such as sparklines, hierarchical charts, and histograms

Who Should Take this Course?

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.

Instructors

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.

Course Materials

Beginning of Course

 

 

Introduction (1:38) - Analyzing Census Data with Excel

This tutorial introduces you to the instructor and list the objectives covered in the course.  

Module 1 Basic Data Access, Pivot Tables and Table Formatting (8:53)

This tutorial introduces you to accessing data, creating pivot tables and formatting data tables to your liking using Census Bureau data.

Module 2: Data Analysis (5:20)

This tutorial will guide you on creating quick and effective data analysis in Excel.

Module 3: Introduction to Mapping (5:01)

This tutorial introduces data mapping using Census Bureau data in Excel.

Module 4: Advanced 3D Mapping (3:38)

This tutorial expands on 3D mapping in Excel using Census Bureau data.

Module 5: Hierarchical Charts (6:29)

This tutorial you will learn how to create various hierarchical charts in Excel using Census Bureau data.

Module 6: Analysis with ToolPak (4:33)

This tutorial provides basic knowledge on how you can analyze Census Bureau data with ToolPak in Excel.

Conclusion (2:03) Analyzing Census Data with Excel - YouTube

This video will show you where to locate and access Census Bureau data, and the various use cases of analyzing data in Excel.

Congratulations! You finished the course!

Completed the Video Series?

Share your accomplishment on your social media by downloading this certificate or badge!

Text to Copy When You Share:

I just finished the Analyzing Census Data with Excel with Census Academy! Be sure to check out their free resources! 

#CensusBureau #CensusAcademy #Data.census.gov #Excel #dataanalysis #advancedanalysis #statisticalanalysis #datavisualizations #DataTools #mapping #graphs #charts #SurveyData #HowTo #Researchers

Page Last Revised - June 20, 2023
Is this page helpful?
Thumbs Up Image Yes Thumbs Down Image No
NO THANKS
255 characters maximum 255 characters maximum reached
Thank you for your feedback.
Comments or suggestions?

Top

Back to Header