Archive for October, 2013

The VLOOKUP book is ready, pick up your copy today & Become Awesome

Published on Oct 30, 2013 in Learn Excel

the-vlookup-book-ebookHi folks,

What a night it has been. Unlike hi-fi product launches for a new perfume or car, my book launch did not have hot models or unlimited champagne. And yet, last 18 hours has been an intense and lovely experience. And finally,

My book is out.

You can purchase a copy thru Amazon or our website.

Go ahead and get your copy today.

Continue »

I am writing a book [and its coming soon]

Published on Oct 23, 2013 in Learn Excel

Keen readers of would have noticed a slow down in new posts recently. There are a few reasons for that.

  • I went to Malaysia to conduct Excel Dashboards & Power Pivot masterclass.
  • After coming back, we (our family) went to Goa to vacation for a few days.
  • When we got back, we all fell in to a vicious loop of flu, body pains and fatigue.
  • And it took a few days to recover and fall back in to routine.
  • But the most important reason is, I am writing a book 🙂

Introducing The Vlookup Book

Friends, readers & supporters of,

I am very glad to announce my newest book – the vlookup book to help you become awesome in answering any lookup related question.

Click here to get your copy.

Continue »

42 tips for Excel time travelers

Published on Oct 17, 2013 in Excel Howtos
42 tips for Excel time travelers

Today, let’s travel in time. Pack your photon ray guns, extra underwear, buckle your seat belts and open Excel!

Of course, we are not going to travel in time. (Come to think of it, we are going to travel in time. By the time you finish reading this, you would have traveled a few minutes)

We are going to learn how to travel in time when using Excel. In simple terms, you are going to learn how to move forward or backward in time using Excel formulas.

So are you ready to hit the warp speed? Let’s beam up our Excel time machine.

Continue » produces it’s Second MVP.

Published on Oct 10, 2013 in Huis, Posts by Hui produces it’s Second MVP. produces it’s Second Excel MVP.

Continue »

Formula Forensics No. 035 Average the last 3 values greater than 0

Published on Oct 3, 2013 in Formula Forensics, Posts by Hui
Formula Forensics No. 035 Average the last 3 values greater than 0

Learn a technique to Average the last 3 values from a range where the values are greater than 0

Continue »

PowerPivot – the ULTIMATE anti-bloat feature

Published on Oct 1, 2013 in Learn Excel, Posts by Jeff, Power Pivot

Howdy again, folks. Jeff Weir here, borrowing the keys to the blog off Chandoo again. (Hopefully I don’t scratch it again). How remiss of me…jacob reminded me in the comments of my previous BLOATED post on good spreadsheet anti-bloat practices that I completely missed one of Excel’s newest and most efficient anti-bloat features: PowerPivot. So […]

Continue »