Log in

Sign up for our weekly newsletter!

When & Where
Date: 
Thu, November 21, 2019 - 3:00 PM to 5:00 PM
Location: 
D-Lab Convening Room
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

 Link: Part 2: Workshop MaterialsDownload MS Office

Primary Tool: 
Excel
Details
Training Host: 
D-lab Facilitator: 
Evan Muzzall
Format Detail: 
Hands-on, interactive
Participant Technology Requirement: 
Laptop

Basic Competency

These workshops are designed for participants with beginner fluency. They already have a little coding, tool or method experience but need to learn more intermediate applications such as conditional subsetting and appropriate data visualizations for their research. 

Examples: Introduction to Pandas, R-wrang, Data Visualization with Python, R-graphics, Survey Sampling, Weighting Data, Introduction to Qualtrics, Finding Health Statistics and Data, Data Viz Theory and Best Practices, Python Machine Learning, Machine Learning in R, Intro to Computational Text Analysis, Geospatial Fundamentals in Python/sf/QGIS/ArcGIS, Intermediate Tableau

Log in to register for this training.