Stop creating Excel sheets that fight you!

To begin, you need to enable the Developer tab in Excel. This tab provides access to the tools required for form creation, but it is not enabled by default. To enable ...

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

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

Excel's basic formulas work fine for simple calculations, but they quickly become cumbersome when you're dealing with complex data analysis. You end up with nested functions that are hard to read, ...

When it comes to creating spreadsheets, the software that comes to the minds of most people is Microsoft Excel. Microsoft Office is a complete suite that lets users create documents, spreadsheets, ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...