Log in

Sign up for our weekly newsletter!

When & Where
Date: 
Tue, November 1, 2016 - 12:00 PM to 1:30 PM
Location: 
Barrows 356: D-Lab Convening Room
Description
Type: 

This three-part series will focus on how to maximize functions in Microsoft Excel, set up database-like structures, and build various kinds of reports. By the end of this series, participants will be able to import text data, perform basic mathematical operations and character-based functions, sort and filter data, and utilize pivot tables.

Prior knowledge: Completion of The Basics of Excel: Part 1 and The Basics of Excel: Part 2.

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:

  • Importing Text Data
  • Text to Columns
  • Cell Referencing
  • Math Operations
  • Basic Formulae
  • Spreading Formulae
  • Locking Reference
  • Sorting and Filtering

The Basics of Excel Part 2:

  • Vlookup
  • Character-based Functions: concatenate, extracting substring (mid/left/right)
  • If/Countif

The Basics of Excel Part 3:

  • Pivot Tables
  • Macros
Details
Training Host: 
D-lab Facilitator: 
Susan Grand
Format Detail: 
Interactive, Follow-along
Participant Technology Requirement: 
Laptop and Microsoft Excel required
Log in to register for this training.