Cricket World Cup 2015 in Excel

[indzara]

My first attempt to capture a Cricket tournament in Excel.

http://indzara.com/2015/04/cricket-world-cup-2015-free-excel-dashboard/

I look forward to hearing your feedback. Thank you.

 

[NARAYANK991]

Hi ,

I think it has been well done.

I would like it if you could include the nationalities of the players whose performances have been listed in the CUP view viz.

Top Batting Performances
Most Runs Scored
Top Bowling Performances
Most Wickets Taken

Would it be asking for too much if I asked whether you could include a PLAYER view ?

Interactively selecting the player's name would bring up all of his statistics.

Narayan

 

[indzara]

Thank you very much for the quick response.

Both suggestions are valid. I will include this in the next update.

Thanks again. Best wishes.

 

[Hui]

You may also want to have a look at:
Http://blogs.office.com/2015/04/03/cricket-world-cup-fever-analyzing-the-data-with-power-query/

 

[ashish mehra]

My first attempt to capture a Cricket tournament in Excel.

http://indzara.com/2015/04/cricket-world-cup-2015-free-excel-dashboard/

I look forward to hearing your feedback. Thank you.

Hi Indzara,

Try this link: http://chandoo.org/forum/threads/cricket-world-cup-1975-2015.22345/

Regards,
AM

 

[indzara]

You may also want to have a look at:
Http://blogs.office.com/2015/04/03/cricket-world-cup-fever-analyzing-the-data-with-power-query/

Thanks, Hui. I will look into this. I have not used PowerView until now. I should.

 

[indzara]

Hi Indzara,

Try this link: http://chandoo.org/forum/threads/cricket-world-cup-1975-2015.22345/

Regards,
AM

Thanks for sharing. It is great to show data for all world cups. I don't know VBA. I am assuming you are extracting the data from somewhere online automatically. That's very impressive. One day, I will try to understand how to do it.

Best wishes.