Log in

Sign up for our mailing list!

When & Where
Date: 
Wed, February 19, 2020 - 11:00 AM to 1:00 PM
Location: 
D-Lab Convening Room
Description
Type: 

This two-part series will focus on how to set up database-like structures, navigate them, create models and build various types of reports in Microsoft Excel. By the end of this series, participants will be able to sort and look for information within large datasets, use character-based functions, pivot tables, and build basic financial models.

Technology requirement: Please arrive with Microsoft Excel installed on your laptop.

Please note: Registration is required for each part of this series. See below for topics covered during each session and links for registration. 

The Basics of Excel Part 1:

  • Math Operations
  • Basic Formulae
  • Spreading Formulae
  • Locking Reference
  • Cell Referencing
  • Vlookup
  • If
  • Sumproduct
  • Index & Match
  • Character-based Functions: concatenate, extracting substring (mid/left/right)

The Basics of Excel Part 2:

  • Pivot Tables
  • Modeling 101
  • Conditional formatting & data validation
  • Importing Text Data
  • Text to Columns
  • Sorting and Filtering
Primary Tool: 
Excel
Details
Training Host: 
D-lab Facilitator: 
Evan Muzzall
Format Detail: 
Hands-on, interactive
Participant Technology Requirement: 
Laptop; please arrive with Microsoft Excel installed.

Beginner

Designed for those who have no experience and are just beginning their coding, tool or method journey.

Examples: Programming Fundamentals, Git Fundamentals, Stata Fundamentals, R Fundamentals, Python Fundamentals, Basics of Excel, Tableau Fundamentals

Log in to register for this training.