Excel Data Analysis: Charts, Pivot Tables, and VLOOKUP

April 20, 2022, 9:00am to 11:00am

Trying to register, but not affiliated with the UCB campus? If you are from Berkeley Lab (LBL), UCSF, or CZ Biohub, please register via our partner portals here

If you are from the UCB campus there's no more waitlist! But after registering above, please do fill out the affiliations form if you have not done so at least once before: https://dlab.berkeley.edu/affiliations

Location: Remote via Zoom. Link will be sent on the morning of the event.

Recordings: This D-Lab workshop will be recorded and made available to UC Berkeley participants for a limited time. Your registration for the event indicates your consent to having any images, comments and chat messages included as part of the video recording materials that are made available.

Date & Time:  This workshop will run from 9am-12pm on Wednesday, April 13. 

Start Time: D-Lab workshops start 10 minutes after the scheduled start time (“Berkeley Time”). We will admit all participants from the waiting room at that time.


This two-hour workshop will cover charts in more detail, review pivot tables, and work through at least one further challenge problem for functions. As a bonus, we'll also introduce the widely-used VLOOKUP function.

Prerequisites: We recommend first taking the introductory workshop Excel Data Analysis.

Workshop Materials: https://github.com/dlab-berkeley/Excel-Fundamentals

Software Requirements: Installation Instructions

Is Excel Not working on your laptop? Attend the workshop anyway, we can provide you with a cloud-based solution using Google Sheets.

Feedback: After completing the workshop, please provide us feedback using this form

Questions? Email: dlab-frontdesk@berkeley.edu