Home - Excel - Word - PowerPoint - Tennis

Since one of my professional skills is in Microsoft Office applications, 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’s 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. Aryna Sabalenka (BELARUS)
  2. Coco Gauff (USA)
  3. Elena Rybakina (KAZAKHSTAN)
  4. Markéta Vondroušová (CZECH REPUBLIC)
  5. Victória Azárenka (BELARUS)
  6. Sloane Stephens (USA)
  7. Petra Kvitová (CZECH REPUBLIC)
  8. Sonya Kenin (USA)
  9. Caroline Wozniacki (DENMARK)
  10. Naomi Osaka (JAPAN)
  11. Bianca Andreescu (CANADA)
  12. Emma Raducanu (GREAT BRITAIN)
  13. Angelique Kerber (GERMANY)
  14. Venus Williams (USA)
  15. Garbiñe Muguruza (SPAIN)
  16. Simona Halep (ROMANIA)
  17. Serena Williams (USA)
  18. Ashleigh Barty (AUSTRALIA)
  19. Maria Sharapova (RUSSIA)
  20. Na Li (CHINA)
  21. Sam Stosur (AUSTRALIA)
  22. Svetlana Kuznetsova (RUSSIA)
  23. Marion Bartoli (FRANCE)

ATP [Association for Tennis Professionals]

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

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’ll break this project down into small pieces to show you guys how to put it together, step-by-step. I wrote out the documentation in Confluence, which is a collaboration tool that help teams to collaborate and share knowledge efficiently. Confluence can also be used to create pages and store information. Since Confluence lets me export pages to Word, I chose to export my Confluence pages to Word documents. That way, it'll make it easier for you guys to view my pages:

  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • 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.