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 2 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

• Data analysis: sort, filter and conditional formatting
• Few useful keyboard shortcuts
• VLOOKUP (exact match)
• Pivot table and chart

References

• Covid-19 data set
• Broadway data set

Workshop creation by Cindy Cheng, QCL Grad Fellow (07-06-20)