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.

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.