Excel functions (by category) 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.

This allows Excel to return an array of all names. Tips: If you format the range of names as an Excel table, then the formula will automatically update when you add or remove names. If you want to sort the list of names, you can add the SORT function: =SORT (UNIQUE (B2:B12&" "&A2:A12)) Example 4. This example compares two columns and returns ...

Right click the network icon in the right side of the taskbar and select Diagnose network problems or open Get Help for Network & Internet. Make sure Wi‑Fi is turned on. Select the No internet icon on the right side of the taskbar, and make sure Wi-Fi is turned on. If it isn't, select it to turn it on. Also, make sure Airplane mode is turned off.

Windows 10. Optimizing your drives can help your PC run smoother and boot up faster. To optimize them: Select the search bar on the taskbar and enter defrag. Select Defragment and Optimize Drives. Select the disk drive you want to optimize. Select the Optimize button.

A macro is a series of commands and instructions that you group together as a single command to accomplish a task automatically. Windows Web. To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.

In Teams, go to Calendar , select a meeting, and then Meeting options . Tip: Meeting options will open in a new window on your default browser. For the best experience, use Edge to open all meeting options. In a meeting invitation, select Meeting options.

Syntax. =TEXTSPLIT (text,col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with]) The TEXTSPLIT function syntax has the following arguments: text The text you want to split. Required. col_delimiter The text that marks the point where to spill the text across columns. row_delimiter The text that marks the point where to spill ...

To check it out in Windows 11, select it on the taskbar or the Start menu, or press the Windows logo key + E on your keyboard. How to use File Explorer: To pin a folder to Quick access, right-click (or press and hold) the folder and select Pin to Quick access. To share a file, select it, then select Share on the ribbon.

This affects, for example, title bars, menus, and icon texts. To go to the Accessibility settings on your computer, press the Windows logo key+U or select Start > Settings > Accessibility. Select Text size. Drag the Text size slider to the right to increase the size of the sample text. Once you're happy with the text size, select Apply.

Manage account. Change the email address or phone number for your Microsoft account. Add or remove an Xbox profile. Delete your Microsoft account security info. Check your Microsoft account balance. Earn points with Microsoft Rewards. Update your Microsoft account if you’re moving to a new country or region. How to delete a child account.