Excel_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 creation by Cindy Cheng, QCL Grad Fellow (07-06-20)
#Workshop update by Vanessa Casillas, QCL Grad Fellow (03-28-22)