INDEX function - Microsoft Support
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.
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
Insert PDF file content into a PowerPoint presentation
In the Insert Object box, select Create from file, and then enter the PDF file location; or select Browse, find the PDF file, and then select OK.. This makes the PDF file part of the presentation file. The quality of the PDF file is reduced with this method, but you can open the full PDF file by double-clicking the image when viewing or editing in Normal view.
Applies To: PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016
Share your network printer - Microsoft Support
In Windows 10, you can share your printer with many PCs on your network. To share a printer from the PC that the printer is connected to (the primary PC) with secondary PCs that the printer is not connected to, you must set up sharing settings for the printer, connect the printer to the primary PC (either wirelessly or by using a USB cable), and then turn on the printer.
Use the Tasks app in Teams - Microsoft Support
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.
Applies To: Microsoft Planner, Microsoft Teams, Microsoft To Do
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
Change the refresh rate on your monitor in Windows
Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.
Accessing Credential Manager - Microsoft Support
Credential Manager lets you view and delete your saved credentials for signing in to websites, connected applications, and networks. To open Credential Manager, type credential manager in the search box on the taskbar and select Credential Manager Control panel.
Manage your call settings in Microsoft Teams
Adjust your voicemail settings. To change your voicemail settings, select Settings and more next to your profile picture at the top of Teams and then choose Settings > Calls. You will find all voicemail settings under Manage voicemail.. Voicemail greeting. To record a new voicemail greeting, select Record a greeting and follow the instructions to record your message.
Applies To: Microsoft Teams
Create and print a single envelope - Microsoft Support
Click the Printing Options tab.. The printer driver tells Word which way the envelope should be loaded into the printer, and this information is displayed in the Printing Options tab of the Envelope Options dialog box.. 1. The feed method determines the position of the envelope (right, middle, left) and whether the long or short edge is being fed into the printer.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
Other email accounts like Gmail and Yahoo not working in Outlook.com
New or classic Outlook for Windows desktop apps Classic Outlook for Windows is a desktop app included with Microsoft 365 Personal or Family subscriptions or non-subscription versions of Office such as Office Home & Business. New Outlook for Windows is available free on Windows devices or as a free download.If you don't already have new Outlook, you can download it from the Microsoft Store ...
Applies To: Outlook.com