Data Science Events at The Claremont Colleges
This calendar is a central site for information about data science events and workshops across the 7Cs. Please look at each individual event to get information about location and registration. To post an event to this calendar contact jeanine.finn@claremont.edu.
- This event has passed.
Exploring Data in Excel (Part 1)
February 7 @ 4:15 pm – 5:45 pm
Microsoft Excel is a spreadsheet program that is part of the Microsoft Office Suite. It is useful for calculations, making simple charts and data recording for different business processes.
Purpose
The 1.5 hour workshop is intended to introduce some basic features and functions to audience with little or no previous Excel experience.
Prerequisite
Attendees are asked to have local installation of the Microsoft Excel or access to Excel Online through Office on their own computers for the workshop.
Agenda
The workshop covers:
- Learn how to move around the Excel Environment
- Learn how to move data around with Sort
- Learn how to highlight and hide data with Filter and Conditional Formatting
- Make a simple search feature with VLOOKUP (exact match)
- Make simple Calculations about your data
- Put data in bins for visuals with Frequency
References
- Covid-19 data set
Broadway data set
Workshop creation by Cindy Cheng, QCL Grad Fellow (07-06-20)
Workshop update by Vanessa Casillas, QCL Grad Fellow (01-26-22)