This video shows you how to use 50+ Important Excel Formulas in MS Excel 2016.
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)
15:45 - Workday.intl formula with example (Workday calculation excluding Sunday only)
17:47 - Workday.intl formula with example (Workday calculation excluding Sunday & Holiday only)
19:19 - Workday formula with example (Workday calculation excluding Weekend & Holiday only)
20:51 - Workday formula with example (Workday calculation excluding Weekend only)
21:55 - Networkdays.intl formula with example (Networkdays without Sunday and Excluding / Including Holiday Calculation)
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)
Excel Tips & Tricks : /playlist/PLZnHzQfaP-kM1-Vfhd_h19jTKbYEuGgD-
Excel Analysis : /playlist/PLZnHzQfaP-kOY6XVgxq5KX94m9dvCp4I5
Excel Functions : /playlist/PLZnHzQfaP-kOV5sfQqKEHg4gD_88FPcfL
Excel DAX formulas : /playlist/PLZnHzQfaP-kPri8SUozzLqA6ZEF77-UVx
Excel for Job Interview : /playlist/PLZnHzQfaP-kNz4N7gdDwbw1-xelRiqNs8
Excel 365 Features : /playlist/PLZnHzQfaP-kP73WZ1j2r5eelCQv1nM8Fn
Excel 2019 Features : /playlist/PLZnHzQfaP-kNjDGlDUe7102SgVA2bNLHn
Mobile Excel Tutorial : /playlist/PLZnHzQfaP-kPmQqjUzquKKqk-iwCi7tap
Creative & Advanced charts : /playlist/PLZnHzQfaP-kOnddZhSPMWRbhv2pbL0CO2
Excel Automation : /playlist/PLZnHzQfaP-kP5pB7IrO6DSg8-bNLFNY7_
450 Excel functions with examples : /watch/Un7mtnh32Yh3m
Top 60 widely using most popular excel functions : /watch/0AV3vIivnJYv3
#excel
#learnexcel
#exceltutorial
#microsoftexcel
#microsoftexceltutorial
#msexcel
#excelhelp
#ExcelSpreadsheets
#SpreadsheetHelp
#Spreadsheet
#excelexperts
#ExcelSpecialists
#excelsupport
#excelformula
#excelfunctions
Thank you for watching this video !!