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:
Excel calendar templates - Microsoft Support
Download a calendar template: Browse through the calendar templates, choose an Excel calendar template that is best for you.Click the Download button on the template page, open the template file in Excel, and then edit and save your calendar.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
How to go passwordless with your Microsoft account
Going passwordless refers to removing your password and using a passwordless method to sign in instead. Passwordless solutions such as Windows Hello, the Microsoft Authenticator app, SMS or Email codes, and physical security keys provide a more secure and convenient sign-in method. While passwords can be guessed, stolen, or phished, only you can provide fingerprint authentication, or provide ...
Applies To: Microsoft account dashboard
Turn off Scroll Lock - Microsoft Support
Tip: To quickly open the On-screen Keyboard in Windows 11, click the Windows button.Begin typing On-Screen Keyboard which will appear in the search entry box. Under Search, which will appear as a list above the search box, click the On-Screen Keyboard search result. When the on-screen keyboard appears, click the ScrLk button.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Phone Link help & learning
Introducing Microsoft Phone Link Our evolution of the former Your Phone app brings a new name to the user experience. With the new Phone Link on your Windows PC and the new Link to Windows app on your Android device, accessing your mobile apps and content has never been easier!
Create a table in Excel - Microsoft Support
Training: In Microsoft Excel, you can create a table to easily group and analyze data. Then you can quickly format the table and apply a design style. Watch this video to learn how.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Use the Analysis ToolPak to perform complex data analysis
The CORREL and PEARSON worksheet functions both calculate the correlation coefficient between two measurement variables when measurements on each variable are observed for each of N subjects. (Any missing observation for any subject causes that subject to be ignored in the analysis.) The Correlation analysis tool is particularly useful when there are more than two measurement variables for ...
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
Format a date the way you want - Microsoft Support
When you enter some text into a cell such as "2/2", Excel assumes that this is a date and formats it according to the default date setting in Control Panel.Excel might format it as "2-Feb".If you change your date setting in Control Panel, the default date format in Excel will change accordingly.
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
ROUND function - Microsoft Support
Description. The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula:
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
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