Archive for October, 2013
The VLOOKUP book is ready, pick up your copy today & Become Awesome
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]
Keen readers of Chandoo.org 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 Chandoo.org,
I am very glad to announce my newest book – the vlookup book to help you become awesome in answering any lookup related question.Continue »
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 »
Chandoo.org produces it’s Second MVP.
Chandoo.org produces it’s Second Excel MVP.Continue »
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 0Continue »
PowerPivot – the ULTIMATE anti-bloat feature
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 »