Statistical functions in Excel
=AVERAGE() =AVERAGEIF() =AVERAGEIFS() =AVERAGEA() =COUNT() =COUNTA() =COUNTBLANK() =COUNTIF() =COUNTIFS() =MAX() =MIN() =DCO…
=AVERAGE() =AVERAGEIF() =AVERAGEIFS() =AVERAGEA() =COUNT() =COUNTA() =COUNTBLANK() =COUNTIF() =COUNTIFS() =MAX() =MIN() =DCO…
=AND() =NOT() =OR() =IF() =IFS() =IFERROR() =AND() This function combine multiple conditions if all conditions are true then…
=LEN() =CONCATENATE() =CONCAT() =EXACT() =UPPER() =LOWER() =PROPER() =LEFT() =RIGHT() =MID() =CHAR() =FIND() =REPLACE() =TRI…
Loan, Interest, EMI etc. Calculation General Names …
=ABS() =FACT() =EVEN() =ODD() =INT() =ROUND() =LOG() =LOG10() =SUM() =SUMIF() =SUMIFS() =SUMPRODUCT() =PI() =POWER() =PRODUC…
=TODAY() =NOW() =DATE() =DAY() =MONTH() =YEAR() =DAYS360() =HOUR() =MUNIT() =SECOND() =EOMONTH() =WORKDAY() =WORKDAY.INTL() …
Trick No. 1 The following data want to be transpose and make it horizontally. First Transpose the Name, product and sales li…