Using Microsoft Excel to analyze freely available historical datatabases: life in Copenhagen through the 1885 census

Instructors: Muhamed Fajkovic, Lars Kjær and Barbara Revuelta-Eugercios

Are you interested in taking advantage of the millions of records of historical information already available for historical research? Are you interested in developing a digital profile? Do you want to be able to analyze small databases with Excel for historical research? This 3-hour workshop will introduce you to how you can use one of the freely available transcribed sources available at the Danish Demographic Database to do historical research. In it, we will use Excel to answer a research question using the Copenhagen census of 1885 and you will learn how to turn a large amount of information on people on historically meaningful information.

Taking a research question as a starting point, this workshop will provide an:

• Introduction to data historical and contemporary data for Humanists at Rigsarkivet contained at the Danish Demographic Database
• Introduction to the use of Excel for data management and historical analysis (through pivot tables)
• An exercise to solve a research question using the fully transcribed census of Copenhagen in 1885 and getting historical (and humanistic) inference out of quantitative data

Read more about the study group of HUMlab here: https://kub.kb.dk/humlab/study_groups

Only 15 seats so register now!