Simplified DES

S-DES is a scaled down version of the Data Encryption Standard algorithm. It is not secure; it is useful primarily as a teaching aid to explain how DES works. This worksheet implements the algorithm in Excel. You can change inputs and keys and it will calculate the correct result. The advantage is that you can see every step of the calculation and every intermediate result.

Click on the picture to download the workbook

How about full DES?

I can't think of an encryption algorithm that can't be implemented in Excel. However, they have large keys, inputs and outputs, so the resulting worksheets would be quite large to be useful even as a didactic method.
top