Log in

Sign up for our weekly newsletter!

When & Where
Date: 
Tue, April 21, 2020 - 12:00 PM to 2:00 PM
Location: 
Zoom link below
Description
Type: 

Zoom Link

To obtain the Zoom link for this workshop please: Click here for Zoom link

After re-registering on the Zoom website, you will receive a confirmation email containing information about joining the meeting.

If you already have and use a Zoom account, please sign into it first, before trying to access the D-Lab workshop.

If you have questions or problems with Zoom, please email: dlab-frontdesk@berkeley.edu

 

Overview

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 Learner Level: 
Beginner
Training Host: 
D-lab Facilitator: 
Evan Muzzall
Format Detail: 
Remote, hands-on, interactive
Participant Technology Requirement: 
Laptop, Internet Connection, Zoom account
Log in to register for this training.