peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Pocket Price Waterfall Chart in Excel

I'm working on some pricing reports for a client, and one of the requests was for a Pocket Price Waterfall chart. I hadn't made one of those before, and fortunately the client sent me a sketch of the chart that they wanted. It looked something like this.

 

The good news was that it [...]

Excel Power Utility Pack Sale Phase 2

Tomorrow, Tuesday June 7th, John Walkenbach is having another deep discount sale on his Excel add-in – Power Utility Pack (PUP).

Remember, Father's Day is this month, so this could be the perfect gift for the dad who has everything. Or give your kids the link, and let them buy it for you!

24 [...]

Fuzzy Lookup Add-in for Excel 2010

If you work with data in Excel, you know what a mess it can be. I help my customers clean up data that they've imported from another computer system, or from reports received from another department or group.

Those files can be filled with spelling mistakes, strange abbreviations, extra spaces or missing punctuation. It [...]

Excel Power Utility Pack Sale

Tomorrow, May 3rd, John Walkenbach is having a 2-hour sale on his Excel add-in – Power Utility Pack. Even at the full price of $40, it's a worthwhile investment, but during the sale it's over 80% off – only $7.77! The older version, for Excel 2003 and earlier, is $6.66.

You can also buy [...]

Create a Waterfall Chart in Excel

We have a very famous waterfall here in Canada, and it creates gorgeous photos, like this one from my fall 2008 vacation.

You can create waterfalls in Excel too -- Waterfall Charts. They might not be as spectacular as Niagara Falls, but can be useful for showing how values change. There are details [...]

Airport Security Times in Excel Box Plot

Earlier this month, I had the pleasure of flying out of Chicago's O'Hare airport. I was checking in at the ungodly hour of 6 AM on a Sunday, and hoped that would be a quiet time at the airport. The streets near the downtown hotel were almost empty, so that was encouraging, but the [...]

Your Scribbles Magically Imported to Excel

Well, maybe you don't scribble. Maybe your handwriting is way better than mine. ;-) Anyway, here's my version of that film classic, Love and Pain and the Whole Damn Thing.

For the past couple of years, I've worked with a client that has factories around the world. As part of their safety program, employees fill [...]

How Much Would You Pay For an Excel Utility?

John Walkenbach is having a 2 hour sale of his Power Utility Pak (PUP) – over 80% OFF the regular price. You can get all your Christmas shopping done early, if you act fast! I'm sure that all your family and friends would love an awesome Excel utility.

The PUP sale is Tuesday, November 3, [...]

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

Related Posts Plugin for WordPress, Blogger...