FILTER function - Microsoft Support
In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").
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
Create, view, and edit contacts and contact lists in Outlook
When you click someone's name or picture in Outlook or other Office apps and services, you'll see their profile card with information about them. From their profile card, you can save them to your own contacts, for example if you want to add Notes or other information.
Applies To:
Microsoft 365 admin, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016
Add or manage an iCloud email account in Outlook
If prompted, enter your password. However, if you have two-factor authentication set up, you might see a window asking you to Create an app-specific password.To obtain an app-password, do the following:
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Sync SharePoint files and folders - Microsoft Support
Both options allow essentially the same thing—you can access files on your local computer in File Explorer or Finder. However, adding OneDrive shortcuts allows content to be accessed on all devices, whereas sync is related to a specific device.
Applies To:
SharePoint in Microsoft 365
Create a presentation in PowerPoint - Microsoft Support
Training: Watch and learn how to create a PowerPoint presentation, add/format text, and add pictures, shapes, and/or charts.
Applies To:
PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016
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
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To:
Microsoft Teams
Create, load, or edit a query in Excel (Power Query) - Microsoft Support
Tip Sometimes the Load To command is dimmed or disabled. This can occur the first time you create a query in a workbook. If this occurs, select Close & Load, in the new worksheet, select Data > Queries & Connections > Queries tab, right click the query, and then select Load To.Alternatively, on the Power Query Editor ribbon select Query > Load To. ...
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Add or invite people outside your org to a chat in Microsoft Teams
With External Access for Teams, you can add or invite anyone outside of your Teams org who uses Teams, Teams for personal use, Skype (for consumers), and Skype for Business to a one-to-one chat.
Applies To:
Microsoft Teams
What happens if there's an unusual sign-in to your account
Select Review activity to check for any unusual sign-in attempts on the Recent activity page.If you see account activity that you're sure wasn't yours, let us know and we can help secure your account—if it's in the Unusual activity section, you can expand the activity and select This wasn't me.If it's in the Recent activity section, you can expand the activity and select Secure your account.