While using Microsoft Excel ... With a pivot table, you can create one pool of information and then easily change your focus from one thing to another — an analysis that would be tedious to ...