Home

#ExcelChampSA

Highlighted
Microsoft Excel
Microsoft

#ExcelChampSA

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

We want to 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 South Africa

 

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

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 South Africa
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!

58 Replies

Re: #ExcelChampSA

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

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: #ExcelChampSA Hope this one is popular!

Chart.pngOlympic Chart

Re: #ExcelChampSA

 

ExcelChampSA - Olympics Shane Hutchinson.jpgRound 1 Chart Gymanstics - Shane Hutchinson

 

 

 

Re: #ExcelChampSA

 

Chart Gymnastics-Denis Dell_2.PNG

 

Re: #ExcelChampSA

Graph.png

 

 

Re: #ExcelChampSA

Chart Gymnastics.png

Re: #ExcelChampSA

Untitled.png

 

 

Re: #ExcelChampSA

Olympic.png

Re: #ExcelChampSA

Capture.JPG

Re: #ExcelChampSA

Chart.PNGOlympic Games Chart

Re: #ExcelChampSA

ExcelChampsGraph.png

Re: #ExcelChampSA

OlympicGamesOverTime.png

Re: #ExcelChampSA

ExcelChamp1.png

Re: #ExcelChampSA

ExcelChampSA-Rnd1_Aarnout Brombacher_Chart Gymnastics.jpg

Re: #ExcelChampSA

Chart.png

Re: #ExcelChampSA

HoOV.png

 

 

Re: #ExcelChampSA

Times up! Round 1 is closed.

Thanks to everyone that participated.  And come back.  Round 2 begins soon and everyone is invited to participate!

Re: #ExcelChampSA

Round 2 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: #ExcelChampSA

Graph2.png

 

 

Re: #ExcelChampSA

Entry 2b Chart.png

Re: #ExcelChampSA

The data was too complex to evaluate on a single chart. Since there was no specific limitation set on the amount of charts allowed I decided to combine a few different charts into one visualisation.Picture1.png

 

Re: #ExcelChampSA

 

Chart Gymnastics-Denis Dell_Round 2.PNG

Re: #ExcelChampSA

Round 2 - Chart Dynamics.png

Re: #ExcelChampSA

Round2.PNG

Re: #ExcelChampSA

Chart2.png

Re: #ExcelChampSA

ExcelChampSA-Rnd2 CGJ.png

Re: #ExcelChampSA

 As there was 2 defintive sets of data I created 2 Charts , aswell as for the data to make visual sense I calculated the remainder of the tickets available after sales to use in a  staggered stacked bar diagram

Shane Hutchinson - Round 2 ExcelChampSA.jpgShane Hutchinson - Round 2

Re: #ExcelChampSA

Capture.PNG

 

 

Re: #ExcelChampSA

Chart2.JPG

Re: #ExcelChampSA

I subsetted the view of my graph to have a view were most data is available. Added soem trends lines and saw both ticket sales and broadcast hours increasing with some certaintity. So I plotted 2 scatter plots to further explore the relationship between broadcast hours and ticket sales by both percentage and absolute sales. As it stands there is a moderate positive correlation.Excel Rnd 2.png

Re: #ExcelChampSA

Excel Champ rnd 2.png

Re: #ExcelChampSA

Capture.PNG

Re: #ExcelChampSA

 

Re: #ExcelChampSA

Rnd2.jpgRnd2

 

 

Re: #ExcelChampSA

Times up! Round 2 is closed.

Thanks to everyone that participated!

Come back soon. We will announce winners shortly!

Re: #ExcelChampSA

Congratulations to our Top Performers from Round 2!

These people are advancing to our Semi-Final Round starting soon:

 

@Denis Dell

@Christo Kritzinger

@Corneluis van Heerden

@Shane Hutchinson

@Charl Jooste

@Philip Axt

@Dineo Letsholo

@Justin Major

@Dewald Smit

@Karina de Kock

 

We will share more on top answers/common pitfalls from all rounds following the close of competition.  

Until then, good luck to our remaining competitors!  And thank you to everyone that participated!

Re: #ExcelChampSA

The Semi-Final round has begun!

Our round 2 winners can now face off for a spot in the finals

All other Excel fans are welcome to download the test, but please do not discuss your answers until after the Semi-Final round has closed

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

Good luck!

 

Re: #ExcelChampSA

 

Chart Gymnastics-Denis Dell_Round 3.PNG

Re: #ExcelChampSA

Best of luck to all of you, hope you enjoy this as much as I do.  Thank you to the organisers for putting this competition together.

 

Re: #ExcelChampSA

Congratulations to All, good luck for the next round

Re: #ExcelChampSA

Good luck to everyone, this is an awesome competition. Learning while having fun:)

Re: #ExcelChampSA May the oods be ever in your favour (Doctor Who/Hunger Games Reference)

Gymanstics.png

Re: #ExcelChampSA

Spot on, having fun while learning. Will be using that line going forward. Thanks

Re: #ExcelChampSA

chart3.png

Re: #ExcelChampSA

sf.PNG

 

 

Re: #ExcelChampSA

Excel Champ rnd 3.png

Re: #ExcelChampSA

ExcelChampSA-Rnd3 CGJ.png

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