GETPIVOTDATA function - Microsoft Support
Argument. Description. data_field. Required. The name of the PivotTable field that contains the data that you want to retrieve. This needs to be in quotes.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013
How to sign in to a Microsoft account - Microsoft Support
Microsoft accounts are for personal use, and for accessing services like Outlook.com, Xbox or Skype. Microsoft work and school accounts are for organizations that use Microsoft 365 for business.. Choose your account type, or learn more about the differences.
Applies To: Microsoft 365 for home, Outlook.com, Microsoft 365 for Mac, Microsoft 365 for Windows, Microsoft account dashboard, Microsoft Edge, Microsoft Teams, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Create a summary of your document with Copilot - Microsoft Support
In Copilot's summary, select References to view citations of where Copilot pulled information from inside the document.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for iPad, Word Web App
Using web parts on SharePoint pages - Microsoft Support
Divider. The Divider web part inserts a line between other web parts to help break up your page and make it easier to read.. Document library. The Document library web part displays a document library you can customize with your own title, view, and size. Users with appropriate permissions can view or edit files directly from the web part or can go to the full document library by clicking See all.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, SharePoint admin center, SharePoint operated by 21Vianet
Windows keyboard tips and tricks - Microsoft Support
Keystroke. What it does. Windows logo key + R Opens the Run command. Windows logo key + S Opens Search. Windows logo key + E Opens File Explorer. Alt + Tab. Opens Task Switcher, moving forward with each press of Tab, switching to that window on release
Digital signatures and certificates - Microsoft Support
Certificate authority (CA) A certificate authority is an entity similar to a notary public.It issues digital certificates, signs certificates to verify their validity and tracks which certificates have been revoked or have expired.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016
What's new in Office 2021 - Microsoft Support
Immersive Reader advanced color support. In Immersive Reader, we've added many additional ways you can choose a page color.Selecting a page color can make text easy to scan with less eye strain. On the Immersive Reader tab click Page Color to see a 4x5 color picker.. Click More Colors to see additional color selection options such as Wheel, Sliders, Color Palettes, Image Palettes, and Pencils.
Applies To: Office 2021, Office 2021 for Mac
PowerPoint for Windows training - Microsoft Support
Training: Watch and learn how to use PowerPoint in Windows. Explore PowerPoint training guides, articles, and how-to videos.
Applies To: PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016, Office for business
Manage audio settings in Microsoft Teams meetings
Audio source. When you choose this... Computer audio Your computer's default speaker and mic will be used during the meeting. To adjust your PC mic and speaker settings, select Open device settings .. In Audio settings, select the audio devices you want to use from the Speaker and Microphone dropdown menus.You can alsoturn on spatial audio and adjust noise suppression.
Applies To: Microsoft Teams
Headers and footers in a worksheet - Microsoft Support
Instead of picking a built-in header or footer, you can choose a built-in element. Many elements (such as Page Number, File Name, and Current Date) are found on the ribbon.For worksheets, you can work with headers and footers in Page Layout view. For chart sheets or charts, you can work with headers and footers in the Page Setup dialog box.. Select the worksheet to which you want to add ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016