When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file. If you insert tab characters into the output data stream, you ...

These four overlooked Excel features completely changed how I design spreadsheets.

Back in April 2014, I wrote about the first release of Microsoft’s Excel for iPad, and I found it to have a well-designed UI and most of the features of the desktop version. It was missing some things ...

This Excel spreadsheet uses conditional formatting to highlight the resistor pairs in a design that can create a particular ratio. The target ratio is entered in cell C3, and the tolerance is entered ...