Close this search box.

A quick Excel tip while on bike…



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.


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.

– 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.

Announcing Power BI Dashboard Contest 2024

Announcing Power BI Dashboard Contest (win $500 prizes!)

Hey there, I have a SUPER exciting announcement! April is about to get a whole lot sweeter with our Power BI Dashboard Contest! Your mission, should you choose to accept it: Craft the most EPIC dashboard for the Awesome Chocolates CEO with sales & financial insights! Winners stand a chance to score up to $500 in Amazon Gift Cards, plus some serious bragging rights!

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!


  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:



    Hope you had a great time.


  6. Brandon says:


    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!

  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


  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

  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!

Leave a Reply