Excel: Beyond the Basics

Session Description

In-Person Location: Robarts Library, 5th Floor, Room 5-053 (directly across from the elevator). Map & Data Library Computer Lab

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.

Map & Data Library workshops, such as this one, are a welcoming and inclusive environment for learning. To learn more, check out our Code of Conduct.