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

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

Implementing a drop-down list in Excel is a quick and efficient way to choose predefined data. In the process, you’re able to save time compared to manually entering such data into a given spreadsheet ...

Custom formulas let you dictate exactly what goes into cells.