GETPIVOTDATA (data_field, pivot_table, [field1, item1, field2, item2], ...) The GETPIVOTDATA function syntax has the following arguments: The name of the PivotTable field that contains the data that you want to retrieve. This needs to be in quotes. A reference to any cell, range of cells, or named range of cells in a PivotTable.

Keyboard shortcuts: Apply superscript or subscript. To make text appear slightly above (superscript) or below (subscript) your regular text, you can use keyboard shortcuts. Select the character that you want to format. For superscript, press Ctrl, Shift, and the Plus sign (+) at the same time. For subscript, press Ctrl and the Equal sign (=) at ...

This update is not intended to target Enterprise devices. Specifically, this update targets devices that run Windows 7 SP1 or later versions and Windows 8.1 or later versions that are either Home, Professional, Ultimate, Starter, or Core editions.

Edit a contact list. On the side panel, select People. Select All contact lists, then select Edit by either right-clicking the contact list or selecting it from the Ribbon. You'll have the option to rename the contact list, add additional contacts to the list, or add a Description to the list. When you are finished, select Save.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Open each source sheet. In your destination sheet, select the upper-left cell of the area where you want the consolidated data to appear. Note: Make sure that you leave enough cells to the right and underneath for your consolidated data. Go to Data > Consolidate. In the Function box, select the function that you want Excel to use to consolidate ...

Meet Windows 11. Make the everyday easier with Windows 11. When there's a lot to do, Windows 11 helps you get it done. With intuitive navigation and new multitasking tools, it brings you the performance you want and the security you need. Read on to get to know Windows 11.

Sign in to the Advanced security options page of your Microsoft Account. Sign in. Select Add a new way to sign in or verify then choose how you would like to receive security codes. Note: VOIP numbers cannot be added as a way to sign in or get verification codes. We'll send a security code to the new number or email to confirm.

When you enable an add-in, it adds custom commands and new features to Microsoft 365 programs that help increase your productivity. Because add-ins can be used by attackers to do harm to your computer, you can use add-in security settings to help protect yourself.

Windows 11 Windows 10. When you're in a conference room and need to project, connect your PC using one of the cable connectors in the room, press the Windows logo key + P, and then choose one of the four options: PC screen only. You'll see everything on your PC. (When you're connected to a wireless projector, this option changes to Disconnect.)