Once we have our data in the proper format, we can then make a pivot table. I am going to use an example data set that I found on the internet. This data is showing NFL Offensive Player stats from 1993 – 2013. So let’s walk through how to do a simple pivot table in excel.įirst we need a data source that is set up in columns. Inherently we run across instances like this in our day to day jobs as planners or project control personnel when dealing with actuals from our timesheet or LEM system, summarizing data for invoicing or comparing data from our subcontractors to their invoices, etc. The pivot or summary table can then be altered simply by dragging and dropping fields graphically. The pivot table, once setup can be used to group, sort, and summarize data using basic mathematical functions. They can be used with any kind of data that is stored in columns, but are extremely useful when the data is so large that it goes beyond what normal spreadsheet filters can handle. Pivot Tables are part of most spreadsheet or business intelligence software packages. Are you faced with a mountain of excel data, and need to consolidate it into a usable format so that it can be easily filtered grouped and sorted? Welcome to the world of pivot tables!
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |