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