Family Best Time >> Work

Compete to be Excel world champion Pass the tests this week

Ladies and gentlemen, time to start your spreadsheets, fine-tune those formulas 3 Crazy Excel Formulas That Do Amazing Things 3 Crazy Excel Formulas That Do Amazing Things Conditional formatting formulas in Microsoft Excel can do amazing things. Here are some Excel formula productivity hacks. Read More That's right:the world's favorite spreadsheet software now has a competition sponsored by Microsoft, complete with a grand prize for the overall winner.

Participants in the Excel World Championship will be tested in several key areas of Excel. They will be vying for “a trip to Seattle, USA and a meeting with Excel Product Leads to provide feedback on the following features added to Excel.” And of course, the title of “Excel World Champion” will be awarded to the final winner. Add that to your letterhead!

Format of the competition

Courageous competitors must display exceptional skills in the following areas:

  • Data relays - Access, structure, manage and manipulate data..
  • Gym card - Visually represent data to better tell a story, as judged by our panel of experts and this Excel community.
  • Wrestling formula - Using Formulas to Solve Questions Dynamically 16 Excel Formulas to Help You Solve Real-Life Problems 16 Excel Formulas to Help You Solve Real-Life Problems The right tool is half the work. Excel can solve calculations and process data faster than your calculator can. We show you the key Excel formulas and show you how to use them. Read More

As expected with a competition, it won't be easy. Competitors will be notified when a test spreadsheet is activated. Those who compete must download the test, complete it, and return it to the email address provided at the time (“Details on where to send your workbook will be provided with the test.”).

Competitors will be graded based on their performance in the aforementioned areas. The weighting for those areas is as follows:Data Relays (35%), Chart Gymnastics (30%, Community Driven), Formula Wrestling (35%).

“Community-driven” refers to the Excel technology community. Competitors will upload their gymnastics gyms to a public area and receive votes. This seems like an interesting idea for a competition. Since this will be a public vote, I'm sure it will be susceptible to the same “hive mind” social influence bias How Upvote Systems Have Damaged Online Communities How Upvote Systems Have Damaged Online Communities Read more than we see in other open voting systems.

Competition dates and entry requirements

If your interest has been motivated enough, make a note of the start and end dates of the competition.

  • Round 1 “Trials” - October 3 at 00:00 UTC until October 9 at 23:59 UTC
  • Round 2 “Qualifying Qualification” - Oct 12 00:00 UTC to Oct 21 23:59 UTC
  • Round 3 “Semifinals” - October 26 00:00 UTC to November 2 23:59 UTC.
  • Round 4 “Finals” - November 18 00:00 UTC to November 18 23:59 UTC

The first two rounds are open to everyone. After the second round, all entries will be judged based on the criteria detailed in the next section.

Determining a winner

All entries will be reviewed at the end of each round. The following criteria will be used to select the winners:

  • 25% - Data accuracy
  • 10% - Data access and structure
  • 30% - Social score
  • 25% - Precision of the formula (response to the question with current data and response to the question with updated data)
  • 10% - Formula Efficiency (higher score for using fewer formulas and arithmetic operations)

After the second round, the Top 20 highest scoring entries will progress After the third round, the Top 3 highest scoring entries will progress The fourth round will see the highest scoring entry declared excel world champion.

Entrance requirements

The competition will be held under the banner of the Excel World Championship, but there are entry restrictions for several countries:

  • Belgium
  • Canada
  • Chinese
  • Denmark
  • Finland
  • Japan
  • Malaysia
  • Mexico
  • Philippines
  • South Africa
  • Sweden
  • turkey

Residents of those countries can find information on how to enter by following this link.

Otherwise, you will be proving your worth in the international group. Whether or not this increases competition remains to be seen. I imagine the bar will be quite high!

Tips for judgment

The first trial book can be downloaded via this link.

Compete to be Excel world champion Pass the tests this week

Here are my immediate impressions:Power Query and Power Pivot will definitely be your friends on the first task. However, some users have reported difficulties using those tools within the protected workbook. This means that in order to complete the test, you will have to come up with a solution.

Compete to be Excel world champion Pass the tests this week

The second task tests your graphic skills. The data provided should give you ample opportunity to show off your prowess. That said, if you're stuck on an aesthetic, why not look at the existing submissions (scroll down to comments) for inspiration?

Warning - Increase the ones you find interesting and display the data accurately. This section considers the opinion of the community as well..

The final section requires you to answer a series of questions using formulas. The questions should be relatively easy, especially for those using the built-in features offered in Excel 2016. Remember, judges want the right answer, but they also want a nice, efficient formula. You will lose points if your formula is complicated or too complicated. Keep it simple!

Compete to be Excel world champion Pass the tests this week

Compete with the best

Do you have what it takes to become the first Excel World Champion? Microsoft proporciona regularmente patrocinio para otras competiciones. Proporcionan un escenario saludable para el desarrollo tecnológico y permiten a Microsoft la primera mirada a algo innovador. Lo más importante es que les dan a los competidores la oportunidad de ilustrar su experiencia en cualquier área, con la posibilidad de ganar premios emocionantes..

Y seamos sinceros, a todos les encanta un premio emocionante..

¿Crees que tienes lo que se necesita? ¿Crees que el nivel de experiencia será demasiado alto? ¿Qué competiciones patrocinadas por Microsoft le gustaría ver a continuación? Let us know your thoughts below!