fbpx
Search
Close this search box.

Celebrate Holi with this colorful Excel file

Share

Facebook
Twitter
LinkedIn

Today is Holi, the festival of colors in India. It is a fun festival where people smear each other with colors, water balloons, tomatoes and sometimes rotten eggs. This year we wanted to play with only water guns, but kids vetoed that idea vehemently. So we ended up driving to my sister-in-law’s place to play with colors (there were no rotten eggs or tomatoes, thankfully). Here is me, standing with a squirt gun and lot of blue.

happy-holi-chandoo

Let me smear a few colors on you

I would love to splash a jug full of color water on you and say Happy Holi. But the internets have not advanced thus far. So I am going to give you the next best option.

An Excel workbook to play holi

Go ahead and download the holi-hai.xlsm. It is fun, interactive & eco-friendly. Just click inside the grid to splash colors. Or press simulate button if you are too lazy.

Here is a demo of the file:

holi-hai-demo

Examine the code in module 1 if you are curious.

 

That is all for now. I will go now and wash my face for the nth time. My cheeks & neck have a sticky pinkish purple hue that won’t go away.

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.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

28 Responses to “Celebrate Holi with this colorful Excel file”

  1. Cesarino says:

    Happy Holi, Happy Excel

  2. Somendra Misra says:

    Happy Holi to you and your Family too Chandoo.

  3. Xcel says:

    Hi,
    In module1, what does randomize do?
    Cheers,
    Xcel
    Holy Greetings!

  4. Ritesh says:

    Happy holi chandoo

  5. Joshua says:

    Happy Holi Chandoo !!!!!!!

  6. says:

    I love receiving your emails. It's seems we know each other. It's nice to practice my english and of course learn more about Excel!

    Thank you very much!

  7. Aslam sultan says:

    Chandoo your are the world of excel.
    Excellent

  8. iwatt1 says:

    That sounds like great fun - Happy Holi to the Chandoo family.

  9. William Truong says:

    Happy Holi Chandoo !
    You made a great design !

  10. Vad says:

    Super Cool .. Happy Holi

  11. Vinod Bisht says:

    Happy colorful excel Holi!

  12. 365 Ninja says:

    Very cool! Happy Holi to you.

  13. ajitkymbhar says:

    Happy Holi to everyone!!! 😉

  14. CDMakk says:

    Fab! Happy Holi, Chandoo and Family.

  15. Daniele says:

    As always, the offerings of excel imagination with a large pinch of indian exuberance!
    Thanks!

  16. Zue says:

    Happy Holi, Chandoo and Family.

  17. Mr Bish says:

    I hope the "new" car was kept clean with all the colours!

  18. zamapon says:

    THANK YOU CHANDOO!!

  19. Ferdous says:

    Thanks a lot.Happy Holi !!!!!!

  20. Rita Brown says:

    Happy holi????????

  21. suresh says:

    Very nice @ Happy holi

  22. Dinesh Bansal says:

    Happppppppppy holiiiiiiiiiiiiiiiiiiiiiiiii

  23. jblanco says:

    Buenos días Chandoo

    Se que podrás traducir este mensaje a través de un traductor. Tu trabajo es impresionante. Tu forma de estructurar la pagina web, tus hojas de excels, todo!! tiene una calidad máxima. ENHORABUENA!!!

    Esta hoja excel es muy divertida!
    Un saludo.

    Google Translate:
    Good morning Chandoo

    Is that you can translate this message through a translator. Your work is awesome. Your way of structuring the website, your sheets excels all !! has a high quality. CONGRATULATIONS !!!

    This excel sheet is very funny!
    A greeting.

  24. Nitin verma says:

    Be lated Happy Holi Chando........N Thanx

  25. Meni Porat says:

    Thanks a lot.
    Awesome as usual
    ???

  26. Mohsen Roudaki says:

    Dear Chandoo
    It was really fantastic & beautiful. Iranian Spring ceremony (Nourooz) will start 1week later. This Excellent Excel File was the best gift for me in Nourooz days.
    Thank You

  27. holi is interesting I see in bollywood film

Leave a Reply