# Excel Breakout Puzzles!

Are you aware of the Escape Room trend, or the similar breakout logic puzzles that teachers use in classrooms? Here is the basic idea of the escape room. You and some friends or colleagues go to a company that has created an escape room. Like, in the real world, physically, you go to a place.

Each escape room typically has a theme, like an apartment, library, or bank vault, and is decorated accordingly. You get locked into the room, and the timer starts. Before the timer goes off, you must gather clues and solve puzzles to obtain the code to the lock in order to leave the room, or escape. There are typically several codes and padlocks. So, you look around the room, and solve a puzzle to get a code. You enter the code into a padlock on a drawer, small safe, or lockbox, to open it. Inside, you’ll find clues that help you get the next code, which opens another lockbox, and so on, until you ultimately figure out the code that allows you to escape the room. It is totally fun, and my family loves these (photo of me and my son Jason after breaking out of a room).

A similar version is played in schools as well, typically in math or STEM classes. The teacher will create breakout puzzles around the classroom. Students must find clues to figure out the codes. Entering the correct code unlocks a box. The puzzles require a bit of math and logic to get the code. It is a great learning activity, and helps the students stay engaged and have a bit of fun while applying what they learned.

Well, I was telling my son, Jason, that I wanted to create something similar for my Excel courses. So, I’ve created a bunch of Excel Breakout Puzzles…how fun is that! You must use the Excel skills presented in the course to solve the puzzle and enter the code. Basically, I hide the code somewhere in the Excel workbook, and you have to use what you learned to reveal the code.

These Excel breakout puzzles are debuted in the Excel University Graduate Certification program. I’ll send along more information about the certification program in my next blog post.

But, in the meantime, I wanted to give you an idea of what one of my Excel breakout puzzles is like, so, I figured I’d give one to you now.

Want to play?

Download the Excel file below, and see if you can find the 4-digit numeric code I’ve hidden in the workbook. If you figure out the code, enter it into the comments below.

Excel Breakout Puzzle Workbook.xlsx

Hope you have fun!

Solution Video

Here is a video that walks through the solution to the Excel breakout puzzle.

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

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

1. Laszlo Sandor

Nice puzzle, thanks! 1021

2. Laszlo Sandor

Will develop it further definitely – you may have initiated an excel-breakout trend 🙂

1. Jeff Lenning Post author

I hope so… I think they are a fun learning activity 🙂

3. SABRINA

1021

4. Willijan

1021

5. Matt

1021

6. Christopher Migala

1021

7. Jason Snowden

1021?

8. Victoria Lenhardt

That was fun. The code is 1021.

9. Robyn Fain

1021
Fun!

10. Jenny

I guess I thought about it a little too hard. I didn’t expect to just look at the 5 and copy the letters.

1. Jeff Lenning Post author

Hi Jenny! This first breakout puzzle was an easy skill level, just to get started. But, don’t worry, I have others that are more complex 🙂

2. Li

Me too! I thought the order matters, and was trying to find clues how to arrange the 5 letters…

1. Jeff Lenning Post author

Ah, yes…I just wanted to use an easy starter puzzle for the intro 🙂

2. Ronak Mehta

Did you mean to have a total of 8 #7 digits in your example? I did a countif on the number of digits and clearly over complicated the question by focusing on that. But if that wasn’t an intentional red herring, you may want to correct the count of the #7 digits to save any future over thinkers from going insane for 5 mins. 🙂

Nice use of conditional formatting too.

11. Melinda Evans

1021

12. Deborah Hall

1021

13. Myla

1021

14. Kathleen Shannon

1021 is the code

Really fun….I enjoy these kind of problems !
Thank you

16. Eric

Fun, you should have scrambled up the numbers. This would lead you to want to filter or sort the data. Otherwise, why not scroll down to the 5 and copy and paste without even adding filters.

1. Jeff Lenning Post author

Ah, yes…that would have been better 🙂

17. Meri

1021!

18. Holly

1021

19. Gail

1021

20. Barry Thistlethwaite

It took me a while because it was so simple! 1021

21. Joan Hauff

That was fun. I also learned from your solution video that data doesn’t have to start in Row 1 or Row 2 (with heading) to be filtered. I had always removed miscellaneous rows and columns before filtering. Fun + learning = a great day :).

22. gordon

the code is 1021!

Nice puzzle, to figure out the solution video. Was using countif function instead of filter, hence failed.
Unique use of conditional formatting, thoroughly enjoyed.
All The Best!

Farooq

1. Jeff Lenning Post author