Latest issueFirst pediatric flu death of the season is reported in San Bernardino CountyRead now

← Events on Friday

Classes & TalksFriday, November 6

Excel: Conditioning Data - Level 2

Friday, November 6 · 1-3 p.m. · Murty Sunak Quantitative and Computing Lab, QCL Lobby

1-3 p.m.
When
  • Friday, November 6 · 1-3 p.m.
Where
Murty Sunak Quantitative and Computing Lab, QCL Lobby888 North Columbia Avenue · Claremont, CA · 91711

The event’s page Add to my calendarOpen in Maps

About this event

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

Instructor: Joan Zheng

Participants

All CMC Students, Faculty, and Staff, and All Claremont Colleges Students, Faculty, and Staff

Listed by CitySpark: Claremont, CA, gathered by the San Bernardino events calendar.