How to correct a #N/A error in the VLOOKUP function
Problem: The lookup value is not in the first column in the table_array argument. One constraint of VLOOKUP is that it can only look for values on the left-most column in the table array.
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, Excel for Windows Phone 10
Import Gmail to Outlook - Microsoft Support
Step 1: Prepare Gmail for connecting to Outlook. Before you connect your Gmail account and Outlook, you need to prepare your Gmail account: turn on 2-step verification for Gmail and then create an app password that Outlook/Microsoft 365 will use with your Gmail address to make the connection.. Step 2: Add your Gmail account to Outlook
Applies To:
Outlook 2016, Outlook 2013, Outlook Web App for Office 365, Outlook on the web, Outlook on the web for Exchange Server 2016, Outlook Web App
Present your data in a Gantt chart in Excel - Microsoft Support
Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks, like this:
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Mail merge using an Excel spreadsheet - Microsoft Support
Here are some tips to prepare your Excel spreadsheet for a mail merge. Make sure: Column names in your spreadsheet match the field names you want to insert in your mail merge.
Applies To:
Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
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
Microsoft Stream screen recorder - Microsoft Support
Free screen recorder with Microsoft 365 work or school account. Record your screen or create a new video in Microsoft Stream (on SharePoint), including webcam, background removal, inking, stickers, music, and text. Instantly share your video for others to view and get analytics.
Applies To:
Microsoft Stream, Stream on SharePoint
COUNT function - Microsoft Support
The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20).In this example, if five of the cells in the range contain ...
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
Bildschirmspiegelung und Projektion auf Ihren PC oder ihre drahtlose ...
Wählen Sie auf dem PC, von dem Sie projizieren möchten, Windows-Logo-Taste + K aus, und wählen Sie den PC aus, mit dem Sie eine Verbindung herstellen möchten. Alternativ können Sie in der Windows Search-Leiste nach Cast suchen und dann Verbindung mit einer drahtlosen Anzeige herstellen auswählen. Wählen Sie auf der Seite Anzeigeeinstellungen unter Mehrere Anzeigen die Option Mit einer ...
Supported devices for Phone Link experiences - Microsoft Support
Notes: If your Android device is running Android 11.0 or higher, you may be eligible for the multiple apps experience. Compatible devices are marked with an asterisk (*).
Энергоэффективные параметры в Windows 11
Обновления экран по умолчанию и параметры спящего режима теперь помогают более эффективно использовать энергию и продлить время работы батареи.