Software Tutorials

Need to brush up on your quantitative software?

On this page: Excel|Geographic Information Systems|SPSS

New to Excel? Want to advance your Excel skills? Curious about GIS? Need to do some statistical analysis in SPSS but haven't used it before? The links below contain tutorials in the form of interactive worksheets, instructional videos, links, and written instructions.

If you would like assistance with any of the content, please come into the QSC.

Let us know if you are interested in other topics by calling 425-352-3170 or emailing uwbqsc@uw.edu

Excel

Introductory Excel

The interactive worksheet below will provide an introduction to MS Excel including some setup and using icons, toolbars, and shortcuts. Participants will learn to use Excel functions with an emphasis on those needed for data analysis.

Interactive Worksheet

Written Instructions

Intermediate Excel

The interactive worksheet below will build on the introduction to Excel worksheet, or your own previous experience with Excel. Topics include customizing Excel, shortcuts, macros and the solver.

Interactive Worksheet

Sample Data

Check out these websites for additional Excel help!

Excel 2019 Tutorials - Includes links to videos of how to start with Excel 2019

Excel 2013 Tutorials - Includes links to videos of how to start with Excel 2013

Excel 2010 Tutorials - Includes links to videos of how to start with Excel 2010

Excel 2007: Use for Analysis of Economics Data A collection of handouts assuming no knowledge of Excel and relatively little knowledge of statistics

Excel Easy for 2010 or 2007: An illustrated tutorial that starts from the beginning for those with no knowledge of Excel.


GIS (Geographic Information Systems) Resources

"A geographic information system (GIS) lets us visualize, question, analyze, and interpret data to understand relationships, patterns, and trends." - www.esri.com

UW Library Geospatial Resources Guide: UW GIS Resources, Libraries Hosted GeoData, GIS Data Websites, Finding Imagery, GIS Lab in Suzzallo Library, Other Mapping Tools, and FAQ.

UW Seattle GIS resource page

GIS Education & Training on the Web: ESRI Virtual Campus


SPSS

SPSS is a statistical software package. The guide below will provide an introduction to SPSS including some setup, and using icons and toolbars. Participants will learn to use SPSS features with an emphasis on those needed for statistics.

SPSS Getting Started Guide created by former tutor Benjamin Noblitt.

SPSS Videos for Beginners that also includes links to more SPSS videos on the right side of the page.

DON'T FORGET- You can always stop by the Quantitative Skills Center to get some in-person help and resources.

Back to top