How to Make Cricket Scorecard in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate how to make a cricket scorecard in Excel. The cricket scorecard displays the total collection of runs for a team with how many wickets they have lost. It not only gives us the details of a team’s performance but also tells us the overall situation of the game. This scoreboard can also show the summary of the whole cricket match. So, making a cricket scorecard in Excel is very important.


How to Make Cricket Scorecard in Excel: with Easy Steps

Our goal is to make a cricket scoreboard in Excel. If you follow the following steps correctly, you should learn how to make a cricket scorecard in Excel on your own. The steps are:

Step 1: Creating Batting Scorecard

At the very beginning, we will aim to create a batting scoreboard. To fulfill that goal, we have to follow the below procedures.

  • First, create a dataset like the below image. In this case, we have the Names in Column B, Runs in Column C, Balls in Column D, 4s, and 6s in Column E and F, and Strike Rate in Column G.

Procedures to Make Cricket Scorecard

  • Next, input the data of the game manually in the cells.

Procedures to Make Cricket Scorecard

  • After that, in cell G6 insert the following formula.
=(C6/D6)*100

Procedures to Make Cricket Scorecard

  • Furthermore, press the Enter button to get the result for that cell.
  • Then, use the Fill Handle to apply the same formula to all the desired cells.

Procedures to Make Cricket Scorecard

  • After that, you will get the below result.

Procedures to Make Cricket Scorecard

  • Next to that, in cell C17 insert the following SUM formula using the SUM function to get the total run.
=SUM(C6:C16)

Procedures to Make Cricket Scorecard

  • Afterward, you will get the total runs in the cell.

Procedures to Make Cricket Scorecard

  • Again, use the same formula as the previous step in cells D17, E17, and F17 to get the number of total Balls, total 4s, and total 6s.

Procedures to Make Cricket Scorecard

  • Finally, you will get the desired batting scoreboard.

Procedures to Make Cricket Scorecard

Read More: How to Calculate Total Score in Excel


Step 2: Making Bowling Scorecard

Now, we will try to make a bowling scoreboard. To do so, we have to follow the below steps.

  • At first, we have to arrange a dataset. In the dataset, we have the Names in Column B, Overs in Column C, Maidens in Column D, Runs in Column E, Wickets in Column F and Strike Rate in Column G.

Procedures to Make Cricket Scorecard

  • Second, manually insert the data of the game.

Procedures to Make Cricket Scorecard

  • Third, insert the following formula in cell G6 to get the Economy Rate.
=E6/C6

  • Fourth, you will get the result after pressing the Enter button.
  • Next, use the Fill Handle option to apply it to all desired cells.

  • Last, you will get the desired bowling scorecard.

Read More: How to Create a Scoring System in Excel


Step 3: Presenting Summary of Scorecard

In this last step, we have to show the summary of the game of an innings. We can do it by following the below steps.

  • To begin with, you have to create a dataset. In the dataset, we have the Final Score in Column B.

  • In addition, we input the data manually in this format(Total Runs/Total Wickets).

  • Furthermore, input the two highest run-getters in the left-side column and the two highest wicket-takers in the right-side column.

  • Finally, you will get the desired result.


Things to Remember

  • We have shown the scorecard for an innings of the game. If you want to create the whole game summary, you have to do the same step for the 2nd innings also.
  • You can create the scorecard, but you have to input the data manually.
  • You can easily change the color of the scorecard according to your wish.

Download Practice Workbook

You can download the practice workbook from here.


Conclusion

Henceforth, follow the above-described methods. Thus, you will be able to show how to make a cricket scorecard in Excel. Let us know if you have more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Zehad Rian Jim
Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo