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,
Microsoft Office 2007 Enterprise, from lowest to highest),
Windows 7 Serial, calculate average scores on assignments,
Microsoft Office 2007 Key, 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,
Microsoft Office Professional 2010, and Excel does the heavy lifting.
This video will get you started. If you want to get more in-depth,
Office Professional 2010, there's an entire training course devoted to Excel tables.
Microsoft Excel blog.
--Matt Shelton
<div