Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Block or allow (junk email settings) - Microsoft Support
Manage your junk email. At the top of the screen, select Settings > Mail. Under Options, select Block or allow. Select this option if you want to turn off junk email filtering. If you select this, you won’t be able to use any of the other options on this page.
Applies To: Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Sync SharePoint and Teams files with your computer
Near the upper left corner of the browser page, select the Microsoft 365 app launcher: From the menu that opens, select SharePoint or Teams, and then select the site with the files you want to sync. Select Documents or navigate to the subfolder you want to sync. Select Sync. (You only need to do this once on a computer to set up syncing on that ...
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, OneDrive (work or school), OneDrive (work or school) operated by 21Vianet, OneDrive for Windows, SharePoint admin center, SharePoint operated by 21Vianet
Import data from a folder with multiple files (Power Query)
A "Transform File" function query uses the "Parameter1" query to specify each file (or binary) as input to the "Sample File" query. This query also creates the Content column containing the file contents and automatically expands the structured Record column to add the column data to the results. The "Transform File" and "Sample File" queries are linked, so that changes to the "Sample File ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Find your product key for Office 2007 - Microsoft Support
You can find the product key in one of the following locations: Sticker on the CD case or other packaging. Certificate of Authenticity. Confirmation email message received from an online purchase. Important: Don't lose your Product Key. Keep the packaging, or write the number down and keep it in a safe place.
Applies To: Excel 2007, Word 2007, Outlook 2007, PowerPoint 2007, Access 2007, OneNote 2007, Project 2007, Project Standard 2007, Publisher 2007, Visio 2007, Visio Standard 2007
Create a PivotTable to analyze worksheet data - Microsoft Support
Make sure all columns have headers, with a single row of unique, non-blank labels for each column. Avoid double rows of headers or merged cells. Format your data as an Excel table (select anywhere in your data, and then select Insert > Table from the ribbon). If you have complicated or nested data, use Power Query to transform it (for example ...
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
IF function – nested formulas and avoiding pitfalls
The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. IF statements are incredibly robust, and form the basis ...
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 Web App, Excel for Windows Phone 10
Share a page of notes or an entire notebook from OneNote for Windows 10
In the upper right corner of the app window, click or tap Share. Note: If you don’t see the Share button, you might be using OneNote 2016 and not OneNote for Windows 10. Although you can’t share a single page of notes in OneNote 2016, you can send OneNote notes in email. At the bottom of the Send Link pane, click or tap Send copy of page.
Applies To: OneNote for Windows 10
Create a timeline in PowerPoint - Microsoft Support
On the Insert tab, click SmartArt. In the Choose a SmartArt Graphic gallery, click Process, and then double-click a timeline layout. Tip: There are two timeline SmartArt graphics: Basic timeline and Circle Accent Timeline, but you can also use almost any process-related SmartArt graphic. Click [Text], and then type or paste your text in the ...
Applies To: PowerPoint for Microsoft 365, PowerPoint for the web, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016, PowerPoint 2013
Get started in Shifts - Microsoft Support
From the app, you can create a schedule for a Teams team that doesn't have one yet: Go to the top left of the app and select the team name. Select Create team and choose the team you want to create a schedule for. Make sure the time zone is correct for the shifts you’ll be scheduling, and then choose Create. Now that you've created a schedule ...
Applies To: Microsoft Teams
Protect a document with a password - Microsoft Support
It may be possible for your IT admins to help with password recovery, but only if they had implemented the DocRecrypt tool before you created the document password. Go to File > Info > Protect Document > Encrypt with Password. Type a password, press OK, type it again and press OK to confirm it. Save the file to make sure the password takes effect.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016