Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

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

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

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting. Data bars are a kind of conditional formatting, with the bar length based on the value of the ...

Navigating through a complex Excel workbook or spreadsheet can be a real headache, especially when you’re dealing with multiple sheets and endless data. But what if there was a way to simplify this ...