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.

Working with Data

What you need to know for Data Management and Data Wrangling

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