ads

Excel Fomulas with Example Downad and Video in Khmer

This is the collection some of Microsoft Excel formulas and you can click on it for more information (some formula may not yet post - we will update every week). You will get related post that contain that formula. More update formula will coming soon.

Mathematic Fomulas in Excel - include video in khhmer and example download

ABS RAND RANDBETWEEN ROUND
ROUNDUP ROUNDDOWN INT SUMPRODUCT
SUBTOTAL

STATISTICAL Fomulas in Excel - include video in khhmer and example download

COUNT COUNTA COUNTIF COUNTIFS
SUM SUMIF SUMIFS MIN
MAX LARGE SMALL MINIFS
MAXIFS

Date and Time Functions in Excel - include video in khhmer and example download

NOW TODAY HOUR MINUTE
SECOND TIME DAY MONTH
YEAR DATE DATEDIF YEARFRAC

Lookup and Reference Functions in Excel - include video in khhmer and example download

VLOOKUP HLOOKUP INDEX MATCH
LOOKUP ROW COLUMN

IF Functions in Excel - include video in khhmer and example download

IF NESTED IF

Logic Functions in Excel - include video in khhmer and example download

AND OR NOT IFERROR

Information Functions in Excel - include video in khhmer and example download

ISBLANK ISERROR ISNUMBER

TEXT Functions in Excel - include video in khhmer and example download

LEFT RIGHT MID LEN
FIND SEARCH REPLACE SUBSTITUTE
TRIM CLEAN CONCAT TEXTJOIN
CONCATENATE UPPER LOWER PROPER

DATABASE Functions in Excel

DSUM DCOUNT DCOUNTA DAVERAGE
DMAX DMIN

No comments:

Powered by Blogger.