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.

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.

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.

Vector form. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.. Syntax. LOOKUP(lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments:. lookup_value Required.A value that LOOKUP searches for in the first vector.

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 ...

Cumulative Update 23 for Microsoft Exchange Server 2016 was released on April 20, 2022. It includes fixes for nonsecurity issues and all previously released fixes for security and nonsecurity issues. These fixes will also be included in later cumulative updates for Exchange Server 2016 . This update also includes new daylight saving time (DST ...

Protect yourself from phishing. Phishing (pronounced: fishing) is an attack that attempts to steal your money, or your identity, by getting you to reveal personal information -- such as credit card numbers, bank information, or passwords -- on websites that pretend to be legitimate. Cybercriminals typically pretend to be reputable companies ...

Export contacts out of other email services. Export iCloud contacts. Export Gmail contacts – See Gmail help. Export Yahoo contacts – See Yahoo import and export help. Export Thunderbird contacts – See Mozilla support. Find the information you need to import to or exporting from Outlook, whether you're using Office 365, Outlook 2016, or a Mac.