Original text

Using Excel to Analyze Your Data – Including Pivot Tables

If you work with data much, you don't need a statistical model to predict that the odds of consistently getting data in the format you need for analysis are low. But it turns out that there's a lot of data massaging you can do in a plain old Excel spreadsheet -- if you know the tricks and formulas. We’ll be parsing data and concatenating it. We’ll be sorting and filtering data. Lastly, we’ll be massaging it into pivot tables. 

View and download the Excel Database Use PDF here.

View and download the Sample Files in one workbook here.