fbpx
Search
Close this search box.

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

Share

Facebook
Twitter
LinkedIn

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.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

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