ads

15 Basic Excel Formulas for Beginner (Video inside)

15 Basic Excel Formulas for Beginner should know (Video inside in khmer language)

This is the basic Microsoft Excel formulas for whose want to start excel as beginner level. Free download excel example link below.

Knowing Excel formulas would help to speed up your work with lot of data and sure it is correct. The 15 Basic Excel formulas in the video are:

SUM formula
SUM is used to calculate total value of rows or columns.
Fomula:
SUM(number1,[number2],...)
-number1 is required value or cell and the rest of the number is optonal. Sum suport add value upto 255 value.

MIN formula
Min is used to find the smallest (Minimum) number from set of values. Check the video for more practical use of the formula. Fomula:
MIN(number1,[number2],...)
-number1 is required value or cell and the rest of the number is optonal. MIN suport value upto 255 value.

MAX formula
MAX is used to find the Biggest (Maximum value) number from set of values.Check the video for more practical use of the formula. Fomula:
MAX(number1,[number2],...)
-number1 is required value or cell and the rest of the number is optonal. MAX suport value upto 255 value.

AVERAGE formula
AVERAGE is used to find the average value from set of values. Check the video for more practical use of the formula. Fomula:
AVERAGE(number1,[number2],...)
-number1 is required value or cell and the rest of the number is optonal. AVERAGE suport value upto 255 value.


IF formula
IF is used to find the value base on the condition of true or false. Check the video for more practical use of the formula. Fomula:
IF(condition, value_if_true, value_if_False)

RANK formula
RANK is used to look for the rank of a numeric value when compared to a list of other numeric values. Check the video for more practical use of the formula.
Fomula:
RANK (number, ref, [order])

COUNT formula
COUNT is returns the count of values that are numbers (count number only). Check the video for more practical use of the formula. Fomula:
COUNT (COUNT (value1, [value2], ...))
DOWNLOAD EXAMPLE EXCEL FILE Example File Here
For More Excel formulas please refer to the video above.

Learn More Photoshop CC / Illustrator / Computer Tips and Tricks
- Adobe Photoshop CC Videos in Khmer:▶  Learn Photoshop Now
- Adobe Illustrator CC Videos in Khmer:▶  Learn Illustrator Now
- Computer Tips Videos in Khmer:▶  Computer Tips and Tricks

No comments:

Powered by Blogger.