Articles - All you need to know about Excel
Tips, guides & news

Excel challenge - Binary to text

It's all ones and zeroes, but how to convert it to a human readable format?

Excel challenge - FizzBuzz

Can you solve a classic coding challenge in Excel?

Slot machine challenge

In a parallel universe: the Excel Jackpot slot machine at the casino is not working properly - it fails to calculate the win. Download Excel fileDownload The slot machine spins 3 letters: A, D, G A A A - Wins…

Password Challenge

Help out a company with bad security practices to validate their passwords with Excel! Download Excel-fileDownload You are given the following requirements:- At least six characters long - No spaces - At least one number - At least one special…

Barcode challenge

Download Excel-fileDownload In this week's challenge, you need to help your local post office whose package sorting system is broken. The packages have a barcode that, when scanned, are converted into a series of ones and zeroes (bits). The destination…

Secret Code Challenge

In our first quiz the task is simple - but not too easy: find the secret codes in a list of shipment numbers using Excel! Download the workbook: secret_code.xslxDownload The code hidden in the shipment numbers is 007. Use Excel…