How to correct a #VALUE! error - Microsoft Support
Check your computer's date settings. Excel uses your computer's date system. If a cell's date isn't entered using the same date system, Excel won't recognize it as a true date.
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 Web App
Sign in - Microsoft Support
Training: Sign in to office.com with your Microsoft personal, work, or school account. Watch this video to learn how.
Applies To: Office 2021, Office 2019, Office 2016
Add and sync shared folders to OneDrive for home
When someone shares a folder with you, it appears in the Shared section of your OneDrive.com.If you have Edit permissions to those shared folders, you can add them to the My files section of your OneDrive to make them easier to access and work with. If you want to view and access shared folders on your PC or Mac, install the OneDrive app and sync your folders to your device.
Applies To: Office for business, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Set up a security key as your verification method
What is a security key? We currently support several designs and providers of security keys using the Fast Identity Online (FIDO2) passwordless authentication protocols. These keys allow you to sign in to your work or school account to access your organization's cloud-based resources when on a supported device and web browser.
Using a Microsoft account with a third-party email address
Syncing is a one-way connection that goes from your third-party account to your Outlook.com account. Changes made in your third-party account will be reflected in Outlook.com, but changes made directly in Outlook.com won't appear in your third-party account.
Applies To: Outlook.com
Share files and folders in OneDrive (personal) - Microsoft Support
It’s always good to stay on top of the content you’ve shared with friends, family, and collaborators. OneDrive makes it easy. Simply log into your account at OneDrive.com, and in the left-side navigation area, you’ll see a view called Shared.. This view lets you quickly see all of your content that’s shared, especially the content that you’ve shared with others.
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
How to correct a #N/A error in the VLOOKUP function
Tip: Also, refer to the Quick Reference Card: VLOOKUP troubleshooting tips which presents the common reasons for #NA issues in a convenient PDF file. You can share the PDF with others or print for your own reference.
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
Description of Microsoft System Information (Msinfo32.exe) Tool
Examples To view your System Information, type: msinfo32 To create an .nfo file in the folder C:\Temp with a name of Test.nfo, type:. msinfo32 /nfo C:\TEMP\TEST.NFO To create a .txt file in the folder C:\Temp with a name of Test.txt, type:. msinfo32 /report C:\TEMP\TEST.TXT To view System Information from a remote computer with a UNC name of BIGSERVER, type:
Help in WordPad - Microsoft Support
Get answers to common questions about WordPad. Here are a few tips to help you use WordPad: To open and save files, select File, then select New to create a new document, Open to work with an existing document, or Save to save your document.(If your document doesn't have a name, WordPad will ask you to provide one.)
Can't sign in to OneDrive - Microsoft Support
Select the Start button, search for "OneDrive", and then open it:
Applies To: OneDrive for Business, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows