Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Use voice typing to talk instead of type on your PC
To Insert this. Say this ' 撇 號 . 上 標 點 . 略 縮 號 -減 號 . 連 字 號 ! 感 歎 號 . 驚 嘆 號 # 井 字 號 $ 美 元 符 號 % 百 分 號
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
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
Activation dOffice - Support Microsoft
Si cet écran s’affiche, Microsoft 365 est installé sous forme de version d’évaluation Microsoft 365 Famille. Cet écran s’affiche si vous vous connectez à Microsoft 365 qui était déjà installé sur un nouvel appareil mais que vous n’avez pas de produit Microsoft 365 associé à votre compte.
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, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Publisher 2016, Office 2016, Microsoft 365 for home, Office for business, Office.com, Project for Office 365
Stay protected with Windows Security - Microsoft Support
Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.
Turn off Defender antivirus protection in Windows Security
Select the Windows Security app from the search results, go to Virus & threat protection, and under Virus & threat protection settings select Manage settings.
TEXTSPLIT function - Microsoft Support
Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form.It allows you to split across columns or down by rows.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web
Get started with PowerPoint for the web - Microsoft Support
With PowerPoint for the web you create presentations right in your browser. Create and save your presentations in your OneDrive, and edit and share them online.
Applies To: PowerPoint for the web
How to access OneDrive settings - Microsoft Support
Tips: If you don't see the OneDrive icon, OneDrive might not be running. On a PC, go to Start, type OneDrive in the search box, and then click OneDrive in the search results. You might need to click the Show hidden icons arrow next to the notification area to see the OneDrive icons. On a Mac, use Spotlight to search for OneDrive and open it.
Applies To: OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Use the On-Screen Keyboard (OSK) to type - Microsoft Support
To open the On-Screen Keyboard. Go to Start , then select Settings > Accessibility > Keyboard, and turn on the On-Screen Keyboard toggle. A keyboard that can be used to move around the screen and enter text will appear on the screen. The keyboard will remain on the screen until you close it.