Everyone who works with data should know how to use an Excel Pivot Table. Despite a name that may seem a little scary, pivot tables are easy to use and will save you a ton of time when trying to summarize and organize large amounts of data.
If you interview for a job in marketing, business operations or finance at Zayo, you will likely be asked how you would organize and find answers within a large data table. If you know how to use a pivot table you will have the answers in minutes vs. hours. (I’ve seen people try to manually calc data … it isn’t pretty)
The following videos do a great job of summarizing how to build a pivot table.
Building a Pivot Table in Excel 2007
Building a Pivot Table in Excel 2003 (1 of 3)
Building a Pivot Table in Excel 2003 (2 of 3)
Building a Pivot Table in Excel 2003 (3 of 3)
If you liked my post, feel free to subscribe to my rss feeds
Any advice given on this blog is my own opinion and not that of anybody else. That said - any advice taken from this blog is at your own risk. 
BlogoSquare
One Comment