Software & reviews: Sorting and filtering grade book data by using Excel tables (video)

Thursday, April 7, 2011

Sorting and filtering grade book data by using Excel tables (video)

Translate Request has too much data
Parameter name: request
Translate Request has too much data
Parameter name: request
a.stbar.chicklet img {border:0;height:16px;width:16px;margin-right:3px;vertical-align:middle;}a.stbar.chicklet {height:16px;line-height:16px;}Office in Education - Sort and filter grade book data using Excel tables (video) Join

The Microsoft Office Blog About RSS Atom

Home

Chris Bryant

Crabby Office Lady

Microsoft Access

Microsoft Excel

Microsoft OneNote

Microsoft Outlook

Microsoft PowerPoint

Microsoft Publisher

Microsoft Word

Office Casual

Office Comics

Office in Education

Office Show

Office VP

Templates and Images

The Microsoft Office Blog

Home » Office in Education » Sort and filter grade book data using Excel tables (video) Home Blogs Files

Office in Education

News, tips, and tricks for students and teachers who use Microsoft Office

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

Matt Shelton 16 Mar 2011 8:22 AM Comments 0

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