In our example, perhaps Acme Engineering and Jones Roofing don’t merit as much sales attention as the others. Clearly, pivot tables offer a slew of options to make slicing and dicing your data easy.

For example, say that TABLE ONE (Corp) has the company name, address, city, state, ZIP Code, and phone number; while TABLE TWO (Products) ... How to create an Excel table. 1.