#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)