Archive for the ‘excel’ Category

Don’t Break the Chain – Spreadsheet Version

Wednesday, August 15th, 2007

Are you tired yet of hearing about the Seinfeldian chain? No? Excellent! If you don't know what the heck I'm talking about, you can read about Seinfeld's productivity secret at LifeHacker. The whole premise is that if you want to motivate yourself to do something, get yourself a big calendar, ...

Excel Tip: Copy Subtotal (Aggregate) Data Only

Wednesday, July 4th, 2007

Have you ever used Excel's subtotal functionality? It's great for counting things. For instance, I'm running some tests right now, where the output is a sequence. If I run the test 10,000 times, then I have 10,000 sequences. I want to know how many times each ...

Office 2007 Beta – Where the heck did they put…

Thursday, July 20th, 2006

I've been really enjoying the Office 2007 beta, well, most of it. I've got a weird quirk with Excel right now that gives me some kind of vbs error every time I open it. And Powerpoint is just too unbelievably slow. So slow in fact that I ...