# 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.

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 🙂

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