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.
At the end of the class, participants will be able to create a detailed Workbook by doing the following:
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
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.
At the end of the class, participants will be able to:
Target Audience: Staff and students with previous experience using Excel.
Duration: 1 hour
Prerequisite: Intermediate knowledge of Excel is recommended.
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.