Sign in to SharePoint - Microsoft Support
In the upper left corner of the window, select the app launcher > All apps > SharePoint Tip: If you don't see the SharePoint app under All apps, use the Search box near the top of the window to search for SharePoint.
Applies To: SharePoint in Microsoft 365
Microsoft Teams (free) - Microsoft Support
Connect with friends, family, and coworkers in Teams. Stay organized and connected with friends, family, and coworkers all from one app. Get started
Applies To: Microsoft Teams, Microsoft Teams personal, Microsoft Teams small business
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Change from a local account to a Microsoft account
When you initially setup your Windows device, you might have opted to use a local account instead of a Microsoft account. The main difference between a local account and a Microsoft account is that a local account is specific to one device, while a Microsoft account can be used across multiple devices and Microsoft services.
打开或关闭 Microsoft Defender 防火墙 - Microsoft 支持
若要将其关闭,请将设置切换为“关闭”。 关闭 Microsoft Defender 防火墙可能会使设备(以及网络,如果有)更容易受到未经授权的访问。
Improved copy and paste of URLs in Microsoft Edge
In an app, press Ctrl + V to use the default paste, which adds a link with the title of the page as the link text. If you're pasting into an app or website in Microsoft Edge, you can also right-click, select Paste as on the context menu, and then select Link (Default) from the sub-menu.
Hide or show rows or columns - Microsoft Support
Insert or delete rows, and columns Article; Select cell contents in Excel Article; Freeze panes to lock rows and columns Article; Hide or show rows or columns
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
Get started with Copilot in Microsoft Teams meetings
From the meeting chat, select Open Copilot in the upper-right corner of the chat—you'll see the Copilot icon.From here, Copilot bases responses on the meeting transcript, not the meeting chat. You'll see the same conversation history with Copilot as the one accessed from Recap.Select View prompts to choose from the suggestions, or try the following prompts:
Applies To: Microsoft Teams
INDIRECT function - Microsoft Support
Example. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
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
Create and print a single envelope - Microsoft Support
Click the Printing Options tab.. The printer driver tells Word which way the envelope should be loaded into the printer, and this information is displayed in the Printing Options tab of the Envelope Options dialog box.. 1. The feed method determines the position of the envelope (right, middle, left) and whether the long or short edge is being fed into the printer.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013