Skip to main content
Left arrow Barnard.edu

 

  • Visit Us
  • What We Do
    • What We Do
    • Course Support
    • Projects
    • Student Work
    • ERC Blog
  • Who We Are
  • Workshops
  • Software Tutorials
  • Events
    • Upcoming Events
    • Past Events
    • Recordings
    • Data for Justice Series
Left arrow Barnard.edu
Search All of Barnard.edu

Tutorials

  • Excel for PC
  • Excel for Macs
  • SPSS
  • Stata

Software Tutorials

Excel for PC

This tutorial is for Excel 2010 for PCs

Data Manipulation Basics

Getting Started with Spreadsheets; Worksheet Basics; Introduction to the Ribbon; Cell Manipulations; Formatting Cells; Copying, Cutting, & Pasting; Inserting & Deleting; Manipulating Data I; Manipulating Data II

Charts

Creating Charts; Formatting Charts; Formatting the Chart Plot Area; Formatting the Chart Axes; Formatting the Chart Legend; Copying, Cutting, & Pasting Charts; Trendlines and Error Bars; Linest Function; Pivot table

Formulas & Functions

Formula Basics; Using Excel's Functions; Common Function & Formula Error Messages; Some Useful Statistical Functions; Macros; An Application of Functions: Budget Spreadsheet 

Data Anlalysis

Analysis ToolPak; ANOVA

Excel for Macs

This tutorial is for Excel 2011 for Macs

Data Manipulation Basics (Mac)

Getting Started with Spreadsheets; Worksheet Basics; Introduction to the Ribbon; Cell Manipulations; Formatting Cells; Copying, Cutting, & Pasting; Inserting & Deleting; Manipulating Data I; Manipulating Data II

Charts (Mac)

Creating Charts; Formatting Charts; Formatting the Chart Plot Area; Formatting the Chart Axes; Formatting the Chart Legend; Copying, Cutting, & Pasting Charts; Trendlines and Error Bars; Linest Function; Pivot table

Formulas & Functions (Mac)

Formula Basics; Using Excel's Functions; Common Function & Formula Error Messages; Some Useful Statistical Functions; Macros

SPSS

This tutorial is for SPSS Version 20. (This tutorial can also be used with previous versions of SPSS.)

SPSS Basics

Getting Started: Three Windows; Open or Merge Files; Saving Files; Reading an Output File; Using the Data Editor; The Edit Menu and Toolbar; Transforming Variables; Sort and Filter Data

Descriptive Analysis

Central Tendency; Dispersion and Variability; Distribution and Normality; Z-Scores; 

Frequency Analysis

Frequency Tables; Frequency Charts

Hypothesis Testing

T-Tests; ANOVA Tests; Chi-Square Tests

Regressions and Correlations

Pearson's r; Simple Linear Regression; Scatterplots; Multiple Regressions

Stata

This tutorial is version BETA meaning it is still under construction.

Introduction to Stata

What Stata Looks Like; Exploring a Dataset; Setting Up Your Research; Initial Analysis; Handy Tricks; More Advanced Regression Models; Data Visualization; Potential Problems; Opening and Creating .dta Data Files

Site Footer

 

Milstein 102 | erc@barnard.edu

at The Milstein Center for Teaching and Learning

Departments

  • Library
  • IMATS
  • Archives
  • Zines

Teaching & Learning Centers

  • Center for Engaged Pedagogy
  • Design Center
  • Digital Humanities Center
  • Empirical Reasoning Center
  • Movement Lab
  • Sloate Media Center
  • Vagelos Computational Science Center

Copyright © 2023 Barnard College | Columbia University