Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.

Edit pictures with the Photos app in Windows. Windows 11 and Windows 10 have an app named Photos, a successor to Picture Manager, that lets you edit photos.For information on how to open and use it, see Edit photos and videos.. Edit a photo you've inserted in an Office document

To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.

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.

OneDrive.You can use OneDrive to sync both your work or school files and personal files. The storage remains separate, so you can't sync work or school folders to your OneDrive personal folders, but you can copy or drag and drop files from one to another.

What are passkeys? Passkeys are a replacement for your password. With passkeys, you can sign into your Microsoft personal account, or your work/school account using your face, fingerprint, or PIN.

Use the Xbox Accessories app to configure your controller or headset for your preferred gaming experience.

Work with your files in your file system. Once you're synced, you’ll see your files in File Explorer. On a Mac, your files will appear under OneDrive in the Mac Finder.. If you use more than one account, your personal files appear under OneDrive – Personal and your work or school files appear under OneDrive - CompanyName.. You can copy or move files from your computer to OneDrive right ...

Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.

List view. A unique feature of the Tasks app how it displays tasks and information associated with them in rows and columns. This is called List view, and allows you to change many tasks at once, which wasn't as possible in either To Do or Planner before.