You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up. Not anymore: Excel 2013 ... the master information in every detail table, you create ...

Pivot tables in Microsoft Excel are ... order in the data set doesn’t matter a bit. The pivot table is a good report, as is but you might want to focus on specific information.