how to create a pivot table excel for mac video

Create A Pivot Table Excel Video Download The Data

So, now that youve laid the foundation, lets break down some other tools and features you can use to make the most of the pivot tables you create.

Instead of needing to change the year filter on both of those pivot tables, he could create a slicer for the year.

Select the variable you want to sort your data by (in this case, its the year) and click OK.

I recommend positioning it on top of your pivot tables, so that you can look at everything in one glance.

To do so, right click on the slicer, select Report Connections, and then choose the pivot tables that should be connected to that slicer.

While getting the slicer established involves a little bit of work, it can save you tons of elbow grease down the roadparticularly if youre using a lot of different pivot tables.

Doing the profit calculation himself outside of the pivot table is rather cumbersome, because he needs to subtract the Q1 cost from the Q1 sales, do the same for Q2, and so on and so forth.

So, he would click on sales and hit Insert Field, type in the minus sign, and then click on Cost and hit Insert Field.

He wants to dig in deeper and see his beer sales for each quarter for each type of beer (Amber, Pilsner, IPA, or Stout).

Fortunately, he can do that with just a few clicks using his original pivot table as his starting point.

Click within your pivot table, head to the Pivot Table Analyze tab within the ribbon, click Field List, and then drag Type to the filters list.

After Jason highlights Type as what he wants to break the data down by, Excel will create a new worksheet with a pivot table for each type of beer.

You can also display subtotals in your pivot table if youd like.

With the way his defaults are set, Excel isnt displaying the subtotals for each sectiononly his grand total of all beer sales.

If he wants to remove the subtotals, he can easily do so following those same steps and selecting the Dont Show Subtotals option.

He just needs to double-click on that number in the cell, and Excel will open up detailed information in a new worksheet.

Jason accidentally spelled growler as grolwer, for example, and now it appears that way everywhere.

Hed hit Ctrl F and then enter in what he wants to identify, and what should be swapped out in its place.

That will make that same correction across the entire workbook.

Put them to work, and youll make summarizing and analyzing your data a total breeze.

When she escapes her computer, she enjoys reading, hiking, golfing, and dishing out tips for prospective freelancers on her website.

Create A Pivot Table Excel Video Download The Data

Computergaga). Download the data sheet and try the challenge today.

How To Create A Pivot Table Excel For Mac Video