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

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

Stop treating PivotTables as the finish line—add Slicers and Timelines to turn your spreadsheet into an interactive dashboard ...