It’ll be the second galaxy on your right.) (Rough directions? Head toward Alpha Centauri for about 50 million light years and then hang a left. Here’s a quick example: Assume that in some future century that you’re the plenipotentiary of the Freedonian Confederation and in charge of security for a distant galaxy.
MICROSOFT EXCEL DATA ANALYSIS FOR DUMMIES UPDATE
What’s more, as your underlying data changes, you can update your cross-tabulations simply by clicking a button.Ĭross-tabulations are important, powerful tools. For one thing, they aren’t static: You can cross-tabulate data and then re-cross-tabulate and re-cross-tabulate it again simply by dragging buttons. Excel’s cross-tabulations are neater than you might at first expect. A cross-tabulation summarizes information in two (or more) ways: for example, sales by product and state, or sales by product and month.Ĭross-tabulations, performed by pivot tables in Excel, are a basic and very interesting analytical technique that can be tremendously helpful when you’re looking at data that your business or life depends on. Perhaps the most powerful analytical tool that Excel provides is the PivotTable command, with which you can cross-tabulate data stored in Excel lists.
Working with PivotTablesĬustomizing the look and feel of your pivot tables