Staff Services / Library Research & Resource Workshops / Microsoft Excel

The Health Science Library offers three Microsoft Excel courses:

• Excel Basics (see below for details)
• Excel Intermediate (see below for details)
• Excel Pivot Tables (see below for details)

Excel Basics

This hands-on workshop will provide participants with an understanding of some of the basic terminology, functions, and features of Excel. Participants will complete various instructor-led exercises and then they will have the opportunity to complete a worksheet exercise on their own.

Course Objectives:

At the end of the class, participants will be able to create a basic Workbook by doing the following:

• Navigating between and labeling worksheets
• Entering text, numbers, and formulas into cells using a variety of methods
• Inserting, deleting and changing the size of rows and columns
• Formatting cells by using colour, font, theme, border and sorting options

Target Audience: Staff and students with little to no previous experience using Excel

Duration: 1 hour

Prerequisite: Basic knowledge of Microsoft Word is recommended

How to register:

• Staff and Physicians: Register through the Learning Centre

• Students and Volunteers: Email hslibrary@smh.ca

For all upcoming library workshops available to you, please click here

Excel Intermediate

This hands-on workshop will allow participants to advance their understanding of some more complex functions and features of Excel by completing various instructor-led exercises. It is recommended as a follow-up to the Excel Basics course.

Course Objectives:

At the end of the class, participants will be able to create a detailed Workbook by doing the following:

• Using complex numerical and textual formulas
• Creating and inserting drop-down lists
• Converting data into detailed, customized charts and Pivot Tables
• Incorporating formatting such as freezing and merging, as well as conditional formatting
• Importing data into worksheets from other sources

Target Audience: Staff and students with some experience using Excel

Duration:  1.5 hours

Prerequisite: Completion of the Health Sciences Library’s Excel Basics course is recommended

How to register:

•  Staff and Physicians: Register through the Learning Centre
• Students and Volunteers: Email hslibrary@smh.ca

For all upcoming library workshops available to you, please click here

Excel Pivot Tables

Participants will have the opportunity to create and manipulate a Pivot table using a provided data set. If possible bring your own data set (and questions) for the practice portion of the workshop. Completion of the Excel Intermediate workshop is recommended.

Course Objectives:

At the end of the class, participants will be able to:

• Understand what a pivot table is, and when to use one
• Create an Excel pivot table
• Manipulate an Excel pivot table

Target Audience: Staff and students with previous experience using Excel.

Duration:  1 hour

Prerequisite: Intermediate knowledge of Excel is recommended.

How to register:

• Staff and Physicians: Register through the Learning Centre
• Students and Volunteers: Email hslibrary@smh.ca

For all upcoming library workshops available to you, please click here