fbpx
Search
Close this search box.

A quick Excel tip while on bike…

Share

Facebook
Twitter
LinkedIn

As you may know, I am in USA and having a lot of fun exploring new areas, meeting people and conducting live classes. While all of this is enjoyable, I am also feeling guilty because I am unable to squeeze time to share Excel tips on the blog.

So to make it up to you, I recorded this short video (2 mins) with an Excel tip while bicycling in beautiful Euclid Creek Reservation in Cleveland on Friday. Watch it below.


[Watch this video on our youtube channel]

Related: More keyboard shortcuts and a game to test your Excel keyboard skills.

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.

22 Responses to “A quick Excel tip while on bike…”

  1. Nikki says:

    Glad you are having fun Chandoo! We miss you........

  2. Ravi Kiran says:

    Ride safe Chandoo. I wish you had your helmet on, especially when you make videos like this 🙂

    Good to know that you were enjoying!

    cheers,
    Ravi.

  3. Rasheed says:

    Great Tip ... Really that you are an excel addicted 🙂

  4. Norries says:

    Hello, Chandoo.

    Looking forward to your next awesome excel tips. It has been awhile.

  5. Sathish Kumar Barla says:

    Boss,

    Super...

    Hope you had a great time.

    Sathish

  6. Brandon says:

    Chandoo,

    Great tip! This will cut a lot of time out of many of the spreadsheets I work with.

    Can't wait for more tips!

  7. Erica says:

    Thanks Chandoo!! Nice quick and handy tip!! Enjoy your trip!
    Erica

  8. Paula Vermilya says:

    Chandoo, if you come to Georgia, you are welcome to stay with us. We have mountains, Atlantic ocean shores, old historical cities (Savannah), and a great bike track in North Ga., not far from our house. We are about 20 minutes north west of Atlanta. The North Georgia Mountains offer 70 different mountain bike trails to choose from, some of which lead to some of North Georgia's 64 waterfalls. We have a nice upstairs we do not use with 3 bedrooms and a bath. Our house is open to you. I have been following you for yrs. and have been an excel star due to what you have taught me. Thanks, Paula

  9. shree says:

    Gr8, Marvelous tip.Thanks

    Shree

  10. Chaithali says:

    Superb tip Chandoo. thanks a lot.

  11. Felisha says:

    Great Tip...can't wait to try this one out! Be careful out there!

  12. ianamck says:

    Keep on biking chandoo

    we all miss your awesome tips

    You will have to make it up to us all when you get back

  13. Stef@n says:

    cool !
    a new type of presentation !
    enjoy america
    Regards
    Stef@n

  14. prashanth says:

    Hi Chandoo ,

    Congrats on your achievements , I just wanted to know if you need any permissions to earn in US (or any foreign country ) like the way you are doing

  15. Camille says:

    I enjoyed your video and tip. Thanks for bringing us along!

  16. dan l says:

    I would have loved to have seen the other people in that park as they passed by chandoo.

  17. David says:

    Great tip Chandoo!
    I recently found some other interesting shortcuts to format numbers really easily:

    ctrl + shift + ! (number with 2 decimal points)
    ctrl + shift + @ (time format)
    ctrl + shift + # (date format)
    ctrl + shift + $ (dollar/currency format)
    ctrl + shift + % (percents format)

    Don't know whether these are known around here... I found them very useful and I am using them all the time!

  18. John says:

    Video was really nice. Loved the tips as well. Thanks for putting up such content .

  19. Many thanks for that tip Chandoo, I knew it worked on data but not on CHART components, thats brilliant and very quick.

    I also like using Ctrl + T and return from inside a data range to quickly convert it to a data table in Excel 2007/2010 this is very nice.

  20. Rob says:

    I've been wanting to do a bike vid like this for quite some time. Last time I tried it though - on that same bike by the way! - I got way too much vibration noise from the road. How did you dampen that? 🙂

  21. saju says:

    im with chandoo.org seince 3 years. i learn excel from it. its realy owsome. today i meet the real chandoo After using chandoo.org 3 years. i think its my birthday gift. today is my birthday.

  22. Mandar says:

    Good to know that you were enjoying!
    cheers,
    Mandar

Leave a Reply