Log in

Basics of Excel: Part 2

Sign up for our weekly newsletter!

When & Where
Date: 
Wed, March 6, 2019 - 12:30 PM to 2:30 PM
Location: 
Barrows 356: D-Lab Convening Room
Description
Type: 
Workshop

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 for Part 1, Part 2 and Part 3 separately.

Link: 
Workshop materials for Parts 1 and 2
Keyword: 
Software Tools, Excel, Quantitative Analysis
Details
Training Host: 
D-Lab
D-lab Facilitator: 
Evan Muzzall
Format Detail: 
hands-on, interactive
Participant Technology Requirement: 
Laptop
Log in to register for this training.

The available spaces and the waitlist for this event are both full.