Excel Breakout Puzzle 3

It is time for another Excel Breakout Puzzle! Excel Breakout Puzzle? Yes … they are totally fun 🙂 You have to use your Excel knowledge and skills to find the hidden code. I’ve hidden a 5 digit code in an Excel workbook, and if you are up for the challenge, see if you can find it.

Background

Before I get to the puzzle, let me provide a quick background. The escape room trend is sweeping the globe. Here is the basic idea. You and some friends go to an escape room, and get locked inside. You have to look around the room and gather clues to figure out codes to various combination locks. Opening a lock provides access to additional clues, which provide additional codes, and so on. You ultimately figure out the final code used on the door lock to escape the room.

Excel Breakout Puzzles

My family LOVES doing these escape rooms together. They are so fun that 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 as a fun way to apply what you’ve learned in each lesson.

If you’d like to try to solve an Excel breakout puzzle, see if you can find the 5-digit code I’ve hidden in this Excel workbook:

Hope you have fun! And if you figure out the code, let me know by posting a comment below.

SPOILER ALERT

If you’d like to see the answer, just roll the video below.

Also, there may be comments below that show the code, so, if you want to try it first, don’t scroll this page down into the comments section.

Note: I’d recommend giving the Excel breakout puzzle a try BEFORE watching this video. The video gives the answer.

 

Previous breakout puzzles:

Posted in ,

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Stay Connected

If you'd like to be notified when I write a new Excel article, enter your name and email and click SUBSCRIBE. You can unsubscribe anytime, and I will never sell your email address.

19 Comments

  1. Col Delane on April 18, 2018 at 10:20 am

    Done in < 30 seconds!
    Not hard if you use a command (that surprisingly is not that well known as it is seldom discussed) from one of Excel's very useful features you'll find on the Data tab of the Ribbon (There's a clue in the instruction to Step 1) – but there is also at least one other much slower & round-about way to find the key from Step 1. (Hope I haven't given away too much!)

  2. Adrian on April 19, 2018 at 5:06 am

    Nice one, Jeff. Do you think we can have the protect workbook/sheet pass to see how it was done?

    • Jeff Lenning on April 19, 2018 at 8:05 am

      ghc7ehg9

  3. Jessica Ross on April 19, 2018 at 7:24 am

    13401

  4. Greg Taillon on April 19, 2018 at 7:29 am

    Google Sheets opens your puzzle with the invalid cells identified without doing anything.
    Still fun but not as challenging as your prior puzzles.
    Regards
    Greg

  5. Deon van Niekerk on April 19, 2018 at 7:44 am

    Nice one!
    Got it.
    The sum of the 5 digits making up the hidden code is 9 and includes a 0…

    Deon

  6. Stacey on April 19, 2018 at 7:48 am

    Yeah! 13401

  7. Nico Mellett on April 19, 2018 at 7:51 am

    Awesome! Really well done 🙂

  8. Laurie on April 19, 2018 at 8:03 am

    I admit, I had to watch the video to get the solution to the 3rd breakout puzzle. Now I am stumped with the 1st and 2nd ones. I think I may have figured out the 2nd one, but am not sure. Is the answer to the 2nd puzzle 847?

  9. Greg Jimenez, CPA on April 19, 2018 at 9:04 am

    Nice Jeff, 13401, was fun:-)

  10. Jerry Falls, CPA on April 19, 2018 at 9:28 am

    13401

  11. Juliene Ehmig on April 19, 2018 at 9:33 am

    Fun! Thanks!

  12. Kathleen Quinn on April 19, 2018 at 10:04 am

    Thanks for the hint from Col! 13401

  13. Lola Simmons on April 19, 2018 at 11:44 am

    That was cool. Done in 15 seconds…13401

  14. Mario on April 22, 2018 at 7:32 pm

    Great Puzzle to reinforce an excel concept. Thanks!

  15. Dave Potts on April 25, 2018 at 10:55 am

    Well, I didn’t do anything sophisticated. I just looked at the values in the cells of the top row on Sheet 2 and used the four that weren’t there (1,2,6,7). No Excel skills needed.

    • Jeff Lenning on April 25, 2018 at 11:01 am

      Dave … wow, I try hard to close up any loopholes like the one you found, but, you hacked me, nice! The way I hoped it would work is that on Step 1, you use the Circle Invalid Data command from the Data Validation menu to identify the key. Then, enter the key into Step 2. But, there are usually multiple ways to accomplish anything in Excel, and I see this breakout puzzle is no exception 🙂
      Thanks
      Jeff

  16. Jeri Mael on May 4, 2018 at 4:05 pm

    Well done!

Leave a Comment





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.