Who can help me? »

Using spreadsheets

Home > Dmp > Using spreadsheets
10/22/2012 - 5:17pm

Using Spreadsheets

Definition

Spreadsheets are software tools for analyzing and modeling mathematical relationships and producing charts and graphs from numeric data.

Relevance

Because they are relatively simple to set up and use, many people use spreadsheets to store and structure numeric and text data.

Recommendations

  • Take a tutorial or course. The more you know about how to enter and sort data, the more you will get out of using a spreadsheet.
  • Use consistent terms, spelling, and formats for non-numeric data. The Autocomplete function in Excel can help you be consistent.
  • If you are sharing spreadsheets, be sure to include version designations in the file names. (See File Naming and Versioning)
  • Spreadsheet software can undergo frequent changes as new versions are released. To protect the longevity of your spreadsheet data, replace formulae with values and export and archive versions in sustainable formats, such as CSV.
  • If your data set is large, complex in structure, or multiple users need to use it, consider moving your data to a database.

What are some options?

Resources

  • A number of resources on using spreadsheets are available online, for example, tutorials at about.com.