UAlbany Psychology Statistics Courses Support Page

Resources for Learning to Use Excel These resources provide material to supplement classroom instruction on using Excel if handling data and in doing statistical computations. The emphasis in our classes is on the use of Excel as a glorified calculator rather than statistics software.
Training Videos from B. Dudek
	Tutorial 1: Introduction to using Excel as a Glorified Calculator
	Tutorial 2: Basic Excel tools: calculating a mean
	Tutorial 3: Basic Excel Tools: Calculating Variance and Standard Deviation
	Tutorial 4: Z Scores (Forthcoming)
	Tutorial 5: Summation Notation, Order of Operations, and General Excel capabilities (Forthcoming)
	Data Files (Excel Spreadsheets used in these tutorials)
You Tube Videos
	Beginner's Tutorial from Teacher's Tech
	Excel for Beginners - The Complete Course by Technology for Teachers and Students
	Excel SUM function
	3 Ways to Fill Down Blank Cells in Excel by Excel Campus
	Excel Auto Fill

University at Albany Psychology Department Shiny Applets for Statistics Instruction