UAC can help keep viruses from making unwanted changes. To open UAC, swipe in from the right edge of the screen, and then tap Search. (If you're using a mouse, point to the upper-right corner of the screen, move the mouse pointer down, and then click Search .) Enter uac in the search box, and then tap or click Change User Account Control settings.

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.

Note: Offers vary by country.Be sure to redeem your rewards points in the same region you signed up in. Do not use a VPN while trying to redeem points. When redeeming points, use a mobile or landline phone number for authentication and not a VoIP phone number.

Make sure all columns have headers, with a single row of unique, non-blank labels for each column. Avoid double rows of headers or merged cells. Format your data as an Excel table (select anywhere in your data, and then select Insert > Table from the ribbon). If you have complicated or nested data, use Power Query to transform it (for example ...

Press the Xbox button to open the guide, select Profile & system > Settings > Devices & connections > Controllers & headsets, and then select the controller you want to update. On the Xbox Wireless Controller screen, select “…” to check the firmware version for your controller. If it says “Update,” select Firmware version, and then ...

Email is automatically deleted from your Deleted Items folder after 30 days. Items removed from your Deleted Items folder are recoverable for 30 days. Junk email is retained for 10 days before it is automatically deleted. Email folder names are the same, but folder hyperlinks listed below will not work if you sign in with a work or school account.

When Smart charging is on, you’ll see a heart on the Battery icon in the following places—on the right side of the taskbar and in Power & battery settings. When your hover over the Battery icon with your mouse, it says “Fully Smart charged” and means the battery isn’t charging even though your device is still plugged in.

It may be possible for your IT admins to help with password recovery, but only if they had implemented the DocRecrypt tool before you created the document password. Go to File > Info > Protect Document > Encrypt with Password. Type a password, press OK, type it again and press OK to confirm it. Save the file to make sure the password takes effect.

If you want to open or close an Outlook Data File (.pst), you can do that in a few simple steps. Note: If your organization has policies in place that archive email messages automatically, your older email messages, calendar events, and tasks might be stored in an archive Outlook Data File (.pst). Even if your account uses an offline Outlook ...

OneDrive icon with sync pending arrows. The circular arrows over the OneDrive or OneDrive for work or school notification icons signify that sync is in progress. This includes when you are uploading files, or OneDrive is syncing new files from the cloud to your PC. OneDrive will also check for other file or folder changes and may show ...