I don’t use VB or anything fancy, but you’d be amazed at how many times people watch with awe when I navigate around a spreadsheet using plus arrow keys to jump to the beginning/end of rows/columns, to select, and things like to select whole columns, etc. Simple tricks can improve productivity massively. is another good one (delete cells).

No particular tricks, just stuff I’ve learned. Ever since I lost access to SAS, I’ve been using VBA to do monte carlo experiments. It isn’t as good as SAS, or as easy to visualize, but it is quick and dirty. Just last semester I learned what all the stuff in solver mean – shadow prices, allowable increases/decreases. And I’m finally proficient with pivot tables, I always could kind of mung them, but now I’m quick.

I’d forgotten about the in cell graphs, thanks for re-linking that!