Excel_Level_2

QCL Excel (Level 2) Workshop

Summary

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 Attendees

Thank you for registering for this Workshop.
If you need to cancel, please do so earlier rather than later to give others a chance to register.

Ticket Cancellation and No-Show Policy:

If you need to cancel your reservation, please contact us by email at qcl@cmc.edu at least 24 hours prior to the event. A prompt cancellation will help us contact the next person on the waitlist. In case of 2 or more no-shows (without cancellation), you will lose your privilege to take our free workshops during the semester.

#Workshop creation by Cindy Cheng, QCL Grad Fellow (07-06-20)
#Workshop update by Vanessa Casillas, QCL Grad Fellow (03-28-22)