Using structured references with Excel tables - Microsoft Support
In our example data, we used the name DeptSales.. Use the following rules for table names: Use valid characters Always start a name with a letter, an underscore character (_), or a backslash (\).Use letters, numbers, periods, and underscore characters for the rest of the name.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013, Excel Mobile
Welcome to your email - Microsoft Support
Training: Watch and learn how to use your Outlook inbox.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Gaming Services Repair Tool for PC | Xbox Support
If you are having issues installing or updating Gaming Services on your PC, or if you are noticing that the Xbox app for PC is launching with missing content, you may want to download and run the Gaming Services Repair Tool for PC.
Add an app to run automatically at startup in Windows 10
Right-click the app, select More, and then select Open file location.This opens the location where the shortcut to the app is saved. If there isn't an option for Open file location, it means the app can't run at startup.
Create an Outlook Data File (.pst) to save your information
Select OK.Type a password in both the Password and Verify Password text boxes and select OK again.. If you set a password, you must enter it every time that the data file is opened — for example, when Outlook starts or when you open the data file in Outlook.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business
Check the recent sign-in activity for your Microsoft account
If you get an email about unusual activity on your Microsoft account, or if you’re worried that someone else might have used your account, go to the Recent activity page.You’ll see when your Microsoft account was signed in during the last 30 days, along with any device or app-specific info.
Applies To: Microsoft account dashboard
Manage notifications in Microsoft Teams - Microsoft Support
Missed activity emails. In the Missed activity emails section, you’re able to set the frequency of summary emails detailing your missed activity, or turn this feature off.. Chats and channels notifications. Notifications for chats and channels can be managed at a granular level, allowing you to customize your notifications to your personal work style.
Applies To: Microsoft Teams
IFS function - Microsoft Support
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.
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
Reset OneDrive - Microsoft Support
Important: You won't lose files or data by resetting OneDrive on your computer.Resetting OneDrive only disconnects all your sync connections (including personal and work or school).
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Change notification settings in Windows - Microsoft Support
To change notification settings for individual senders, under Get notifications from these senders, turn a notification sender either on or off—or select a sender's name and then turn on or turn off notification banners, lock screen privacy, turn notification sounds on or off, and set the priority of notifications.