peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Would You Approve This Excel Book Cover?

There is a list of Excel books on my Contextures website, and it hasn't been updated recently. Today, I checked Amazon, to see what new and exciting Excel books had been released, so I could start adding them to the list.

There's a book – Excel 2010 Made Simple, by Abbott Katz -- with a [...]

Show Us Your Spreadsheets

Another humdrum day in the world of spreadsheets? Hardly! Thanks to John Walkenbach (Mr. Spreadsheet) and Mike Alexander (DataPig), things are getting exciting.

They've just announced a Show Us Your Spreadsheets contest, with Excel books and gift cards going to the winners. The contest is open to residents of the USA, UK, and Canada [...]

Fix an Excel Time Warp With LEFT RIGHT MID

Sometimes, working with an Excel data import can be a rocky horror show. This month, I've been working with a client who's pulling together data from several accounting systems.

The project is extra exciting because each system stores the data in a different format, and we have to assemble it into a common [...]

Who Plays Your Role in a Movie About Excel?

Mike Alexander, Microsoft Excel MVP, and madcap owner of DataPig Technologies, is interviewing Excel people this summer, and posting the interviews on his Bacon Bits blog. Lots of fun!

Here's the only picture that I have of Mike, and apparently John Walkenbach has a photo of me.

It's funny, that picture reminds me [...]

Very Scary Fall Giveaway for Excel Nerds Winners

Thanks for participating in the Very Scary Fall Giveaway for Excel Nerds! Your Excel horror stories were truly frightening, and the costume ideas were very creative. Thanks again to the generous prize donors: Patrick O'Beirne of Systems Modelling Ltd Jan Karel Pieterse, of JKP Application Development Services Charley Kyd of ExcelUser, Inc. John Walkenbach of [...]

Very Scary Fall Giveaway For Excel Nerds

It's time for another Excel giveaway! Hallowe'en is just around the corner, so let's find out what Excel Nerds do to celebrate. I've been given some awesome Excel utilities, books, and ebooks to give away, so let's have some fun. Rules are at the end of this article.

To enter, write an original (and suitable [...]

Find Answers to Excel Questions

Where do you go when you've got an Excel question? A while ago, I recommended the Excel newsgroups as a great place to ask questions and get one (or several) solutions. Is that what you use, or something different?

Let's try a quick survey – it's my first attempt, so fingers crossed that it goes [...]

Related Posts Plugin for WordPress, Blogger...