Skip to main content

Original text

Powered by Google TranslateTranslate
Powered by Google TranslateTranslate
Using Excel to Analyze Your Data – Including Pivot Tables
by Diane McKeever
January 15, 2023

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
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.
Read full bio
2801 Fruitville Road, Suite 280
Sarasota, FL 34237
(941) 955-1029

Copyright © 2023 SCORE Association,

Funded, in part, through a Cooperative Agreement with the U.S. Small Business Administration. All opinions, and/or recommendations expressed herein are those of the author(s) and do not necessarily reflect the views of the SBA.

Chat generously provided by:LiveChat

In partnership with
Jump back to top