Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
Use AND and OR to test a combination of conditions
When you need to find data that meets more than one condition, such as units sold between April and January, or units sold by Nancy, you can use the AND and OR functions together. Here's …
Accessibility best practices with Excel spreadsheets
This topic gives you step-by-step instructions and best practices for making your Excel spreadsheets accessible and unlock your content to everyone, including people with disabilities. You learn, for example, how to work with the Accessibility Checker to tackle accessibility issues while you're creating your spreadsheet.
Improve accessibility with the Accessibility Checker
Before you send an Outlook email message or share a Word document, Excelspreadsheet, PowerPoint presentation, or OneNote notebook, run the Accessibility Checker to make your content easier for people to read and edit.
Using Checkboxes in Excel - Microsoft Support
Checkboxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. To insert Checkboxes: Select the range where you want checkboxes. Select Insert > Checkbox. To remove checkboxes: Select the range of cells with the checkboxes you want to remove.
How to correct a #N/A error in INDEX/MATCH functions
SOLUTION: To remove unexpected characters or hidden spaces, use the CLEAN or TRIM function, respectively. Also, verify if the cells are formatted as correct data types. When you use an array in INDEX, MATCH, or a combination of those two functions, it is necessary to press Ctrl+Shift+Enter on the keyboard.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
Create a drop-down list - Microsoft Support
You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
Customize the Quick Access Toolbar - Microsoft Support
For example, you can create custom tabs and custom groups to contain your frequently used commands. What do you want to do? Right-click in the ribbon and do either of the following: If the Quick Access Toolbar is shown, select Hide Quick Access Toolbar. If the Quick Access Toolbar is hidden, select Show Quick Access Toolbar.