Typically, you’ll work with a lot more data than what is shown in this sample worksheet, but let’s not start by getting overwhelming. Start by downloading this data, then follow along. Pro Tip: use this article to learn the basics. Rather, you’ll know the basics and can go off into the world to impress folks around your office. You won’t become a Pivot Table master by reading this short article. If you read this short article and follow along, you’ll be able to make a Pivot Table.

Also - and here’s the big secret - it’s actually not all that hard.

Seriously, learning how to create a pivot table in Excel is something that everyone in a business setting should be required to learn. The wizard who dreamt up Pivot Tables deserves a place in the hallowed halls of Hogwarts. By Rich Rinaldi on Decemin Advanced Excel Functions and Formulas