Learn These 50+ Excel Formulas Before Your Next Job Interview!

This video shows you how to use 50+ Important Excel Formulas in MS Excel 2016. ms excel formulas with examples.

00:08 - Exact formula with example (Validate two text stings)

02:05 - Mround formula with example (Hour, Minute, Second round)

06:14 - If & Iserror formula with example (Growth / Decline Calculation)

09:12 - Ifna & Vlookup formula with example (Fetch value from two tables)

12:38 - Edate formula with example (Add month to start date)

13:38 - Mod formula with example (Total hours & per hour sale calculation)

19:19 - Workday formula with example (Workday calculation excluding Weekend & Holiday only)

20:51 - Workday formula with example (Workday calculation excluding Weekend only)

23:44 - Networkdays formula with example (Networkdays without Weekend and Excluding / Including Holiday Calculation)

25:29 - Days formula with example (Number of days Calculation)

26:28 - Mod, Hour, Minute, Second, Sum formula with example (Working time & Total salary Calculation for payroll report)

36:58 - Iferror formula with example (Profit / Loss Calculation)

39:03 - Quotient, Mod formula with example (Weeks & Reminder Days Calculation)

40:36 - Concatenate formula with example (Combine two text stings)

41:44 - If formula with example (Nested If mapping)

44:12 - If formula with example (Alternate sales fetching mapping)

45:35 - Large, Small formula with example

47:07 - Eomonth formula with example

48:35 - If, And formula with example (Nested If & And mapping)

52:02 - If, Or formula with example (Nested If & Or mapping)

00:56:00 - Max, If formula with example (MaxIf format for maximum value finding)

00:59:57 - Min, If formula with example (MinIf format for minimum value finding)

01:02:35 - Sumproduct formula with example (RankIf format for multi products rank finding)

01:06:31 - Formulatext formula with example (Showing formula)

01:07:21 - Correl formula with example (Correlation calculation)

01:09:01 - Sumifs formula with example (Sum calculation based on multiple criteria)

01:11:48 - Countifs formula with example (Count calculation based on multiple criteria)

01:14:12 - Avergeifs formula with example (Average calculation based on multiple criteria)

01:17:01 - Db, Ddb formula with example (Asset depreciate calculation)

01:19:17 - Fv formula with example (Future value calculation)

01:21:04 - Irr formula with example (Internal rate of return calculation)

01:21:51 - Xirr formula with example (Internal rate of return for schedule cashflow calculation)

01:22:48 - Mirr formula with example (Modified Internal rate of return calculation)

01:24:12 - Npv formula with example (Net present value calculation)

01:26:06 - Xnpv formula with example (Net present value for schedule cashflow calculation)

01:27:54 - Nested If formula with example (Payback period calculation)

01:31:53 - Nested If formula with example (Payback period with Discount calculation)

01:37:17 - Pv formula with example (Present value calculation)

01:38:58 - Vlookup formula with example (Approximate vertical mapping)

01:40:41 - Index, Match formula with example (Reverse mapping)

01:43:29 - Hlookup formula with example (Exact horizontal mapping)

01:45:20 - Vlookup formula with example (Exact vertical mapping)

01:47:17 - Break-Even Analysis creation (Break-Even Point calculation)

Thank you for watching this video !!

[_______________idha]

Column delet cheyyan eeth key anu use cheyyendth

[dsrajpoot]

Please With simple effective av HINDI FOR MOB EXCEL USERS FROM INITIAL TO ADVABCED PLEASE MAIL ME