Another shows profit by line. In Excel 2007 and earlier, if you wanted to filter the dashboard, you would have to make identical selections from each of the four pivot tables, which is really asking ...

It’s not for big data, but you can use Microsoft Excel to learn a lot more about analytics than you may realize. For many office workers, Microsoft Excel is simply the go-to spreadsheet application.