Use data validation rules to control the type of data or the values that users enter into a cell. One example of validation is a drop-down list (also called a drop-down box or drop-down menu). Watch more in this video.

Training: Watch these videos to help your school, work, or organization use Microsoft Teams to video conference, work remotely, and become proficient using Teams.

The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.

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.

You can use a PivotTable to summarize, analyze, explore, and present summary data. PivotCharts complement PivotTables by adding visualizations to the summary data in a PivotTable, and allow you to easily see comparisons, patterns, and trends.

Find and open File Explorer in Windows 10 and Windows 11, and customize Quick access by pinning and removing files and folders.

Learn how to get Microsoft Store updates for your apps and games. Download the latest versions of Microsoft Store apps and games.

If you forgot your work or school password, never got a password from your organization, or have been locked out of your account, you can use your security info and your mobile device to reset your work or school password.

Learn how to record or create macros and execute them using buttons or keyboard shortcuts in Microsoft Office applications.

Learn how to enable Adobe Flash in Microsoft Edge. By pressing submit, your feedback will be used to improve Microsoft products and services.