excel

The COUNTIF function finds all of the values in a range that meet the criteria you specify and counts them. Syntax: COUNTIF( range, criteria ) Range – The range of values to test the criteria against. Criteria – The condition that must be met for a value to be included in the count. The criteria can be a

The AVERAGEIF function finds all of the values in a range that meet the criteria you specify and either averages them or averages the values in a corresponding range. Syntax: AVERAGEIF( range, criteria, [range to average] ) Range – The range of values to test the criteria against. Also, the range of values to average if no “range to

The SUMIF  function finds all of the values in a range that meet the criteria you specify and either adds them or adds values in a corresponding range.

The IFS function works just like a nested IF.  You can use it to examine multiple conditions. The difference between the IFS function and a nested IF is, the IFS function is simpler because you do not need to nest one IF function inside another IF function.

As you approach a stop light, it might be green, yellow, or red. You decide what to do based on the color. If it is green, you go. If it is yellow, you proceed with caution. If it is red, you stop. Using the IF function, you can have your spreadsheet make similar decisions. The

In life, we are constantly making decisions and circumstances frequently determine the decision we make. As a simple example, if it is cold outside, I wear a coat. If it is hot outside, I do not. Your Excel spreadsheet can also make decisions based on the circumstance. In Excel parlance, a circumstance is a condition

In Excel, when entering text in English, by default, text reads from left to right and is horizontal. You can change the text direction by clicking the Orientation button and then choosing a direction option from the Orientation menu. Change the Text Direction Select the text. Choose the Home tab. Click the down-arrow next to

A border is a line placed to the left, right, top, or bottom of a cell, group of cells, or table.   You can select the style and color of borders. There are three ways to add a border: selecting a border option from the Borders section of the Borders Menu, drawing a border, or using

You can change your font color. To learn more about colors, click here. If you place a background color behind your data, make sure your font color is a color that can be easily seen. For example, if you have a black background, you might want to use white or another light font color. Excel has designated the first four columns

In Excel, use the Fill button on the Home tab to add a background color (fill) to cells. To learn more about colors, click here. When you place a fill in a cell that has data in it, make sure the font is a contrasting color so that your data can be easily seen. If you are using Automatic—the default font