Author: Adam DuVander

Wimbledon is one of the most prestigious tennis competitions in the world. And where there’s a competition, there are winners. In the case of Wimbledon singles champions, over 100 different gentleman and lady tennis players have won since the formation in 1877. Eleven of these winners may as well have a second home in London, England where the tournament takes place, seeing as they have won Wimbledon six or more times. In total, the incredible Wimbledon singles-winning athletes hail from 16 different countries around the world, some of which make more of a racket at Wimbledon singles tournaments than others. Find out who the ten greatest Wimbledon singles winners are and where they come from, along with the three countries that have taken home Wimbledon gold more often than the rest when you keep reading about where Wimbledon winners are from.

View Where Wimbledon Winners Are From in a full screen map

The map above notes every Wimbledon singles winner since 1877 for the gentlemen and 1884 for the ladies. We got our data here and here. However, you may notice a few years missing. This coincides with World Wars I and II, during which Wimbledon was not held.

The Ten-ish Tennis Players With the Most Wimbledon Wins

Every tennis player who competes at Wimbledon is noteworthy, as is each Wimbledon singles winner. But there are some tennis champions with multiple wins under their belt. The following tennis players have won more Wimbledon singles tournaments than any other competitor:

1. Martina Navratilova, 9 wins
2. Roger Federer, 8 wins
3. Helen Wills Moody, 8 wins
4. Pete Sampras, 7 wins
5. William Renshaw, 7 wins
6. Dorothea Douglass Lambert Chambers, 7 wins
7. Serena Williams, 7 wins
8. Steffi Graf, 7 wins
9. Billie Jean King, 6 wins
10. Blanche Bingley Hillyard, 6 wins
11. Suzanne Lenglen, 6 wins

Martina Navratilova holds the #1 spot for most Wimbledon wins regardless of gender or era. Navratilova first won the courts of Wimbledon in 1978 and last won in 1990. Yet, no one since has won as many Wimbledons. Serena Williams may still have a chance to claim that #1 spot, though. Williams, Pete Sampras, Steffi Graf, William Renshaw, and Dorothea Douglass Lambert Chambers are tied for #3 with the most Wimbledon wins. But while Sampras hasn’t won since 2000, and Renshaw and Chambers are both long past their prime — Renshaw last won in 1889 while Chambers’ last win was just before World War I — Serena Williams won recently in 2016. She may still surpass Martina Navratilova for the #1 ranking amongst Wimbledon singles winners. And, while not in the top ten, Serena’s talented sister Venus Williams is tied for the #5 most Wimbledon wins with five of her own.

More than sorting these impressive athletes by the number of Wimbledon singles wins and their rankings, we can note the countries the champions represented at Wimbledon. Martina Navratilova, Helen Wills Moody, Pete Sampras, Serena Williams, and Billie Jean King all competed on behalf of the U.S. while William Renshaw, Dorothea Douglass Lambert Chambers, and Blanche Bingley Hillyard were all British Wimbledon singles champions. Roger Federer hailed from Switzerland, Steffi Graf played for Germany, and Suzanne Lenglen for France. However, just because these tennis champions brought the most Wimbledon wins than any other player, their country isn’t guaranteed a spot with the most Wimbledon-winning countries in history. Well, except in a few cases.

Countries Making a Racquet at Wimbledon

The United States

Tennis players from the U.S. have won Wimbledon 89 times. Though the U.S. was established well before the first Wimbledon singles competition in 1877, America didn’t bring home a Wimbledon prize until May Sutton won the Ladies’ Singles in 1905. After Sutton’s second win in 1907, the U.S. went through a dry spell. Their next Wimbledon win didn’t come until Bill Tilden won the Gentlemen’s Singles in 1920. From that point on, the U.S. had a Wimbledon winner at least five times every decade. This included Helen Wills Moody, who won Wimbledon consecutively between 1927-1930, and then again in 1932, 1933, 1935, and 1938.

Transitioning from the Amateur Era to the Open Era of Wimbledon for America was Billie Jean King. King first won Wimbledon in 1966, again in 1967, and again once the Open Era started in ‘68. In total, King won two Amateur prizes and four Open Era ones between 1966 and 1975. After King came Martina Navratilova, who we know holds the coveted #1 spot for most Wimbledon wins ever. Navratilova first won in 1978, and again in ‘79. Despite some years where she didn’t win, Navratilova was in it for the long haul. She ended up victorious again in ‘82, and from then on, she was unstoppable, winning consecutively from 1982-1987, and in 1990 for her last victory.

More recent U.S. winners include Pete Sampras, who won from 1993-1995, and again between 1997-2000. Sampras’s win in 2000 was the last for U.S. Gentlemen’s Singles. However, American ladies are doing alright in the 21st century thanks to the Williams sisters. Although it hasn’t just been this century that women in tennis were succeeding. In total, 57 of all the U.S.’s Wimbledon wins were earned by the ladies while 32 were from gentlemen players, however, the Peruvian-born Alex Olmedo may count for another U.S. win. In this century, Venus was the first of the William sisters to win Wimbledon, doing so in 2000. She won again in 2001, but then her sister, Serena showed up on the scene, determined to dominate. For a while, it appeared Venus and Serena Williams would take turns winning Wimbledon; but since 2009, Serena has been the only Williams sister to earn the title. The score is currently Venus: 5; Serena: 7, and thanks to Serena, the U.S. earned its most recent win in 2016.

Australia

Australians are also quite good at tennis. Twenty-six Wimbledon winners have hailed from the land Down Under. Australia’s first winner was in 1907, just six years after the country was formed. This first W was thanks to Norman Brookes. After Brookes, Margaret Smith Court was the first Aussie woman to win Wimbledon in 1963. Interestingly, just nine of Australia’s 26 Wimbledon wins come from the Open Era, when professionals were allowed to compete. The other 17 wins took place during the Amateur Era. But Rod Laver won first place during both eras. He earned two Wimbledon for Australia during the Amateur Era, and then went on to win twice more during the Open Era. Eras aside, 21 of Australia’s wins were earned by the gentlemen and five wins were from the ladies. As for the country’s most recent win, it was back in 2002.

The United Kingdom

If the U.S. and Australia didn’t win their first Wimbledon until the 20th century, which country was coming in first place between Wimbledon’s creation in 1877 and then? In the early years of Wimbledon, the U.K. was the only major winner. They have won Wimbledon 73 times in total, 37 of which are thanks to the gentlemen and 36 are from the ladies. The U.K.’s racquet-welding ladies and gents won Wimbledon 50 times consecutively from its conception in 1877 until America’s May Sutton broke the winning streak of ladies after 21 years and Aussie Norman Brookes broke the 30-year gentlemen’s winning streak in 1907. It’s crazy to think that nearly 70% of the U.K.’s Wimbledon wins come from before 1908.

Notable during the U.K.’s golden age of tennis is William Renshaw, who as we’ve mentioned is tied for the #3 most wins in history (7), his last being in 1889. A historical version of Serena and Venus Williams, William Renshaw’s brother, Ernest, was the one who ultimately ruined William’s winning streak in 1888. For the U.K., the early days of Wimbledon were ripe with even more sibling rivalries. Nine of the U.K.’s Wimbledon wins come from brothers Laurence and Reginald Doherty. However, the gentlemen of the U.K. faced a couple of dry spells. Between 1910 and 1933, the U.K. did not win once for Gentlemen’s Singles. The same can be said between 1937 until 2013 when Andy Murray came to win and ending the long losing streak.

As for the U.K.’s ladies, Blanche Bingley Hillyard, Charlotte Cooper Sterry, and Lottie Dod ruled the tennis game from 1886 to 1901. Hillyard won six Wimbledons, and Sterry and Dod each won five for their country. Dorothea Douglass Lambert Chambers then won seven Wimbledons between 1903 and 1914. However, while the ladies of the U.K. dominated in the early days of Wimbledon, they have yet to win another competition since 1977. The gentlemen, on the other hand, won in 2016.

---

Now that you know where the Wimbledon winners come from, keep an eye out in June and July to see if Serena Williams scores another Wimbledon win and eventually comes for Martina Navratilova’s #1 spot. Either way, it’s a win for the U.S. Another sporting event that takes place over the summer is the Tour de France. You can learn more about the winners, as well as the 2,200-mile route they take each year.

If you’re like us, you use Excel for a lot of things. Even if you have another contacts list, such as Google Contacts, you might find yourself exporting to Excel so you can easily view, sort, and filter. Excel also helps you prepare your list of names and addresses in a structured way so you can easily print them on address labels. Assuming you already have that Excel document with your list of friends, customers, leads, or other contacts, you are ready to go.

As with all things Microsoft, there is more than one way to accomplish what you need. For instance, there are many ways to start the Mail Merge process. We’ll describe just one of the easy ways to create labels with Mail Merge.

Note: In addition to labels, you can import your address list into Google Maps to create a map of sales leads, customers, friends, or other contacts.

How to Start

The first thing to know about creating a successful Mail Merge is what you are going to be creating, and to whom will you be sending it. Collect this data in your Excel spreadsheet, or create a list within Word. Let’s pretend we want to send out query letters to a few publishers for your great American novel. We’re going to make labels for envelopes with the following information:

• Company Name
• Contact Name
• Title
• Address Line 1
• Address Line 2
• City
• State
• Zip

The Mailing Tab

We’ll start from Word and the following instructions should work for Word 2010 on up. Open your Word program and click on the Mailings Tab.

Take this chance to save your document. If you can, turn on Autosave. It’s up in the upper left corner if you save your documents on OneDrive or a SharePoint server.

Gather Your Data

Double check that you have an Excel document ready with addresses, or add these examples we will be using:

Company Name	Contact Name	Title	Address Line 1	Address Line 2	City	State	Zip
Simon & Schuster	Burt Reynolds	Publisher – 37 Ink, Atria Publishing Group	1230 Avenue of the Americas		New York	NY	10019
Random House – Penguin	Donna Cortez	Senior Editor	1745 Broadway	Harmony	New York	NY	10019
Harper Collins	Becca Seacrest	Executive Editor	195 Broadway	22nd Floor	New York	NY	10007
Abrams	Zoë Kavinsky	Editor	195 Broadway	9th Floor	New York	NY	10007
Hatchette Book Group	Jamie Lynn		1290 Avenue of the Americas	Little, Brown	New York	NY	10104

Now we can begin using the Mail Merge wizard.

Begin the Wizard

The wizard is the place to begin. When it starts, a new pane will open on the right of your Word screen. It looks like this:

1. Choose the type of document you want to create. In this instance, we’ve selected “Labels.”
2. Click Next: Starting document

After you click Next, you have three choices.

If you already had something you wanted to use, select either of the second or third options. Since we’re starting from scratch, we chose, “Use the current document.”

Click Next: Select recipients

Enter Your Data

This is the important part of Mail Merge. You have several choices for data. If you’re using an existing list (usually one from an Excel file, but there are many other data types from which Word can extract data), you would choose “Browse” under Use an existing list. You can also use Outlook contacts if you have it. If you had already opened a list, you could also edit it from here.

You can also start from scratch when you click on “Type a new list” in the Select recipients group.

Click Next: Write your letter

When you click Next, a new window will pop up where you enter your data.

If you look at the field labels at the top, you may notice that it has labels for things the data did not include. You need to remove those fields before adding your own. To do this, click the “Customize Columns” button on the bottom left of the pop-up window.

Customize Columns

A new window will pop-up.

Enter in your data, pressing the tab button between every entry to continue to the next field. Once you’ve entered your data, click OK.

You will be asked to save your list. Word automatically saves your data as an Access Database file, and it automatically puts it into the default folder for Word’s data. Name it as something you will remember. Mailing Labels for Submissions, perhaps.

Click Save. Click OK.

You’ll notice on the wizard pane, that “choose an existing list” is now highlighted.

Click Next: Write your letter

Once you have successfully input your data and explored the wizard, close the wizard by clicking the X at the top right corner. Now you’ll work on our labels using the ribbon.

Use the Ribbon to Finish Your Labels

If you have a certain type of label you are using–such as: Avery Easy Peel Address Labels (5160)–then click on the “Start Mail Merge” button and choose “Labels.” Do not choose labels from the Create group as it just allows you to quickly print labels.

You will use this pop-up window to choose your type of label. Check the packaging for the labels’ number, so Word knows what you are talking about.

Sometimes, it is hard to find your label type, but most of the time you can. For ours, we had to look under, “Avery US Letter,” as they are in order by size of paper. Then we had to scroll all the way down to find 5160 Easy Peel Labels. When you find your label, Click OK.

Word will tell you it has to delete everything from the document. Go ahead and click OK since we have a blank document anyway.

As you can see, Word automatically propagates all the labels with <<Next Record>>

However, your “Address Block” has not yet been added, so no records would appear if you tried to finish it now. So, in the Write and Insert Fields group on the ribbon, click “Address Block.” Since your cursor is already at the right cell in the table, it will put <<AddressBlock>> in that cell. Now you’re ready to merge!

Merge Your Labels

When you click Address Block, a pop-up window will open, asking you to choose the way you want your addresses to look. We went with the default settings and hit OK.

You will now see <<AddressBlock>> in the first cell.

Click Update Labels in the Write and Insert Fields group on the ribbon.

Now your document should look something like this. Notice how <<AddressBlock>> Was thrown into every empty cell.

When you click “Preview Results,” it will propagate all fields. You may also notice that it looks terrible — Word added spaces between every line. Don’t worry, we’ll fix that quickly.

If you renamed a field, you may notice it is not showing up. To fix this, click the “Match Fields” button in the Write & Insert Fields group on the Mailings ribbon. We had to do this because we renamed “First Name” to “Contact Name.” By clicking on “Match Fields” we were able to choose what fields in our data match the fields that Word uses.

Edit and Make Pretty

To make your Mail Merge look more aesthetically pleasing, click on the little Plus sign on the table to choose the entire table OR click CTRL+A to select all. You can also click on the Select button in the Editing group on the Home tab and choose Select All. Word likes options.

Now go the Home tab on your ribbon. With your document text still selected, click on the little arrow on the bottom right of the Paragraph group on the Home tab.

A new window will pop-up.

Check the box that says, “Don’t add space between paragraphs of the same style.”

Click OK.

Now, go back to the Mailings Tab.

Click, “Finish & Merge” in the Finish group on the Mailings tab.

Choose which records you want to use (we are using all records).

A new document will open containing your labels—ready to save and print!

Keep in mind you don’t have to use labels just for mailing. You can make gift tags, labels for products you sell or give away…the mind boggles with all the choices. Your imagination is the only thing stopping you from using Excel and Word to label your entire life.

Bring Your Excel Data Into the Real World

You’ve printed your addresses on labels, so that’s one way to add them to the real world. Every day thousands of BatchGeo users turn their spreadsheets into maps for research, community, and sales purposes. You can simply copy-paste to create a map, then share it with colleagues or friends.

View Santa Monica Mechanics (With Images) in a full screen map

Or, heck, maybe you’re just curious where all your friends live? Make a map of your holiday card list.

It’s been more than 40 years since Margaret Thatcher became the first female Prime Minister of the United Kingdom. To celebrate Thatcher’s achievements, we mapped all 54 of the United Kingdom’s Prime Ministers, their hometowns, and more.

But first, let’s talk about why Margaret Thatcher is so special. Did you know that if Thatcher were a Duchess, she would have a completely different title from every other Prime Minister to date? Also special about Thatcher is her hometown. She didn’t grow up in a place that produced many Prime Ministers. Plus, she is one of the top five Prime Ministers with the longest term length. However, Thatcher also has a few commonalities with the Prime Ministers of the past. For example, she aligns herself with the most-elected Prime Minister political party of all time.

Now that you know all about Thatcher, it’s time you get to know the titles, hometowns, term lengths, and political parties of the rest of the U.K.’s Prime Ministers.

View Prime Ministers by Hometown in a full screen map

Click around the map above to learn facts about each of the United Kingdom’s 54 Prime Ministers. Then, read on for the trends we pulled from the data.

Prime Minister’s Ever-Changing Roles, Titles, & Parties

The role of the U.K. Prime Minister is quite simple: be the head of government for the entire country. The Prime Minister is in charge of the executive branch of government and holds a house majority within the legislature. The PM may also add “enacting the monarch’s will” and “advisor to the King or Queen of the United Kingdom” to their resumè.

Alternating Titles of the Prime Minister

If, after taking a look at the map, you’re wondering, what is up with all these names, you’re not alone. We were also curious about what The Right Most Graceful could signify. As it turns out, there are three different titles a newly-minted Prime Minister may be dubbed:

• His Grace
  • Dukes or Duchesses
• The Most Honourable
  • Marquesses
• The Right Honourable
  • Everyone else

Forty-seven Prime Ministers our of 54 hold the title of “The Right Honourable,” spelled in the way only the British would. If you yourself manage to score the position of PM, you too will likely be referred to as “The Right Honourable.” This is the automatic title for the Prime Minister, but some may be called “The Most Honourable” instead of “The Right Honourable.” This title is reserved for PMs who already are Marquesses, of which there have been two in history. These folks are Marquesses and Prime Ministers, making the distinction necessary. If a Prime Minister turns out to be a step above a Marquess, called a Duke, they get a title fit for a king: His Grace. Five Prime Ministers earned this title. We want to know if Margaret Thatcher was also a Duke — or Duchess in this case — would we call her Her Grace? Or would we see the creation of an all-new title?

Prime Minister Party Time

By our count, the most popular Prime Minister political party have been the Conservatives. Seventeen of the 54 PMs were of the Conservative party. The second most common party of PMs are the Whigs, of which there were 13. There have also been nine Tory-affiliated Prime Ministers and five Liberal PMs. There have also been five Labour candidates who won the highest elected office in the U.K. Finally, there has been one Peelite Prime Minister, along with others who transitioned from one political party to another. You can see who jumped their party’s ship on the map above by sorting by Party.

Where Do Most Prime Ministers Grow Up?

It may not come as much of a surprise to find out that the majority of the United Kingdom’s Prime Ministers hail from London, England. After all, London is the capital and the largest city in both England and the United Kingdom. Not only that, but there are the Prime Ministers who were born in the city of London and those who were born in Middlesex, an ancient county in England that is now entirely within the area of London. In total, fifteen Londoners and Middlesexers went on to become Prime Minister, indicating that if being PM is your goal, you may want to be born in London. Send a letter to your parents from the womb, Prime Minister hopefuls.

In addition to London, those from Yorkshire can also find hometown representation in Prime Ministers. There have been four PMs who call Yorkshire home. Edinburgh, Scotland, and Lancashire, England each churned out three PMs as well. Finally, Buckinghamshire, Kent, Surrey, and Sussex, England along with Dublin, Ireland produced two Prime Ministers each.

Non-Native PMs

While today the United Kingdom is made up of England, Northern Ireland, and Scotland, this hasn’t always been the case. At one point, Scotland and Ireland were separate from England. However, this history didn’t stop the following men from becoming Prime Ministers.

The Right Honourable William Petty, Prime Minister beginning in 1782 and Field Marshal His Grace Arthur Wellesley (1828) may have been in charge many years apart, but they are both from Dublin, Ireland. They are the only two Irish-born Prime Ministers in history. The Right Honourable John Stuart (1762), The Right Honourable George Hamilton-Gordon (1852), and The Right Honourable Tony Blair (1997) were all born and raised in the capital of Scotland: Edinburgh.

Other notable Scots who held the title include The Right Honourable Arthur Balfour, from East Lothian who became Prime Minister in 1902, The Right Honourable Sir Henry Campbell-Bannerman from Glasgow, who was PM in 1905, The Right Honourable Ramsay MacDonald hailing from Moray and Prime Minister in 1924, and more recently, The Right Honourable Gordon Brown from Renfrewshire, Scotland who was Prime Minister from 2007 to 2010. As for the single North American Prime Minister in the United Kingdom? The Right Honourable Bonar Law was from Kingston, Colony of New Brunswick, which is now apart of Canada. He became Prime Minister in 1922.

Double Dipping Prime Ministers

Unlike in the United States, as long as a PM win elections, he or she may continue to serve as Prime Minister until their passing.

These PMs each has been elected into the position two times:

• His Grace Thomas Pelham-Holles
• The Most Honourable Charles Watson-Wentworth
• The Right Honourable William Pitt the Younger
• His Grace William Cavendish-Bentinck
• Field Marshal His Grace Arthur Wellesley
• The Right Honourable William Lamb
• The Right Honourable Sir Robert Peel
• The Right Honourable John Russell
• The Right Honourable Henry John Temple
• The Right Honourable Benjamin Disraeli
• The Right Honourable Ramsay MacDonald
• The Right Honourable Sir Winston Churchill
• The Right Honourable Harold Wilson

More unbelievable are the Prime Ministers who went on to serve a third term:

• The Right Honourable Edward Smith-Stanley
• The Most Honourable Robert Gascoyne-Cecil
• The Right Honourable Stanley Baldwin

And finally, just one PM served four terms: The Right Honourable William Ewart Gladstone

The Longest Terms

The Right Honourable Sir Robert Walpole’s time as Prime Minister lasted for 7,615 days or nearly 21 years. This is the longest of any Prime Minister ever. The next longest term belongs to The Right Honourable William Pitt the Younger. He served for 6,291 days (just over 17 years) during his first term. He then went on to serve a second term of one year and 259 days, for a total of 6,915 days in office. Finally, The Right Honourable Robert Jenkinson served the third longest term of 5,416 days or 59 days short of 15 years.

---

Now that you’ve become an expert on all things Prime Minister, it’s time to do the same with analyzing data in Excel. And if we’ve piqued your interest enough in the U.K., note that with BatchGeo you can easily geocode international addresses, including places where you’ve been (and where you want to go) in the U.K. or elsewhere.