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.

About the Author(s)

 Diane   McKeever

Diane has been a software trainer for over 30 years and has taught over 100,000 students in the US and Europe, working with corporate presidents as well as continuing education students. Every day she earns her title of "Certified Patient Person" by teaching some of the most complex material in a fun, easy to understand way.

Certified Score Mentor & Presenter, Score Manasota
Using Excel to Analyze Your Data – Including Pivot Tables