peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Excel Twitters 20090731

Moved to the Excel Twitters archive:

Excel Twitters 20090731

Summer Giveaway for Excel Nerds Winners

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 [...]

Prevent Cheating With an Excel Drop Down List

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 [...]

Excel Twitters 20090724

Moved to the Excel Twitters archive:

Excel Twitters 20090724

Summer Giveaway For Excel Nerds

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 [...]

My Head Hurts So Please Work Quietly

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 [...]

Excel Twitters 20090717

Moved to the Excel Twitters archive:

Excel Twitters 20090717

Copy Excel Code to a Different Workbook

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, [...]

14 Basic Skills For Excel Users

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 [...]

Excel Twitters 20090710

Moved to the Excel Twitters archive:

Excel Twitters 20090710

Related Posts Plugin for WordPress, Blogger...