Category Archives: excel

How to create a drop down menu in Excel

This short tutorial will show you how to create a drop down menu in Excel. The Drop down menu will allow you to ensure that only the correct data gets entered into a field. In this example we want to … Continue reading

Posted in excel, windows | Tagged , , | Leave a comment

Producing HTML links from a CSV Using Python

Recently in work I had to generate a long list of html links from two columns that I had extracted from a MySQL database to a .csv file. The example below shows what steps are needed to generate html urls … Continue reading

Posted in excel, programming, python | Leave a comment