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.

![img]()

Presenter:
Diane McKeever

![img]()

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. More recently she has expanded her business and become certified as a Social Media Marketing Professional She has lectured extensively on the subject and has helped hundreds of businesses set up and use the powers of advertising available through social media. Diane's book, 100 Amazing Computer Tips, is available on Amazon.com