Home

#ExcelChampINTL

Highlighted
Microsoft Excel
Microsoft

#ExcelChampINTL

Do you think you have what it takes to be the Excel World Champ?

We want to test your skills and creativity!

 

From October 2016 to November 2016, Microsoft will run a special 4-round Excel competition for residents of select countries. Only the top competitors in each round will make it through to the next. Our finalists will compete against one another for the title of Excel Champ International.

 

In Early 2017, champions from around the world will compete against one another for the title of Excel World Champ and the Grand Prize: a trip to Seattle, USA and a meeting with Excel Product Leads to provide feedback on the next features added to Excel.

 

Continue reading if you are NOT a resident of Belgium, Canada, China, Denmark, Finland, Japan, Malaysia, Mexico, Philippines, South Africa, Sweden, or Turkey. These countries have local competitions for residents. Learn more about those local competitions here

 

Competition Dates

October 3 - October 9 Trials: Test your skills to see if you have what it takes!

Tests will be available on this page beginning October 3 at 00:00 UTC, no submissions accepted after October 9 23:59 UTC

October 12 - October 21 Qualifying Heat: Compete for a spot as one of the top 20 of Excel users

Tests will be available on this page beginning October 12 at 00:00 UTC, no submissions accepted after October 21 23:59 UTC

October 26 - November 2 Semi Finals: Our 20 best performers compete for a spot as one of the top 3 Excel users

Tests will be available on this page beginning October 26 at 00:00 UTC, no submissions accepted after November 2 23:59 UTC

November 18 Finals: The top 3 Excel users face-off in our finals for the title of Excel Champ International
2017 Excel Champ International and winners of country competitions around the world compete to be the Excel World Champ

 

Competition Format

Each test spreadsheet will include three challenges

  • Data Relays - accessing, structuring, managing, and manipulating data
  • Chart Gymnastics - visually representing data to best tell a story, as judged by our panel of experts and this Excel community
  • Formula Wrestling - using formulas to dynamically solve questions, even if the data changes

 

How to Register

Registration is open from now until the close of the Qualifying heat. To register for the competition:

  1. If you are not already signed in, click "Sign In" at the top of this page. This requires a Microsoft Account, which can be set up using any email address you like.

     

  2. “Like” this post. That's it!
    Users that “Like” this post at least 48 hours before the start of competition rounds will receive an email notification when test spreadsheets are available

     

 

How to Compete

  1. When a test workbook is posted to this conversation, download the file
  2. Complete test questions and save your completed workbook
  3. Post an image of your Chart Gymnastics answer to this conversation string. A portion of your final score will be based on how many likes your chart receives here in the community.
  4. Send an email with your completed workbook attached for final grading. Details on where to send your workbook will be provided with the test.

    Competitors will be scored based on performance of the 3 testing areas Data Relays (35%), Chart Gymnastics (30%, driven by community “Likes”), Formula Wrestling (35%). Test submission time and performance in prior rounds will be used to break tied scores.

For full details on scoring and eligibility, please refer to the contest terms and conditions available here

 

If you would like to connect with and learn from other Excel fans, visit the Excel community (link) and click the Join button.

Thank you for showing your support for Excel! We look forward to seeing the amazing things you can do!

621 Replies

Re: #ExcelChampINTL

You will need Excel 2010 or later to get started in the competition. 

The questions will get harder each round and require some more advanced features.  Make sure you have these additional tools: 

 

If you are using Excel 2010, install these add-ins to Excel

 

If you are using Excel 2013, install this add-in to Excel

 

If you are using Excel 2016, these tools are already built-in.  No need to install anything extra!

 

If you don’t have access to any of the above, consider trying Excel 2016 by installing a free trial O365.  Learn more here

Re: #ExcelChampINTL

Round 1 is available! 

Click the download button at the bottom of this message to get started.

The file includes instructions on how to complete the test and submit your answers

Good luck!

 

Re: #ExcelChampINTL

Let's get ready to rumble!!!

 

 

#ExcelChampINTL

#PuraVida

#CostaRica

Re: #ExcelChampINTL

Workbook is protected, so Power Pivot and Power Query are both disabled!!

Is that intentional?

Re: #ExcelChampINTL

I was about to post the same!

So a question that requires the use of the Data Model that can't be accessed because the workbook is protected. Come on!?

Re: #ExcelChampINTL

 

chart_a-sakka3.png

 

 

My chart :)

 

 

 

Re: #ExcelChampINTL

Untitled.png

Re: #ExcelChampINTL

Olympics Participation Chart

OlympicsParticipation.png

 

Re: #ExcelChampINTL

 

Olympics Chart.png

 

Re: #ExcelChampINTL

Geoff_Lilley_Round1.png

Re: #ExcelChampINTL

Book42.jpg

Re: #ExcelChampINTL

Hi,

 

Since the workbook is protected, we cannot use Power Query/Power Pivot.  Please upload the unprotected version.

Re: #ExcelChampINTL

Excel Champ Round 1 - Q2 chart.PNG

 

Here we go!

 

Quick question - for the Formula Wrestling question, it says that you will receive a higher score for using fewer functions and mathematical operations.  Does this apply only to the Answer cells, or does this also apply to the Working Space as well?

Re: #ExcelChampINTL

The Change of Olympics Games.PNG

Re: #ExcelChampINTL

BTW, 1988 is Seoul Olympic in S.Korea, and 1992 is Barcelona in Spain.

Re: #ExcelChampINTL

Olympics data.png

Re: #ExcelChampINTL

That was fun! - I was hoping we would be able to use the self service Power BI tools and maybe some VBA too.

 

ChartGymnasticsJeff.png

 

Re: #ExcelChampINTL

What exactly can change in the formula wrestling challenge? Will there always be no more than 76 data rows and no more than 3 rounds of results which will be saved in cells E20:J95 or can there be more rows and / or rounds or can the location of the data table change?

Re: #ExcelChampINTL

Hey Pawel,

 

I had the same questions as well - You might want to reply to the main post though.

 

I made the assumption that the data within those fixed rows might change values - Which isn't normally the case - However - the workbook seemed to be heavily locked down and wasn't allowing for usage of ListObjects and structured references except for one the first sheet.

 

Normally my organized dataset would reside in a listobjects and I would build my formulas using only structured references to those listobjects.

 

Let me know what you come up with.

Re: #ExcelChampINTL

ExcelChampINTL_SC.png

Re: #ExcelChampINTL

Beautiful - great job.

Re: #ExcelChampINTL

olympic_participation.pngEvolution of the Olympic Games (1896-2012)

Re: #ExcelChampINTL

20160524_185654.jpgOlympic

Re: #ExcelChampINTL

Olymppics chart.jpg

 

 

Re: #ExcelChampINTL

Olympics.JPG

Re: #ExcelChampINTL

Chart.png

Re: #ExcelworldChamp General Information

image.pngGraphical presentation of olympic games

Re: #ExcelChampINTL

I'm minimalist. :)

 

Chart.PNG

 

 

 

Re: #ExcelChampINTL

OlympicsSmall.png

Re: #ExcelChampINTL

Metamorphosis of Olympic Participation.pngThe Metamorphosis of Olympic Participation (1896-2012)

 

 

Re: #ExcelChampINTL

chart.jpg

 

This is fun, fun :)

Re: #ExcelChampINTL

Guys,

maybe workbook protection is part of the contest, i've just unprotected so it is possible ;) good luck!

 

Chart.png

 

 

Re: #ExcelChampINTL

Excel Championship Round 1.jpg

Re: #ExcelChampINTL

Capture.PNG

Re: #ExcelChampINTL

ScreenHunter_185 Oct. 03 13.43.jpg

 

 

Re: #ExcelChampINTL

A bit busy IMO, but I have to give kudos for the stacked gender pictures!

Re: #ExcelChampINTL

I am overly distracted at how you spelled Olypic Games :)

Re: #ExcelChampINTL

I like your logistical complexity chart. However, male vs. female might have been better represented by a couple of line charts.

Re: #ExcelChampINTL

Upvoting for the amount of work done on the flags.

Re: #ExcelChampINTL

Workbook is protected therefore PowerQuery is disabled.

Do you want us to just create the table on a separate file and paste it in the solution sheet?
Or do you want the file to contain the PowerQuery query itself with the M Code?

 

Please let us know and accordingly, upload an unprotected file.

Thanks!

Re: #ExcelChampINTL

Chart.jpg

Re: #ExcelChampINTL

 This is my chart: 

 

 

Round1.JPG

 

 

 

Re: #ExcelChampINTL

My chart :-)

 

Re: #ExcelChampINTL

Thanks Jeffrey! I like the convergence lines that you added; they tell a good story.

Re: #ExcelChampINTL

Mine

 

chart.PNG

Re: #ExcelChampINTL

ExcelChampINTL-Rnd1.jpg

Re: #ExcelChampINTL

Olympic Games chart.pngThe Change of Olympic Games Chart

Please don't judge too strictly :-)

Re: #ExcelChampINTL

Round 1 Richard Leach.jpgClear & simple

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
45 Replies
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777 in Excel on
47 Replies
align decimals in a column
Jonni Anderson in Excel on
15 Replies
Missing Excel 2013 worksheet tabs
Mike Hill in Excel on
7 Replies
Pop up text box in Excel
Jeff Sher in Excel on
7 Replies