I’ve been meaning to get a couple Excel tutorials up here since I’ve been getting so many questions about how to manipulate and analyze data in Excel. Here are two videos that review using filters and pivot tables in Excel 2010.Both filters and pivot tables are really pretty easy once your “get it,” but wrapping your head around them can take a few tries, especially if you’re not that familiar with Excel’s functionality.
In these two videos, I’m using a set of data that represents insurance policies sold by agents. As the sales manager, I can use filters and pivot tables to quickly and easily analyze what my agents have sold based on types and timeframe and get creative about how I want to view this information.
Here’s the Filters video:
Here’s the Pivot Table video: