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. =IF (Something is True, then do something, otherwise do something else)
Use Goal Seek to find the result you want by adjusting an ...
On the Home tab, in the Number group, click Percentage. Click Increase Decimal or Decrease Decimal to set the number of decimal places. If you know the result you want from a formula but aren't sure which input is needed to get that result, use Excel's Goal Seek feature.
Add or change the background color of cells - Microsoft Support
Windows Web. You can highlight data in cells by using Fill Color to add or change the background color or pattern of cells. Here's how: Select the cells you want to highlight. Tips: To use a different background color for the whole worksheet, click the Select All button.
Change a theme and make it the default in Word or Excel
Document themes make it easy to coordinate colors, fonts, and graphic formatting effects across your Word, Excel, and PowerPoint documents and update them quickly. This video show you how-to change the entire theme, read below to just customize theme fonts, colors, or effects.
Apply or remove cell shading - Microsoft Support
Applies To. You can add shading to cells by filling them with solid colors or specific patterns. If you have trouble printing the cell shading that you applied in color, verify that print options are set correctly.
Format an Excel table - Microsoft Support
On the Home tab, click Format as Table. Click the table style that you want to use. Notes: Auto Preview - Excel will automatically format your data range or table with a preview of any style you select, but will only apply that style if you press Enter or click with the mouse to confirm it.
Filter by using advanced criteria - Microsoft Support
Click a cell in the list range. Using the example, click any cell in the range A6:C10. On the Data tab, in the Sort & Filter group, click Advanced. Do one of the following: To filter the list range by hiding rows that don't match your criteria, click Filter the list, in-place.
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Change the colors in a text box or shape - Microsoft Support
Change the colors in a text box or shape. Applies To. In a text box or shape, you can quickly change the color of text, the inside (fill) color, or the color of the border. Let's select the shape—the Drawing Tools appear in the ribbon, with the Format tab active.
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Format numbers as currency - Microsoft Support
If you want to display numbers as monetary values, you must format those numbers as currency. To do this, you apply either the Currency or Accounting number format to the cells that you want to format. The number formatting options are available on the Home tab, in the Number group.