Pivot tables are now functional in all current versions of Excel, whether you paid for the software or use Microsoft Office/365 for free. Step 1: Prepare your data Perhaps the most important step ...