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 ...

If you are searching for a new way to create full is within Microsoft Excel spreadsheets you might be interested in the LAMBDA function. Within Excel it has transformed the way users interact with and ...

Glide turns an Excel spreadsheet into an inventory app; computed columns replace formulas, giving live stock-on-hand totals across tables.

Screen-capturing programs such as the Windows Snipping tool are fine for capturing graphics you see on your screen's visible area. However, if you need to print a document with a height that exceeds ...

Python has made using Microsoft Excel much easier than it has ever been, and it isn't very hard to start using it yourself.