Log in

Sign up for our mailing list!

When & Where
Date: 
Mon, January 8, 2018 - 12:30 PM to 2:30 PM
Location: 
D-Lab Convening Room: Barrows 356B
Description
Type: 

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 January 9 from 12:30-2:30PM. 

Part 2 will be held January 11 from 12:30-2:30PM. 

Details
Training Host: 
Format Detail: 
Interactive; Hands on
Participant Technology Requirement: 
Laptop
Log in to register for this training.