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
BlogoSquare
One Comment