The Science Goddess just completed a 3-part series on how to create a standards-based gradebook using Excel. The posts include a sample gradebook you can download and play with. Plus, your learning will be supported by three screencasts of the Science Goddess explaining some tips and tricks. Highly recommended!
Part 1: Roll your own gradebook: Setting Up
Part 2: Using Index and Match to set up a dashboard
Part 3: Adding Sparklines