Event date
Monday, October 23, 2017
Event time
12:00pm to 2:15pm
Academic Innovation Studio (AIS, Dwinelle Hall 127)

This class will cover the basics of Excel, from simple formulas (SUM, COUNTIF) to more complex Excel features like Macros and the Data Analysis ToolPak. By the end of both sections, students will be able to employ Excel skills to open source policy data sets. These skills are transferrable to any sector.
Topics Covered Will Include:
Basic Formulas
Absolute vs. Relative Referencing
Sort/Filter
Data Cleaning: concatenate, removing duplicates, text to columns, importing PDFs
Advanced formulas: countif, sumif, 
Index
Pivot Tables
Pivot Charts
Macros
Analysis ToolPak 
Goal Seek
Please register separately for Part 1 and Part 2.
Part 1 will be held October 23 from 12:00-2:15pm.
Part 2 will be held October 25 from 12:00-2:15pm.