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