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.
Creating the Pivot Table. 1  Highlight cells A2 to D12 2  . Click on the Insert tab of the ribbon. 3  Click on Pivot Table in the list to open the Create Pivot Table dialog box.  Choose Existing Worksheet for the location of the pivot 1  table. Click on cell D16 in the worksheet to enter that cell reference into the location line.