Excel_Level_1

QCL Excel (Level 1 - Data) 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

- 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 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 (01-26-22)