Skip Header

Component ID: #ti847798910


Analyzing Census Data in Excel

Component ID: #ti439127775

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

Developed by Adam Hecktman and Alexandra Barker.

 

Skill level: Beginner

Duration: 1.5 hours

Component ID: #ti1265977942

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 data. This course will show how to use Excel to access, manipulate, and visualize Census data.  It will also tools for doing advanced statistical analysis.

After completing this course, you will be able to:
    ✓    Access data from the Census Bureau using the American FactFinder
    ✓    Format tables for data analysis
    ✓    Perform basic and advanced analysis of Census data using Excel
    ✓    Create data visualizations such as sparklines, hierarchical charts, and histograms

Component ID: #ti392361642

Who Should Take this Course?

All levels of data users who are interesting in exploring new way of analyzing and visualizing Census data using unique features available in Excel.

Component ID: #ti777227481

Instructors

Andy Hecktman is the 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

pdf   Course Guide   [2.6 MB]
zip   Data Tables   [<1.0 MB]
Component ID: #ti1684307745

Module 1: Basic Census Data Access and Table Formatting

During this tutorial, you will learn about data access using the American FactFinder and table formatting in Excel.

Component ID: #ti1964511876
Component ID: #ti875498814

Module 2: Quick Census Data Analysis in Excel

During this tutorial, you will learn how to conduct a quick analysis of Census data using Excel.

Component ID: #ti770326107
Component ID: #ti281227040

Module 3: Advanced Census Data Access and Hierarchical Charts in Excel

During this tutorial, you will learn how to create different kinds of hierarchical charts in Excel using Census data.

Component ID: #ti67078105
Component ID: #ti262941930

Module 4: Advanced Census Data Analysis in Excel

During this tutorial, you will learn how to perform advanced analyses of Census data using Excel.

Component ID: #ti882609165
X
  Is this page helpful?
Thumbs Up Image Yes    Thumbs Down Image No
X
Comments or suggestions?
No, thanks
255 characters remaining
X
Thank you for your feedback.
Comments or suggestions?
Back to Header