Upload

Loading icon Loading...

This video is unavailable.

Grade Printouts in Excel

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like Jonathan Abbott's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike Jonathan Abbott's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add Jonathan Abbott's video to your playlist.

Published on Mar 24, 2013

Shows how to make a grade printout in Excel. It cleverly uses a PivotTable.
The workbook is available at http://web.mit.edu/jabbott/www/excelg....

The main formula used for lookup:
=IFERROR(OFFSET(*CellToStartOffsetWith$$­*,0,MATCH(RIGHT(*CelltoLookup*,LEN(*Cell­ToLookup)-1),*WhereToLookup*,0)-1),"")
I then surrounded this with an if-statement to ignore values of 0.

A different method on grade printouts can be found: http://blogs.office.com/b/office-educ.... Microsoft here uses a macro and a graph. Not very customizable, but sleek.

  • Category

  • License

    Standard YouTube License

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading icon Loading...

Loading...
Working...
Sign in to add this to Watch Later

Add to