Event box

Analyzing Census Data in Excel

Excel is a popular tool among all data users. It can be utilized to showcase the value of open data of all kinds, and it is particularly useful for transforming, analyzing, and visualizing census data. In this workshop, you will learn how to use Excel to access, manipulate, and visualize census data. Specifically, we will explore using the advanced search option within the American FactFinder from the census to locate census topics at various geographic levels. Through hands-on exercises, you will perform basic and advanced search within the census, conduct various data analyses and visualization tasks in Excel.

Expected Outcomes:

  1. Access data from the Census Bureau using the American FactFinder
  2. Format tables for data analysis
  3. Perform basic and advanced analyses of census data using Excel
  4. Create data visualizations such as sparklines, hierarchical charts, and histograms

Tools/Software: Microsoft Excel, Laptop, Window Excel (preferred).

Wednesday, February 5, 2020
2:00pm - 3:30pm
Digital Studio Conference Space
Chestnut Hill Campus
  Digital Scholarship  
Registration has closed.

Event Organizer

Profile photo of Jiebei Luo
Jiebei Luo