id	author	title	date	pages	extension	mime	words	sentences	flesch	summary	cache	txt
work_x7i3ruspibhlvbaiifhqtmrpnq	Nada Ammagui	Using Google Sheets to Create, Organize & Explore Your Humanities Data Workshop - Winter Institute in Digital Humanities @ NYCDH2021	2021	28	.pdf	application/pdf	1121	164	81	➢ Create column/row headers to distinguish categories of information. ○ Use option/alt + enter to create a new line in a cell. ○ Hide columns by highlighting them, right-clicking, and selecting "Hide ➢ Create a table of codes to pull from (with recurring data) to be used for ➢ Using the Data Validation tool will create a dropdown selection list in 1. Highlight the column or cells to which you'd like to apply this tool. 1. Highlight the columns or cells you'd like to format. ➢ Use a VLookup formula to automatically populate your table with ○ Highlight your desired column and click on "Data" in the menu 1. Highlight the data (rows and columns) that you'd like to analyze. 2. In the menu, select Data → Pivot table to create one in a new sheet. 3. Select the data category to analyze and format it into rows or columns.	./cache/work_x7i3ruspibhlvbaiifhqtmrpnq.pdf	./txt/work_x7i3ruspibhlvbaiifhqtmrpnq.txt