About Power Query in Excel - Microsoft Support
With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Roles in Microsoft Teams meetings - Microsoft Support
Capability. Organizer. Co-organizer. Presenter. Attendee. Speak and share video Participate in meeting chat Share content
Applies To:
Microsoft Teams
Hide or display cell values - Microsoft Support
Hide cell values. Select the cell or range of cells that contains values that you want to hide. For more information, see Select cells, ranges, rows, or columns on a worksheet .
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Help protect my PC with Microsoft Defender Offline
How do I use Microsoft Defender Offline. Save any open files and close all apps and programs.
How to correct a #SPILL! error - Microsoft Support
Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.
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 for iPad, Excel Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Record a presentation - Microsoft Support
When you're ready, select the round, red Record button, wait for the countdown, then start speaking. To record from a specific slide, go to it, and then select Record.
Applies To:
PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016
Xbox Status | Xbox Support
Check the Xbox services, games, and apps for any service outages.
Enable or disable macros in Microsoft 365 files
Disable all macros except digitally signed macros Macros are disabled, and security alerts appear if there are unsigned macros present.However, if the macro is digitally signed by a trusted publisher, the macro just runs. If the macro is signed by a publisher you haven't trusted yet, you are given the opportunity to enable the signed macro and trust the publisher.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016
Add the battery icon to the taskbar in Windows 10
On a device that uses battery power, if you select Start > Settings > Personalization > Taskbar and the Power toggle is greyed out or not visible, in the Search box on the taskbar, type device manager, and then select Device Manager in the list of results. Under Batteries, right-click (or long-press) the battery for your device, select Disable, and select Yes.
How to get and use app passwords - Microsoft Support
After you turn on two-step verification or set up the Authenticator app, you may run into issues if you use older devices (like Xbox 360 or a mail-sending security camera) that don't support two-step verification. For those devices, you can sign in with an app password instead. An app password is a long, randomly generated password that you provide only once instead of your regular password ...