You Can Do Magic With Excel!

I enjoy making spreadsheets for work and home that do all sorts of things. Some of these do things like check on my work runs (in a completely non-Excel model) and send me an email at home when runs complete, show a progress bar for calculations that need doing and just today I made one that calculates my hours and approximates the overtime I'm projected to get for the next month or two. One office I worked in had a server that sent text messages so I could find out exam results online while sitting in the pub.

I do similar things at home for calculating my finances, getting the lead in the Six Nations Fantasy League (no small feat considering I don't know much about the players) or doing the boring eliminating options bit in the hard sudoku (after I've entered the options obviously or there'd be no point, I'd just be writing a solver).

If you can think of anything spectacular (or just plain boring) you would like to achieve in Excel, let me know by commenting below and I'll do my best to create the magic step-by-step so you can reproduce it at home. I'll need to know what version of Excel you have (you can find this by selecting the About option on the Help menu) and as much detail as you can come up with about what you want created. Check in regularly to see if there's anything new which you might find useful.

I may occassionally put on general tutorial on how to do various things like different formulae and how to use macros (VBA) so you don't have to constantly repeat boring tasks.

Go ahead and challenge me.