Help in File Explorer - Microsoft Support
To open File Explorer, select Windows logo key + E or go to Start and type File Explorer in the search box. Select File Explorer in the results.. Top topics. Here are answers to a few common questions about File Explorer: How can I open File Explorer and find the Windows 11 features?
What are IMAP and POP? - Microsoft Support
IMAP and POP are two methods to access email. IMAP is the recommended method when you need to check your emails from several different devices, such as a phone, laptop, and tablet.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Microsoft 365 admin, Outlook.com, Outlook Web App for Office 365 operated by 21Vianet, New Outlook for Windows, Outlook Mail for Windows 10
Transpose (rotate) data from rows to columns or vice versa
Note: If your data is in an Excel table, the Transpose feature isn't available.You can convert the table to a range first, or you can use the TRANSPOSE function to rotate the rows and columns.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
View a presentation without PowerPoint - Microsoft Support
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Applies To: PowerPoint for Microsoft 365, PowerPoint for the web, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016, PowerPoint Mobile
Insert data from picture - Microsoft Support
Take a picture of some printed data Maybe you’d like to get data from your previous tax returns into Excel and you only have printed copies.Just take a picture of each one, transfer the pictures to your computer (OneDrive is great for this). Then, click Data > From Picture > Picture From File and follow the on-screen instructions to convert picture to data.
Applies To: Excel for Microsoft 365
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
Analyze Data in Excel - Microsoft Support
Analyze Data in Excel empowers you to understand your data through high-level visual summaries, trends, and patterns. Simply click a cell in a data range, and then click the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web
SUBSTITUTE function - Microsoft Support
This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel.. Description. Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.
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
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
Share SharePoint files or folders - Microsoft Support
Tip: To quickly share with specific people, you can type in their name or email and then use the pencil icon to the right of the Name, group or email field to select Can edit or Can view.Then follow the same steps below to share with the specific people you listed. For Word documents, you can use the Can review option to let someone add comments and suggestions but prevent them from making edits.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet