Better together tip: Manage drafts from Outlook for iOS and Outlook for Android. If you use Outlook for iOS or Outlook for Android, your drafts will automatically synchronize to your mobile device.From there, you can finish messages you've started at your computer, easily add attachments from your photos or camera, or use Office Lens to capture notes from a whiteboard in a meeting.

Tipp: Versuchen Sie, die neuen Funktionen XLOOKUP und XMATCH zu verwenden, verbesserte Versionen der in diesem Artikel beschriebenen Funktionen. Diese neuen Funktionen funktionieren in beliebige Richtungen und geben standardmäßig genaue Übereinstimmungen zurück, sodass sie einfacher und bequemer zu verwenden sind als ihre Vorgänger.

How does multifactor authentication work? Let's say you're going to sign into your Microsoft account or work or school account, and you enter your username and password.If that's all you need then anybody who knows your username and password can sign in as you from anywhere in the world!

Analyze Data in Excel empowers you to understand your data through high-level visual summaries, trends, and patterns. Simply click a cell in a data range, and then click the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane.

To add another account to OneDrive on your computer. If you already have a personal OneDrive account set up, you can only add work or school accounts.

Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.

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.

Argument. Description. start_date . Required. A date that represents the first, or starting date of a given period. Dates may be entered as text strings within quotation marks (for example, "2001/1/30"), as serial numbers (for example, 36921, which represents January 30, 2001, if you're using the 1900 date system), or as the results of other formulas or functions (for example, DATEVALUE("2001 ...

Note: To let a user enter percentages, for example 20%, select Decimal in the Allow box, select the type of restriction that you want in the Data box, enter the minimum, maximum, or specific value as a decimal, for example .2 , and then display the data validation cell as a percentage by selecting the cell and clicking Percent Style in the Number group on the Home tab.

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 ("").