Search

# Archive for October, 2013

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

Published on Oct 30, 2013 in Learn Excel

Hi 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.

Continue »

## I am writing a book [and its coming soon]

Published on Oct 23, 2013 in Learn Excel

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,

Continue »

## 42 tips for Excel time travelers

Published on Oct 17, 2013 in Excel Howtos

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.

Published on Oct 10, 2013 in Huis, Posts by Hui

Chandoo.org 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

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 »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.