Skip to Main Content
UMass Chan Medical School, Lamar Soutter Library. Education. Research. Health Care. Empowering the future. Preserving the past.
UMass Chan Medical School Homepage Lamar Soutter Library Homepage

Library Instruction

Creating Analysis-Ready Data with Excel

Class Description

This 90-minute class is designed for users with some basic Excel knowledge that would like to learn how to use Excel more effectively in order to efficiently manage their data

ExcelObjectives: 

  • Attendees will review and be able to recognize basic formatting and formulas.
  • Attendees will be able to demonstrate using charts and visuals.
  • Attendees will be able to prepare pivot tables.
  • Attendees will be able to employ methods to clean-up data sets.
  • Attendees will be able to demonstrate best practices for managing data in Excel.

Excel Resources