PivotTables are great for quick analysis, but they break down when you rely on them for serious reporting workflows.

A few of Microsoft Excel's main tasks are fairly obvious as soon as you open the software, with macros and calculations displayed on the default ribbon and a spreadsheet with empty cells waiting for ...