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.

Loading Events

« All Events

  • This event has passed.

QCL Workshop – Excel: Conditioning Data – Level 2

October 31 @ 4:15 pm 5:45 pm

Virtual Event

Add to calendar

This Excel Level 2 workshop will cover more functions and features to save you some time while working with Excel. 

In this 1.5-hour workshop, we hope to get you started with: 

– Pivot Table

– More Lookup functions: VLOOKUP (approximate match), INDEX, and MATCH

– Most common functions: Count and Sum

– Logical functions: IF, AND, OR, and NOT

The workshop is designed to continue from the QCL Excel Basics Level 1 Workshop.  However, anyone is welcome to register. 

Pre-requisites

Internet Use: Introductory level (search, log-in, navigation of websites, etc.)

Local installation (if you bring your laptop): Microsoft Excel (any version)Software knowledge: basic Excel skills

Participants

CMC Students, Faculty and Staff

Murty Sunak Quantitative and Computing Lab (QCL)

View Organizer Website