Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

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.

Windows share window: Select the Outlook icon in the “Share using” section of the Windows share window to email your files using Outlook directly within the windows share window.It also has a search box. So, you can now search for contacts across Outlook to share a file. The Windows share window also displays 8-10 suggested contacts to quickly share to–including emailing yourself a file.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Use a macro to extract data from a corrupted workbook If a chart is linked to the corrupted workbook, try using a macro to extract the source data of the chart.. Copy the following macro code and paste it in a module sheet: Sub GetChartValues() Dim NumberOfRows As Integer

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.

A template is a pre-designed layout that you can apply to a new page to provide a level of consistency and save time. OneNote comes with several built-in templates, including decorative page backgrounds and to-do lists.

Tip: To quickly share with specific people, you can type in their name or email and then use the pencil icon to the right of the Name, group or email field to select Can edit or Can view.Then follow the same steps below to share with the specific people you listed. For Word documents, you can use the Can review option to let someone add comments and suggestions but prevent them from making edits.

In Outlook, you have the option to: Snooze or dismiss events or tasks | Turn the notifications on or off | Add reminders to events | Add reminders to tasks | Troubleshoot notifications. Snooze or dismiss an event or task. With the reminders window, you can select to snooze calendar events and tasks, join a Teams meeting, or dismiss events and tasks.

Disable all macros except digitally signed macros Macros are disabled, and security alerts appear if there are unsigned macros present.However, if the macro is digitally signed by a trusted publisher, the macro just runs. If the macro is signed by a publisher you haven't trusted yet, you are given the opportunity to enable the signed macro and trust the publisher.