CP033: There is an Easter egg in this podcast!!!

Posted on April 9th, 2015 in Chandoo.org Podcast Sessions - 6 comments

In the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips.

CP033 - There is an Easter egg in this podcast - Excel tips from Chandoo.org podcast listeners

What is in this session?

This session has 2 things.

  • A surprise Easter egg (an Excel tip hidden in the podcast audio)
  • Collection of Excel tips recorded & submitted by Chandoo.org readers

Listen to this session

Click here to download the MP3 file.

 

Links & Resources mentioned in this podcast

Keyboard & Mouse shortcuts

Chart formatting tips:

Transcript of this session:

Download this podcast transcript [PDF]

Did you find the Easter egg?

Now that you  found the Easter egg, it is your turn. Go ahead and leave a comment with cryptic message. Share your favorite Excel tip or ideas with us.

Thanks to the contributors

Many many thanks to both Roberts, Micky, TJ, Val & Orkun. It was fun learning from you.

Written by Chandoo
Tags: , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

6 Responses to “CP033: There is an Easter egg in this podcast!!!”

  1. Evaun says:

    The podcast audio goes into 'slow motion' around the 17:15 mark. Not sure if it's just me, but I can understand everything until that time.

    • Paul says:

      Hi Evaun
      I think Chandoo got Jabba The Hutt to give his favourite tip for the pod cast 😀

      • Carlitos Barboza says:

        Oh come on Chandoo! It is not very understandable! Please could you write it down? Greetings from Carlos, Lima Peru!

    • Carlitos Barboza says:

      hehe after listening 3 times, finally got it!

      It is the multi-select trick with holding down CTRL keyboard and clicking or selecting with the mouse; ranges o indivual cells when you are on editing mode on a formula! I hope you can understand this short explanation. Please if not, let me know to better explain it!

      Best to all, from Lima Peru!

  2. Leonard says:

    Hi Chandoo, I'm late to this party but really enjoy your podcast. I'd like to leave one of my favorite tricks, kind of a strange one.

    Sometimes when you import data into Excel you will get dates or numbers that are actually text strings. I see this a lot with dates in particular. If you try and do any lookups or sumifs on these "numbers" you will get an error since Excel thinks the numbers are words. An easy way to solve this is to add a helper column where you multiply the "numbers" by 1 and do your lookups or sumifs off this helper column. Multiplying by 1 gets excel to realize that what it thinks is a text string is really a number, I believe adding 0 would have the same effect. Cheers, stay awesome!

  3. Nancy L. Scheibel says:

    I'm just starting out. Could you please make everything very easy for me to begin with?
    I'll work really hard to get caught up.
    Thanks.

    Nancy

Leave a Reply