CMU School of Drama

Monday, April 24, 2017

How to Use PivotTables to Analyze Your Excel Data The problem we all face is that we have mountains of data and need a way to digest it. We're all looking for a way to make sense out of large sets of data and find out what the data indicates about the situation at hand.

Excel's PivotTable feature is a drag and drop analysis tool. Point Excel to tables of data in your spreadsheet, and slice your data until you find an answer to your question. Most importantly, it's an easy-to-use tool right inside of Excel where your data might already live.

1 comment:

Annie Scheuermann said...

In Production Resource Management we have really learned a lot about excel and how to use its tools for budget tracking and expense data. Pivot Tables were something I was unfamiliar with before the class, and now a pretty good grasp on how to use them. Recently I had a conversation about excel and pivot tables with my mother who is an actuary. When I was younger I had no clue what she really did in her field of work and I would just say she works with numbers. After having learned a lot more about excel this semester, she should be one of her files and it was mostly using pivot tables to organize a lot of data and finding trends in like circumstances. I really think that this is a super useful tool and the article covers the basics very well, some tutorials may have been helpful before on some of the PRM assignments. I think everyone in our society should now how to use the basics of excel no matter your field because it can be super useful.