In the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips.
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
Podcast: Play in new window | Download
Subscribe: RSS
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.
6 Responses to “CP033: There is an Easter egg in this podcast!!!”
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.
Hi Evaun
I think Chandoo got Jabba The Hutt to give his favourite tip for the pod cast 😀
Oh come on Chandoo! It is not very understandable! Please could you write it down? Greetings from Carlos, Lima Peru!
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!
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!
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