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 2)
February 15 @ 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):
- Pivot Tables VLOOKUP (approximate match)
- INDEX and MATCH
- Most common functions: Count and Sum
- Logical functions: IF, AND, OR and NOT
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 (03-28-22)