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

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

Can Excel send Alerts? Yes, but with some limitations. Excel cannot email an alert to you automatically unless you write a macro in the Visual Basic (VBA) editor to perform this function. And, the ...