Excel Breakout Puzzle 7

The next Excel breakout puzzle is ready! And it’s a goodie 🙂

I realize fall doesn’t officially start for a few weeks, but, our kids start school next week and so it already feels like fall is upon us. Fall means back-to-school, cooler weather, falling leaves, and … american football. My son plays, and so I thought I’d do a football-themed breakout puzzle this time. Hope you enjoy!

Background

Before I get to the puzzle, let me provide a quick background. My family LOVES doing escape rooms. Have you been to an escape room? You basically get locked in a room and have to solve puzzles to open various combination locks including the lock on the door so you can escape.

They are super fun, and I wanted to do something similar in my Excel courses. So, I came up with the idea for an Excel breakout puzzle. You basically need to open the Excel workbook and look around for clues. You use your Excel skills to solve the puzzle and reveal the code.

These Excel breakout puzzles are used in the Excel University Graduate Certification program (40 CPE) as a fun way to apply what you’ve learned in each lesson. The certification program is my signature training program, and I open it up for registration twice a year. It is open now though Aug 29. More info here:

If you’d like to learn more about it, I’d invite you to attend my upcoming live webinar called VLOOKUP vs SUMIFS: Battle of Heavyweights. The free webinar compares VLOOKUP to SUMIFS, and earns 1 CPE credit if you need it. At the end of the webinar, I provide more information about the program. Dates, times, and more info:

Now, on to the puzzle!

Objective

This breakout puzzle has 3 steps. In step 1, you want to find the 4-digit numeric key that I’ve hidden. You’ll have to use your Excel knowledge to find the key. Once you do, enter the key into the Step 2 sheet to reveal the 8-digit code. To verify that the code is correct, head to Step 3 and enter the code. If it is correct, you’ll be able to use the resulting link to view a fun congratulations page. If you think you are up for it, download the file below:

If you decide to give it a try … good luck, I hope you have fun 🙂

Also … I’ll be doing a full walkthrough of the puzzle including providing the solution at the VLOOKUP vs SUMIFS webinar. So, you can grab your webinar spot here if you’d like to join me.

Comments

If you solve the puzzle, please post a comment with something like “Got it!” but please don’t post the actual code.

Here are the previous breakout puzzles in case you’d like to check them out:

Get a quick email notice when a new Excel article is available

  • This field is for validation purposes and should be left unchanged.

This article was written by Jeff Lenning

20 comments:

  1. TONI BULLARD
    Reply

    GOT IT!!!
    I’d like to think it’s because I’m taking the Excel University Graduate Certification program, which has been SO VERY HELPFUL! I’m learning so much. I love the challenge of figuring out the puzzles!

    1. Jeff Lenning Post author
      Reply

      Way to go Toni … and thanks for your kind note, I’m glad you are enjoying the cert program 🙂

  2. Razorbacker
    Reply

    Got It

    1. Jeff Lenning Post author
      Reply

      Excellent!!

  3. Hazel McLaren
    Reply

    SUCCESS

    1. Jeff Lenning Post author
      Reply

      Woot!

  4. David Hess
    Reply

    Got it Jeff.
    Interesting puzzle

    1. Jeff Lenning Post author
      Reply

      Nice David 🙂

  5. Doris
    Reply

    Got it! Woo Hoo!

    1. Jeff Lenning Post author
      Reply

      Great job Doris!

  6. Rene
    Reply

    Got it! Fun puzzle, really creative way to use and learn Excel.

    1. Jeff Lenning Post author
      Reply

      Great job Rene … and thank you for your kind note!

  7. Allen
    Reply

    Got it.

    1. Jeff Lenning Post author
      Reply

      Nice 🙂

  8. Florence
    Reply

    Got it – fun!

    1. Jeff Lenning Post author
      Reply

      Awesome!

  9. Alice
    Reply

    Not done one of your puzzles. Any hints?

    1. Jeff Lenning Post author
      Reply

      Hi Alice … start with the Step 1 sheet and use an Excel feature to find a 4 digit key in the football field. You’ll use that code on the Step 2 worksheet to reveal the code. Have fun!
      Thanks
      Jeff

  10. Lori
    Reply

    Got it! Very fun! Thank you, Jeff!

    1. Jeff Lenning Post author
      Reply

      Way to go … and thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.