Moved to the Excel Twitters archive:
Excel Twitters 20090731

Thanks for participating! You’re an awesome bunch of Excel nerds. The entries in the “You might be an Excel nerd…” giveaway were very entertaining, and read more like my resume than a list of contest entries. Yep, I do some of those things, and I’ll bet you do too.
Thanks again to the generous [...]

You know how to create a drop down list in Excel, by using the Data Validation feature. Sometimes you get extra fancy, and make a drop down list that depends on the selection made in another list, using dependent data validation.

Dependent data validation works well, but there’s a loophole. In the screen shot below, I [...]

Moved to the Excel Twitters archive:
Excel Twitters 20090724

It’s time for an Excel giveaway! Just describe one of the telltale signs of Excel nerdery (is that a word?), and you could be the proud owner of a shiny new Excel book, e-book or utility.
To enter, write an original (and suitable for work!) comment below, completing the sentence, “You might be an Excel nerd [...]

Yes, my head hurts, and unfortunately it’s not from a weekend of wild carousing. No, it’s from a weekend of installing software. I’m sure you’ve experienced similar pain, and you might be a bit sympathetic.
Office 2010
As you know, the technical preview for Excel 2010 started last week, so I downloaded it, and was eager [...]

Moved to the Excel Twitters archive:
Excel Twitters 20090717

Last week one of my clients asked for a bit of help, so I sent a workbook with some sample code to tackle the problem. It was just what he needed, so my client wanted to copy the code from the sample file, into his own workbook. Unfortunately, he wasn’t sure how to do that, [...]

Last week, John Walkenbach posted a list of basic skills for men, then basic skills for women, and finally, basic skills for dogs. That got me thinking – what’s on the list of basic skills for Excel users? If you use Excel at work, or list it on your résumé, what tasks should you be [...]

Moved to the Excel Twitters archive:
Excel Twitters 20090710