Skip to main content
| University Libraries
See Updates and FAQs for the latest library services updates. Subject Librarians are available for online appointments, and Virtual Reference has extended hours.

Spreadsheets

About using Spreadsheets, such as Excel, Google Sheets, Calc, Numbers, and others.

Spreadsheets InfoGuide

Spreadsheets are common data tables with may uses. This guide gives tips and instructions for using them, especially for data.

Important Skills

Excel Skills for Data

  • Formulas with Absolute and Relative Cell References
  • Pivot Tables and Pivot Charts - Create Summary Statistics
  • Conditional Formatting - Change colors based on cell values
  • Power Query - More advanced data manipulation

Related Guides

Related InfoGuides