Microsoft Excel pivottables are a great way to take complex data and organize it so it is much easier to understand.

Yesterday a client and I had a discussion about Microsoft Excel and working with pivot tables. I asked her if she knew about pivottables and she said no. Because of that conversation I decided to re-post some of my previous tutorials about pivottables. In addition to that, I decided it made sense to explore other options for tutorials on pivottables. The great thing about the web is that a lot of resources are available to make us all better at what we do. In my next post I will add some additional information about pivot tables.

Part 1

Creating a Microsoft Excel pivottable is a great way to quickly break down data in multiple ways.

When you start using a pivottable in Microsoft Excel it can seem a little bit daunting. My experience has been that if you work with data that you fully understand, pivottables are much easier to work with. If the data is incomprehensible to you you will not understand what the data means when you pivot it. The data in this tutorial is very easy to understand and therefore makes it easy to show you how to work with pivottables.

Part 2

Microsoft Excel 2013 tries to make it easy to work with pivot tables by recommending certain types of pivot tables that represent your data.

I must command Microsoft on this feature in Microsoft Excel: recommending pivot tables.