how to use pivot tables in excel 2011 for mac

Use Pivot Tables In Excel 2011 How To Use Smart

Use Pivot Tables In Excel 2011 How To Use Smart

So you really should learn how to use Smart Categories separately and figure out how you can apply those to use with your data.

This is similar to the old Categories feature in Numbers prior to 2013, and similar to Pivot Tables in Excel.

This is a technique used in Microsoft Excel to allow you to visualize data in different ways.

You can do that in Numbers using something called Categories prior to 2013.

But now we have it back in version 5.2 of Numbers theres something called Smart Categories.

Here its got a product column here on the left and each row is a record in here.

So you can see theres apples, theres oranges, theres bananas.

Say we wanted to visualize things grouped together by product.

One way to do it would be to select a table here, click the little reveal Commands or pull-down menu right there, and select Add Category for Product for this column.

So under Category you can add a Category and I can pick the Product column.

Either way its going to get you to the same place which is that its going to group together all of the different products.

Now you can change this by saying instead of grouping by product, lets group by date.

In my example Ive got product, Ive got months, Ive got amount.

I can do it by product and then I can also add another one and say by date.

So now you can see Ive got it here where all the apples of January, March, and February and the oranges, etc., so theyre all grouped together.

Now you can do more than just visualize this, you know kind of sort it because thats all its really done so far.

So, for instance, under amount here if I click in this little special box notice it creates this special row here.

Its between row one and two and it just says apples and telling you this is a group of apples.

I can click here and click this little button and I can use some special functions here.

It gives me all this great data here that I can kind of visualize by this group.

Of course you can dig down and have multiple groups as I was showing before.

They fulfill most of what Pivot Tables would do but kind of in a really nice Numbers way where you can look at it using nice tables inside of sheets, inside of documents.

If youre looking for Pivot tables and you want them to work the same way they do in Excel then this isnt going to get you there because its going to look different.

How To Use Pivot Tables In Excel 2011 For Mac