Скачать с ютуб 50+ excel formula for job interview | ms excel formulas with examples в хорошем качестве

50+ excel formula for job interview | ms excel formulas with examples

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) Thank you for watching this video !!