Introduction to Outlook Data Files (.pst and .ost)
Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
UNIQUE function - Microsoft Support
Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Take meeting notes in Microsoft Teams - Microsoft Support
Improve your meeting organization and effectiveness with meeting notes in Teams. Add agendas, notes, and tasks that can be viewed and edited by participants directly in Teams, with the option to share and edit them in Office.com. Optimize your meeting experience by editing notes before or after the meeting from your Teams Calendar or web browser.
Applies To: Microsoft Teams
Examples of common formulas in lists - Microsoft Support
Using formulas in calculated columns in lists can help add to existing columns, such as calculating sales tax on a price. These can be combined to programmatically validate data.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint Server Central Admin 2013, SharePoint in Microsoft 365, SharePoint Server 2010, Microsoft Lists, SharePoint in Microsoft 365 Small Business
How to change your keyboard layout - Microsoft Support
Summary. This article describes how to change keyboard layouts for the Microsoft keyboards listed in the "Applies To" section. You can configure your keyboard to use a different language or keyboard layout, such as Canadian Multilingual, Spanish, or United States-Dvorak.
SWITCH function - Microsoft Support
The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
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
Import Gmail to Outlook - Microsoft Support
Step 1: Prepare Gmail for connecting to Outlook. Before you connect your Gmail account and Outlook, you need to prepare your Gmail account: turn on 2-step verification for Gmail and then create an app password that Outlook/Microsoft 365 will use with your Gmail address to make the connection.. Step 2: Add your Gmail account to Outlook
Applies To: Outlook 2016, Outlook 2013, Outlook Web App for Office 365, Outlook on the web, Outlook on the web for Exchange Server 2016, Outlook Web App
Change the email address or phone number for your Microsoft account
Warning When removing an email alias that’s connected to a Microsoft domain (such as @Outlook.com, @Live.com, or @Hotmail.com), that email is completely deleted from our systems and can’t be used to send or receive emails. It won’t be available for use again as an alias on another account. Microsoft doesn’t recycle email addresses, so it can’t be reclaimed at a future time.
Change settings in Microsoft Teams - Microsoft Support
Change Teams settings. Teams will reflect the same date and time format as your device's language, date, and time settings. For example, if your device's display language is set to English (United States), the date and time in Teams will display the regional format used in the United States.. Change your language settings
Applies To: Microsoft Teams
Join your work device to your work or school network
Join your work-owned Windows 10 device to your organization's network so you can access potentially restricted resources. What happens when you join your device