Skip to main content

Library Workshops

Excel Intermediate with the Health Sciences Library

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

Library Workshop Registration LinkLibrary Workshop Registration Email Link

Cancellation Policy

 

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.

Library Workshop Registration Link Library Workshop Registration Email Link

Cancellation Policy

Pivot Tables Working Session

This working session will build upon skills taught in the Excel Pivot Tables workshop and is offered to provide learners with an opportunity to practice with pivot tables, and gain hands-on experience in a supportive instructor-led space. Completion of the Excel Pivot Tables workshop is highly recommended as a pre-requisite but is not mandatory. NOTE: This working session is not a course for learning to make pivot tables. It is designed and offered for working through challenges with an instructor to complete hands-on exercises with pivot tables.

Target Audience: Any staff who work with Excel pivot tables.

Duration:  1 hour

Prerequisite: Completion of the Excel Pivot Tables workshop is highly recommended as a pre-requisite but is not mandatory.

Library Workshop Registration Link Library Workshop Registration Email Link

Cancellation Policy

Telephone416-864-5059 Email icon hslibrary@smh.ca           Twitter icon   Health Sciences Library Blog                Health Sciences Library Feedback