Sort and filter grade book data using Excel tables (video)

If you find yourself banging your head on your desk when it comes time to sort and filter student data in your grade book, Excel tables can make your life less stressful. Tables let you sort student test scores (for example, from lowest to highest), calculate average scores on assignments, and add special formatting to your spreadsheet. Converting your existing grade book into a formatted table is quick and easy. You supply the student data, and Excel does the heavy lifting.

This video will get you started. If you want to get more in-depth, there's an entire training course devoted to Excel tables.

If you want to learn more about Excel, take a look at the Microsoft Excel blog.

--Matt Shelton