Outside of a dog, a book is a man’s best friend. Inside of a dog it’s too dark to read. -Groucho Marx
We don’t have a dog (yet), but we have a lot of books. Anytime I am in a bookshop, I feel like a mosquito in fat-camp. So you can imagine me smacking my lips when I saw your suggestions for favorite Excel books recently. There were more than 50 different books recommended by our readers. Of course I cannot buy all the 50 in one go. That would make Jo (my wife) angry. So I bought one that most of you recommended.
It is a book about array formulas, advanced formulas and data analysis techniques. I am eagerly waiting for the delivery to devour it. Once I am done with it, I will post a review here.
What about you? What Excel book are you reading now? Please share in comments.Continue »
I am super-excited to tell you that Chandoo.org Podcast will be launching on 6th of March (Thursday). First episode is already recorded and I am getting ready for the big launch.
Name of the podcast
Last week I asked you what should we call our podcast. And I got more than 250 suggestions (150+ thru comments another 100 thru email). While the suggestions ranged from funny (chanpoo, addict.xls) to word plays (Excelent cast, Lord of the cells, Speaking Cells) to outright brilliant (XL.AM remember AM radio?). Some of the suggestions were crazy too: Word on the sheet, YouChandooIt, Didasko.xlsx – greek word “to impart knowledge”.
Thanks everyone for the ideas and suggestions.
A majority of you suggested that we call it Chandoo.org Podcast. This keeps the name generic, sticks to our brand and sets us apart. So that is what we will call it.
The full name of the show is Chandoo.org Podcast – Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel
And our first episode will be launched on Thursday, 6th of March.Continue »
If you’re building large models, then you may want to use volatile functions – including OFFSET(), INDIRECT(), and TODAY() – with caution, because unless you know what you are doing, they *might* slow Excel down to the point that data entry is sluggish, if not downright tedious.
In fact, you *might* want to consider getting out of the habit of using these functions at all if there are alternatives, and you might want to replace volatile functions in your existing models with non-volatile alternatives…I have reduced recalculation time in large models from minutes to milliseconds by doing just that!
So what the heck does volatile actually mean? And why should you care? Let’s find out, shall we?Continue »
Today lets rescue John Doe from John_doe@email.com.
Extract first & last name from email address
Given an email address in the format
You need to extract first name & last name using formulas.Continue »
Recently I posted about how you could construct dynamic (cascading) dropdowns that could easily handle multiple levels, like this: …and we saw that users could subsequently change upstream dropdowns in a way that would make downstream choices invalid, like this: In my previous post I used some VBA to clear out any ‘downstream’ choices if […]Continue »
Friends and supporters of Chandoo.org,
I am very happy to tell you about another great way to learn Excel & stay awesome
That is right. As part our mission to make you awesome in Excel, this year I will be adding a podcast.Continue »
I have a quick announcement for you.
Only few hours left to join Power Pivot course…
As you may know, I have opened enrollments for our Power Pivot course few days ago. The aim of this course is to make you awesome in Excel, Advanced Excel, Dashboards, Power Pivot & Advanced Power Pivot.
We will be closing the doors of advanced Power Pivot & Bundled options at midnight, today – 11:59 PM, Pacific time, Friday, 21st of February.
If you want to join us, click here and enroll now.Continue »