Home - Excel - Word - PowerPoint - Tennis

Since one of my professional skills is in Microsoft 365 , I thought it would be cool to apply a professional skill to my personal interest. Tennis has always been my favorite sport to watch and follow. There is data involved with the number of tournaments played, number of titles won, wins, losses, and winning percentile ranges. So, I created an ongoing, long-term, YTD [year-to-date] portfolio, based on the sport.For the number of the tournaments played, number of titles won, wins, losses, and winning percentile ranges, I knew that it would be best to organize this data is in Excel. I wanted to know where all the singles Grand Slam Champion is ranked, based on their winning percentile ranges from each year. I collected data for the following players:

WTA [Women's Tennis Association]

  1. Serena Williams (USA)
  2. Iga Świątek (POLAND)
  3. Kim Clijsters (BELGIUM)
  4. Maria Sharapova (RUSSIA)
  5. Ashleigh Barty (AUSTRALIA)
  6. Venus Williams (USA)
  7. Na Li (CHINA)
  8. Elena Rybakina (KAZAKHSTAN)
  9. Victória Azárenka (BELARUS)
  10. Aryna Sabalenka (BELARUS)
  11. Caroline Wozniacki (DENMARK)
  12. Simona Halep (ROMANIA)
  13. Coco Gauff (USA)
  14. Petra Kvitová (CZECH REPUBLIC)
  15. Ana Ivanović (SERBIA)
  16. Markéta Vondroušová (CZECH REPUBLIC)
  17. Svetlana Kuznetsova (RUSSIA)
  18. Bianca Andreescu (CANADA)
  19. Emma Raducanu (GREAT BRITAIN)
  20. Garbiñe Muguruza (SPAIN)
  21. Angelique Kerber (GERMANY)
  22. Barbora Krejčíková (CZECH REPUBLIC)
  23. Madison Keys (USA)
  24. Naomi Osaka (JAPAN)
  25. Jeļena Ostapenko (LATVIA)
  26. Marion Bartoli (FRANCE)
  27. Sonya Kenin (USA)
  28. Sam Stosur (AUSTRALIA)
  29. Sloane Stephens (USA)

ATP [Association for Tennis Professionals]

  1. Novak Djokovic (SERBIA)
  2. Rafael Nadal (SPAIN)
  3. Carlos Alcaraz (SPAIN)
  4. Jannik Sinner (ITALY)
  5. Andy Roddick (USA)
  6. Andy Murray (GREAT BRITAIN)
  7. Juan Martín Del Potro (ARGENTINA)
  8. Daniil Medvedev (RUSSIA)
  9. Marin Čilić (CROATIA)

After I collected the data for each player, I put everyone's data together and created two new separate Excel spreadsheets, one for the women and the other for the men. Each spreadsheet has the number of tournaments played, number of titles won, wins, losses, and winning percentile range. All those pieces of data start from the year each player made their debut on tour until the current year.

I also included a Word document, titled, "Unmatched Consistency - A Tennis Journey to Finals Without Dropping a Set". I wrote about my favorite tournaments from all four Grand Slams and other tournaments on both the ATP [Association for Tennis Pros] and WTA [Women's Tennis Association] tours from certain years. I also wrote about different players and doubles teams. The players' and doubles teams' names were my headings, while the tournaments were my subheadings. My thesis statement showcases how each player's or teams' playing styles helps them reach multiple finals without dropping a set.