Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
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


  • 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