Reposting from the Gettysburg College Language Resource Center blog:
On Wednesday, October 12, I held a workshop on Basic Excel skills for teachers and researchers, with the following description:
Do you use Excel as a grade book or for data collection? In this workshop, you’ll work with Excel hands-on to develop basic skills, such as quickly copying numbers down columns, keeping headings visible at all times, and sorting columns in the most convenient order. If you consider yourself an Excel jockey, this is not the workshop for you–but if you need basic tips and tricks, you’ll find them here.
Feel free to access the handout, with animations of how to do each task within Excel.