Workshop Description:
Excel is a popular spreadsheet software that allows you to organize, modify and analyse your data. In this 2 hour hands-on workshop, you will gain a deeper understanding of the uses and types of data that can be manipulated in Excel. Through practical exercises using real world data, you will learn important terminology, explore methods for manipulating and cleaning your data, use built-in calculations and functions to analyze your data, and create compelling visualizations.
This workshop assumes you have used Excel before at a basic level, but haven’t explored all it has to offer. The goal is to show you alternate ways to do things you already know how to do, as well as help you pick up some new Excel skills. There are no prerequisites or assumptions of knowledge of math, statistics, or programming.
Note: This workshop works with Excel with Microsoft 365 for Windows – if you are using an older version or Excel for Mac, availability and location of some features may differ – a quick Internet search will usually reveal the steps to access a feature in a particular version.
UofT members can download Excel as part of Microsoft Office 365.
Recording - 1:27:58, Workshop File & PDF Walkthrough (includes how to get slides, workshop files, handouts, etc.)