1st January 2022

Text Functions: LEN, TRIM, PROPER, UPPER, LOWER, CONCATENATE

Function Description ASC function Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters BAHTTEXT…

1st January 2022

Perform calculations by using MIN and MAX function

Select a cell below or to the right of the numbers for which you want to find the smallest number.…

1st January 2022

Perform calculations by using the AVERAGE function

Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns…

1st January 2022

Perform calculations by using the COUNT function

Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to…

1st January 2022

Perform calculations by using the SUM function

If you need to sum a column or row of numbers, let Excel do the math for you. Select a…

1st January 2022

Perform logical operations by using the AVERAGEIF function

AVERAGEIF(range, criteria, [average_range]) The AVERAGEIF function syntax has the following arguments: Range Required. One or more cells to average, including…

1st January 2022

Perform logical operations by using the IF function

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons…

1st January 2022

Perform logical operations by using the SUMIF function

SUMIF(range, criteria, [sum_range]) The SUMIF function syntax has the following arguments: range   Required. The range of cells that you want…

1st January 2022

Perform statistical operations by using the COUNTIF function

Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to…

1st January 2022

Auto completion of Series, Sort and filter, Charts

Auto completion of series Enter the first number in the top cell. Hover until you see the Fill Handle and…