Full course description

Course Description:

This workshop examines how to design and edit spreadsheets so that your data collection and analysis is more efficient and accurate.  Topics covered include: best practices for spreadsheet layout, using multiple worksheets, table formatting, number formats, named ranges, data validation to enforce consistency, conditional formatting, data protection, and report printing.

“The majority of spreadsheets that I come across are set up in ways that make analysis more challenging than it needs to be, and they also do not have mechanisms to enforce data consistency, making analysis even more difficult without first going through the long process of cleaning data. Investing in proper layout and data rules saves substantial time!  Also, how you design a spreadsheet should be driven by how you plan to use the data.”  (Alec Muthig, instructor)

Prerequisites: a basic understanding of Excel spreadsheets

Date/Time: Nov.7, 9:00-12:00

Location: Information Technology Center, room ITC171

Instructor: Alec Muthig, UWIT Training

Important Information:

  • Send questions regarding this course to computer.training@uwyo.edu.
  • Please make sure to arrive at least 5 minutes before the class is scheduled to begin.
  • If you are not on campus and would like to attend this course remotely via Zoom, please email a request to computer.training@uwyo.edu at least 24-hours before the listed start time.  Remote course attendance is not available for all workshops, and may have specific requirements.
  • Workshop fees are non-refundable (unless the class is cancelled by UWIT Training).