FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define.
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
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
Manage devices used with your Microsoft account
Download Microsoft Edge, Microsoft Launcher, or Link to Windows from the Google Play Store and sign in with your Microsoft account.
Applies To: Microsoft account dashboard
Schedule a meeting in Microsoft Teams - Microsoft Support
The scheduling form is where you'll give your meeting a title, invite people, and add meeting details. Use the Scheduling Assistant to find a time that works for everyone.. In Scheduling Assistant, you can see attendees' time zones, schedules, and availability during different timeslots. The Scheduling Assistant grid will show each attendee's schedule.
Applies To: Microsoft Teams
Create a PivotTable to analyze worksheet data - Microsoft Support
Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...
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
Sign in and start apps from the My Apps portal - Microsoft Support
Download and install the My Apps Secure Sign-in Extension. Download and install the My Apps Secure Sign-in Extension, if you're prompted. This extension helps you use your desktop browser to use single sign-on with your organization's cloud apps.
Sync your account in Outlook to the Microsoft Cloud
To enhance your Microsoft 365 experience in new Outlook for Windows, Outlook.com, Outlook for iOS, Outlook for Android, and new Outlook for Mac, you can now sync your non-Microsoft accounts (including their emails, contacts, and events) to the Microsoft Cloud.
Applies To: Outlook 2021 for Mac, Outlook 2019 for Mac, Outlook.com, New Outlook for Windows, Outlook for Android, Outlook for iOS
Download languages and voices for Immersive Reader, Read Mode, and Read ...
6. After the new language is installed, navigate to Language and find it in your Preferred languages list. Select your language and choose Options to adjust other language settings, download features, etc. Speech settings and voices. If text-to-speech is available in your language, you can adjust voice settings to change reader voices and speeds when using audible features like Read Aloud in ...
Applies To: OneNote for Microsoft 365, OneNote 2021, Word 2016, OneNote 2016, Immersive Reader
Add or remove items from a drop-down list - Microsoft Support
After you update a drop-down list, make sure it works the way you want. For example, check to see how to Change the column width and row height to show your updated entries. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.
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
Sign in using Microsoft Authenticator - Microsoft Support
Using Authenticator as a way to sign in. If you have turned on passwordless, two-step, or multi-factor authentication for your account, use the following steps to sign-in: