Home

#ExcelChampMY

Highlighted
Microsoft Excel
Microsoft

#ExcelChampMY

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 Malaysia

 

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.

 

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

Round 1 has now been extended to 9 October

October 12 - October 21 Quarter Finals: Compete for a spot as one of the top 10 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 27 Semi Finals: Our 10 best performers compete for a spot as one of the top 3 Excel users at the Microsoft Malaysia Office in KL

 

November 18 Finals: The top 3 Excel users face-off in our finals for the title of Excel Champ Malaysia
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

 

Participation

You may decide to start participating during the Trial round (3-7 Oct) or choose to start competing during the Quarter Finals (12 – 21 Oct)

  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!

91 Replies

Re: #ExcelChampMY

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: #ExcelChampMY

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: #ExcelChampMY

116 Years of Olympics Participation.png

Re: #ExcelChampMY

rnd1 chart gym.PNG

Re: #ExcelChampMY

Round 1_Christan Ligene.jpg

Re: #ExcelChampMY

ExcelChampMY-Rnd1-FongKimJee.png

Re: #ExcelChampMY

I like what you did here. :)

Re: #ExcelChampMY

 Thank you very much Elfren Peria.  I hope more people like it too.. 

Re: #ExcelChampMY

Chart Gymnastics_Vincent.jpg

 

 

Re: #ExcelChampMY

Change in Olympic Games Over Time.png

Re: #ExcelChampMY

C1.png

Re: #ExcelChampMY

Best! I have nice chart presented here. Please support me by clicking Like.

Re: #ExcelChampMY

ExcelChampMY.JPG

 

Created by Kent Lau, Microsoft Excel - MOS, Microsoft Excel Corporate Trainer

The author of "The E Journey" and serving over 200 corporates and helped over 2000 adults to improve their Excel skill fast.

I decide to use a dynamic chart on the Events...as I see the main reason for this chart is about examining the trend of man versus woman competitors, the events may be an optional data.

Fewer data points, clearer picture.

but should a user need to view the events, they can click on the checkbox above the chart.

I also added two Axis Title - Primary Vertical and Secondary Vertical, so any reader can easily understand the chart.

 

If you think my chart is easy to understand, please click the Like button below my post. Thank you very much.

 

 

Re: #ExcelChampMY

Capture.PNG

Re: #ExcelChampMY

Olympics Participation History (1896 - 2012)Olympics Participation History (1896 - 2012)

Re: #ExcelChampMY

Received error from Microsoft Excel that Power Pivot function cannot be used when the Excel file is protected.

Re: #ExcelChampMY

Also similar to Power Query as the function is locked/disabled when the Excel file is protected.

Re: #ExcelChampMY

I was trying the same too. The main reason I see why it is structured in such way, because not many companies have embraced the power of PowerPivot.

 

Free up your creativity and you have the solution inside you! Looking forward to see your astonishing chart...

Re: #ExcelChampMY

For my case, it is happening to Microsoft Excel 2010

Re: #ExcelChampMY

ExcelChampMY-Rnd1.png

Re: #ExcelChampMY

olympic chart.png

Re: #ExcelChampMY

My guess is they are limiting the feature so that you will use the common feature to massage the data.. Just my opinion.

Re: #ExcelChampMY

ChartGymnastics_TiDengJay.png

Re: #ExcelChampMY

 

excelchamphd.PNG

Re: #ExcelChampMY

The Trends of Participation in Olympics.JPG

Re: #ExcelChampMY

Edward Looi's Trial Round ChartEdward Looi's Trial Round Chart

 

Re: #ExcelChampMY

 

Olympics_JMY.png

Re: #ExcelChampMY

JHL OLympics.png

Re: #ExcelChampMY

Excel Compt 2016.jpg

Re: #ExcelChampMY

 

Re: #ExcelChampMY

 Please like my chart! TQ! <3Please like my chart! TQ! <3

Re: #ExcelChampMY

Please 'like' my chart. Thanks :)Please 'like' my chart. Thanks :)

Re: #ExcelChampMY

Nasri Malek - Trial Round.JPGHello Guys! Do like my chart too! <3

 

 

Re: #ExcelChampMY

Chart Gymnastic.JPG

Re: #ExcelChampMY


Microsoft Excel wrote:

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!

 



Chart Gymnastic.JPG

Re: #ExcelChampMY

 photo ExcelChampMY-Rnd1.jpg

Re: #ExcelChampMY

Picture1.png

Re: #ExcelChampMY

ExcelChampMY.png

Submitting my entry. Cheers everyone :)

 

 

 

Re: #ExcelChampMY

ExcelChampMY.png

Submitting my entry. Cheers everyone :)

 

 

 

Re: #ExcelChampMY

Capture.PNG

Re: #ExcelChampMY

Capture.JPG

Re: #ExcelChampMY

 

Re: #ExcelChampMY

 

OLYMPIC CHART CS NG.jpg

 

 

 

Re: #ExcelChampMY

rnd1.JPG

Re: #ExcelChampMY

Round 1 - Change of Games over Years.png

Re: #ExcelChampMY

chart.jpg

The attached visuals were dynamically setup to be interactive. Scroll bar and combo boxes are being utilised with the intention to maximise the effectiveness of the presentation.

 

I was avoiding the ‘too-much-in-the-face ‘presentation that such a big data set always tends to show. The cosmetic effects were kept to a minimum too.

 

And, yes that’s how I dress as well - *boring* !

 

Cheers, all. Enjoy.

Re: #ExcelChampMY

 

Picture1.jpg

 

Re: #ExcelChampMY

Olympic Trend.png

 

 

Related Conversations
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777 in Excel on
45 Replies
Excel Compare Data
Arnold Lopez in Excel on
12 Replies
Excel filter issues
P DS in Excel on
13 Replies
Missing Excel 2013 worksheet tabs
Mike Hill in Excel on
7 Replies
Setting Print Areas Not Working in Excel 2016
Scott Cox in Excel on
4 Replies
Graphs in excel
Martin Kotuľák in Excel on
5 Replies