VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
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
Install Office updates - Microsoft Support
Learn how to update Microsoft Office on PC and troubleshooting tips for installing Office updates.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, InfoPath 2013, InfoPath Filler 2013
Keyboard shortcuts to add language accent marks in Word and Outlook ...
Learn how to use keyboard shortcuts in Word to add accent marks, special characters, symbols, and more.
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, Word 2021, Outlook 2021, Word 2019, Outlook 2019, Word 2016, Outlook 2016
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
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 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Setup OneDrive for Microsoft 365 for business
OneDrive is your online cloud storage within Microsoft 365. It lets you store your individual work files that you don't want your colleagues to have access to unless you choose to share the files with them.
How to sign in to a Microsoft account - Microsoft Support
Use your Microsoft account to sign in to Microsoft services like Windows, Microsoft 365, OneDrive, Skype, Outlook, and Xbox Live.
Applies To: Microsoft 365 for home, Outlook.com, Microsoft 365 for Mac, Microsoft 365 for Windows, Microsoft account dashboard, Microsoft Edge, Microsoft Teams, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Change desktop background and colors - Microsoft Support
Learn how to change your Windows desktop background (wallpaper) and accent color using personalization settings.
Fix touchpad problems in Windows - Microsoft Support
Things to try to fix touchpad problems in Windows 10 and 11. If your touchpad isn’t working, it may be a result of a missing or out-of-date driver.
Create and add an email signature in Outlook.com or Outlook on the web
Learn how to create and add a signature to email messages you send in Outlook.com.
Applies To: Outlook on the web, Outlook.com, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Create a drop-down list - Microsoft Support
You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.
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