Turn your data into insights. List of all Excel functions available. VLOOKUP function. IF function. Create a drop-down list. Combine text from two or more cells. Freeze panes to lock rows & columns. Create a PivotTable to analyze worksheet data. Design the layout and format of a PivotTable.

On the Choose an account screen, click the Microsoft account button.; On the Add your Microsoft account screen, enter the email address and password associated with your Microsoft account.; On the Make it yours screen, you'll have the option to make this Microsoft account your primary account. (This makes sign-in, settings, and syncing happen automatically for all other Microsoft services.)

In the search box on the taskbar, type file explorer, and then select it from the list of results. Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder . To decompress files. Open File Explorer and find the compressed folder. To unzip the entire folder, right-click to select Extract All, and then follow the ...

Windows Security provides built-in security options to help protect your device from malicious software attacks. To access the features described below, tap the Windows Start button, type windows security, select it from the results, and then select Device security. Notes: What you actually see on the Device security page may vary depending ...

In the following example, you'll see how to add and subtract dates by entering positive or negative numbers. Enter the number of days to add or subtract in column B. You can enter a negative number to subtract days from your start date, and a positive number to add to your date. In cell C2, enter =A2+B2, and copy down as needed.

Make Start full screen. You can make Start full screen and see everything in one view. Select Start , then select Settings > Personalization . Select Start , and then turn on Use Start full screen. The next time you open Start, the Start screen will fill the entire desktop. Select All apps in the Start screen for a full-screen view of all your ...

Use a fix-it tool with Windows 10. Instead of fix-it tools, Windows 10 uses troubleshooters to help you solve problems with your PC. To run a troubleshooter: Select Start > Settings > Update & Security > Troubleshoot > Additional troubleshooters , or select the Find troubleshooters shortcut at the end of this topic, and then select Additional ...

Select the new My Apps Secure Sign-in Extension icon , and then select Sign in to get started. Right-click the Settings icon , and then select Settings. In the Settings box, select the number of recent apps you want to see on the portal, and whether to allow your organization's internal URLs to redirect so you can use them remotely.

Enter your Microsoft 365 email address, and then select Connect. Enter any additional email addresses that you want to use and then select Next. After all your accounts have been added, choose if you want to set up Outlook mobile or wait until later. Select Done. It can take several minutes for Outlook to download your email and other data.

Manage user accounts in Windows. Windows allows adding multiple user account to use the same device, enabling each user to have their own settings, documents, and applications. For example, parents can have their own accounts with administrative privileges to manage settings and install software, while children can have standard accounts with ...