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.

Change the keyboard layout or other method you use to type. Whenever you add a language, a keyboard layout or input method is added so you can enter text in the language. If you want to use a different keyboard layout or input method, you can add a new one or switch between the ones you have.

To get started, select the Start button, and then select Calculator in the list of apps. Select the Open Navigation button to switch modes. Use Standard mode for basic math, Scientific for advanced calculations, Programmer for binary code, Date calculation for working with dates, and options under Converter for converting units of measurement ...

Follow these steps to automatically diagnose and repair Windows security problems by turning on UAC, DEP protection, Windows Firewall, and other Windows security options and features. Select the Download button on this page. In the File Download dialog box, click Run or Open, and then follow the steps in the Windows Security Troubleshooter.

Follow the steps for your installation type. Click-to-run. In the window How would you like to repair your Office Programs, select Online Repair > Repair to make sure everything gets fixed. (The faster Quick Repair option is also available, but it only detects and then replaces corrupted files.) MSI-based.

Change profiles in Outlook. In Outlook, click File > Account Settings > Change Profile. Outlook will close. Start Outlook again manually. The next time Outlook starts, it displays the Choose Profile dialog: To show this dialog every time Outlook starts, in the dialog, select Options > Prompt for a Profile to be used .

Microsoft support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows, Surface, and more

Create a PivotTable to analyze external data. Create a PivotTable to analyze data in multiple tables. Sort data in a PivotTable. Group or ungroup data in a PivotTable. In Excel, use slicers and other ways to filter large amounts of PivotTable data to show a smaller portion of that data for in-depth analysis.

This article shows you how to automatically apply shading to every other row or column in a worksheet. Newer versions Web. There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or, you can apply a predefined Excel table style to your data.

Get in touch with Microsoft Support for assistance with Microsoft products and services.