Examples of query criteria - Microsoft Support
Criteria. Description >25 and <50. This criterion applies to a Number field, such as Price or UnitsInStock. It includes only those records where the Price or UnitsInStock field contains a value greater than 25 and less than 50.. DateDiff ("yyyy", [BirthDate], Date()) > 30
Applies To: Access for Microsoft 365, Access 2021, Access 2019, Access 2016
LOOKUP function - Microsoft Support
Vector form. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.. Syntax. LOOKUP(lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments:. lookup_value Required.A value that LOOKUP searches for in the first vector.
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
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
Verwalten von Benutzerkonten in Windows - Microsoft-Support
Wichtig: Sie sollten die Anzahl der Administratoren auf Ihrem Windows-Gerät begrenzen, da Administratoren die vollständige Kontrolle über das System haben.Administratoren können Einstellungen ändern, Software installieren und auf alle Dateien zugreifen. Wenn zu viele Personen über diese Zugriffsebene verfügen, kann dies zu Sicherheitsrisiken wie der Installation von Schadsoftware oder ...
Install and set up Office on an iPhone or iPad - Microsoft Support
There are two ways to get Office on your iPhone: Tap the button below to install the new Office app for iOS that combines Word, Excel, and PowerPoint into a single app, which introduces new mobile-centric features to view, edit, and share files without the need to switch between multiple apps.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, OneNote for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Excel for the web, OneNote for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Office 2016, PowerPoint for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Office app for iOS, Outlook Web App, Skype for Business for iPad
Troubleshoot Outlook email setup - Microsoft Support
If you try to add an IMAP account to Outlook, for example a Gmail account, Apple account, Yahoo account, or an account from your local ISP, and you're not prompted to enter your password, use the following steps to work around the problem.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin
Work together on PowerPoint presentations - Microsoft Support
Share your file with others. To invite other people to access your PowerPoint file and collaborate, take these steps: With the presentation open, select the Share button in the top right corner of the ribbon. If you have not yet stored your presentation to OneDrive or SharePoint in Microsoft 365, a message will direct you to do so.
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016, PowerPoint for iPad, PowerPoint for iPhone, PowerPoint for Android tablets, PowerPoint for Android phones, PowerPoint Mobile
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
What is Microsoft 365? - Microsoft Support
Microsoft 365 is our cloud-powered productivity platform. With a subscription to Microsoft 365, you can get: The latest productivity apps, such as Microsoft Teams, Word, Excel, PowerPoint, Outlook, OneDrive, and so much more.
Applies To: Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin
Get help with Microsoft Photos app - Microsoft Support
Edit photos and videos. Whether you like to apply changes that affect your photo's quality, feel, and look—or you want to add information on top of your photos, the Photos app offers you comprehensive features to transform your photos and videos looking their best.