On your Mac, go to General under System Preferences and switch off the option to allow Handoff. Disable Phone Calling. To turn off Phone Calling on your iPad or iPod Touch, go to FaceTime under Settings and switch off iPhone Cellular Calls.
A pivot table is a special Excel tool that allows you to summarize and explore data interactively. It's a lot harder to explain a pivot table than to show you how one works, so let's take a look. Here we have a worksheet that contains a large set of sales data for a business that sells speciality chocolate to retailers.
The pivot table's Sum function totals all the underlying values for each item in the field. The result is the same as using the SUM function on the worksheet to total the values. When you add a numerical field to the pivot table's Values area, Sum will be the default summary function.he result is the same as using the MIN function on the worksheet to calculate the minimum of the values. In the screen shot below, you can see the source data for a small pivot table, and the minimum quantity, using the worksheet's MIN function, is 8.