Explore personal Excel projects, from games to tools. Each shows how spreadsheets can be fun, creative, and practical.
Securing Your Passwords with PW-Encrypter Encrypt your passwords and store them locally on your PC. How does it work? Actually very simple. You must enter a master password and a PIN code. Both the master password and the PIN code are used to encrypt your… Read More »Excel Password Encrypter 2.0
How the Excel Mastermind Solver Works My latest creation is another game: “Mastermind”. You have to crack the code of 4 colors in 12 guesses. A color can appear multiple times in the code. And there are 6 colors to choose from. Can you crack… Read More »Mastermind Game in Excel v1.0
Batch File Renaming In Excel Ever wanted to change file names in a simple way?If your answer is yes, then now there is a simple way to do it. I have created a Simple File Renamer in Excel. You can add or remove text, add… Read More »Excel File Renamer Tool v1.0
My new creation is a puzzle that I have known since childhood: Pentomino. Solving Pentomino Puzzles in Excel The puzzle consists of 12 different pieces (each consisting of 5 squares), which must be placed in a field of 10×6 (squares). There are 2339 unique solutions… Read More »Pentomino Puzzle in Excel v1.0
It was about time to put some art in Excel. I chose the Night Watch, because everyone knows this work. And because both Rembrandt and I were both born in Leiden. Now you will probably say, well, inserting a picture in Excel, is that so… Read More »The Nachtwacht Recreated in Excel
Solving A Sudoku Puzzle In Excel Just started with macros, and yet immediately started a tricky project.Making a sudoku solver in Excel. Hereby 2 challenges. 1: How am I going to solve the Sudoku? 2: Hoe ga ik dat aanpakken met een of meerdere macro’s?… Read More »Excel Sudoku Solver v1.0
My second project in Excel was to create a cryptogram (or crossword) template.The goal was that in one tab the cryptogram creation tool can fill in the answers in a diagram of 21 by 21 boxes. Excel then determines the numbering of the answers and colors… Read More »Excel Crossword / Cryptogram Maker
After making various (digital) clocks in Excel, I thought it would be fun to make an analog clock in Excel. Now one thing led to another and so my first project was born. A Real Time Weather Station In Excel A weather station in Excel… Read More »Excel Weather Station v1.4
