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.
Insert a Pivot Table. To insert a pivot table, execute the following steps. 1. Click any single cell inside the data set. 2. On the Insert tab, click PivotTable. The following dialog box appears. Excel automatically selects the data for you. The default location for a new pivot table is New Worksheet. 3. Click OK.o insert a pivot table, execute the following steps. 1. Click any single cell inside the data set. 2. On the Insert tab, click PivotTable. The following dialog box appears. Excel automatically selects the data for you.