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.
Place the cursor on any cell in the table. Click Power Pivot > Add to Data Model to create the linked table. In the Power Pivot window, you will see a table with a link icon, indicating the table is linked to a source table in Excel: If the model already contains tables, you have one more step.