Forum Discussion

tauqeeracma's avatar
tauqeeracma
Steel Contributor
Aug 10, 2022

An Excel-Based Game

This post aims to highlight the power and flexibility of Microsoft Excel that is equally relevant to the non-financial areas.

 

Being an excel enthusiast, I believe that the scope of Microsoft Excel is much broader than it is assumed.

 

To demonstrate the possibilities of using excel in non-conventional assignments, I have tried to design an excel version of a famous board game that is ‘Four-In-A-Row’. This excel-based game can be played between two players. For this post, I got inspiration from ‘Excel as ESport” initiated by FMWC.

 

This game model does not require complex calculations rather it is built using some basic and common excel formulas. The most useful tool for shaping this model is ‘Conditional formatting.

 

 

I am hopeful that this game model will provide some learning opportunities.

 

Feedback and comments from the respected members of this wonderful community will be of great value to me.

 

In my next post, I will share a modified version of the same game that would allow competing against the computer.

 

Thanks,

Tauqeer

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor

    Hi tauqeeracma 

     

    I just downloaded your file and played a few quick matches and I really like it, what a wonderful idea!

    So far, I did not look into the formulas and the logic of how it's built, but it's really nice!

     

    Thanks a lot for this,

    Martin

    • tauqeeracma's avatar
      tauqeeracma
      Steel Contributor
      Hi Martin,

      Many thanks for your comments and appreciation.

      Regards,
      Tauqeer
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    I like it! Very clever and the formulas are clean. I played a few games of 'Connect 4' as a kid. Thanks for sharing.
    • tauqeeracma's avatar
      tauqeeracma
      Steel Contributor
      Hi Patrick

      Thanks a lot for your nice comments.

      Regards,
      Tauqeer
  • Norman_Glenn's avatar
    Norman_Glenn
    Brass Contributor
    Excellent game and well prepared, I will use this to try get kids using computer and excel more to show what can be created.
  • baz's avatar
    baz
    Copper Contributor
    Excellent!! Fabulous job Tauqeer
    • tauqeeracma's avatar
      tauqeeracma
      Steel Contributor
      Thanks Hans for your appreciation, it's valuable for me.
  • aplhajohnny's avatar
    aplhajohnny
    Brass Contributor

    Your creative use of Excel to design a playable version of "Four-In-A-Row" is truly impressive and highlights the versatility of this tool beyond traditional financial applications. Leveraging basic formulas and conditional formatting to build an interactive game demonstrates how even simple features in Excel can unlock innovative possibilities. It’s exciting to see how your project combines learning and entertainment, offering a unique perspective on the potential of Excel. Looking forward to your next post featuring the computer-versus-player version—keep inspiring with your ingenuity!

    • tauqeeracma's avatar
      tauqeeracma
      Steel Contributor

      Hi Aplhajohnny

      Thank you so much for your thoughtful words. I am glad you enjoyed it. This project has been fun to work on. It’s amazing how a tool like Excel, often associated with data and analysis, can also be leveraged for creative and engaging purposes. I firmly believe that the creative possibilities with Microsoft Excel are limitless.

      Your support means a great deal to me and is a powerful motivator to continue exploring and experimenting with fresh ideas. Your belief in my efforts inspires me to push boundaries and think creatively.

      As soon as I can free up some time from my other ongoing projects, I will focus on finalizing the computer-versus-player version. Once it's complete, I will make sure to share it here on this platform for everyone to try out.

      I see myself as a lifelong learner and enjoy following the insights of experts and respected members on this amazing platform. Meanwhile, feel free to explore my other two Excel projects—I’m confident you’ll find them enjoyable too!

      Thanks again for your support.

      Tauqeer

      Wordle with Excel Solver | Microsoft Community Hub

      An Excel-Based Spelling Bee Puzzle | Microsoft Community Hub

      Please note that the previously shared game model has a minor linking issue. Kindly use the revised file, ‘Four in a Row (Corrected)’, for seamless gameplay.

Resources