Most Useful 55 Functions and Formulas | Excel Important Functions
Hi everyone in this video I will learning excel Most important and useful functions. And try to cover all necessary functions in a short time. Excel all Impotent Functions make you Excel Export
0:00 Difference between Function and Formulas
1:28 Sum with Formulas and Function
2:34 Use of Product function
3:25 Sum Product Function
4:30 Sum if Function
4:26 Sum ifs Function
8:50 Subtotal Function
10:12 Count Function
10:40 Count A Function
11:00 Count if Function
13:05 Count ifs Function
14:30 Count Blank Function
14:51 Min / Max Function
15:36 Max ifs Function
16:46 Average Function
17:15 Large Function
17:51 Small Function
18:58 Unique Function
21:19 Aggregate Function
24:42 Rand Function
26:04 Rand between Function
27:10 Len Function
27:38 Trim Function
28:46 Lookup Function
33:35 V lookup Function
35:43 V lookup Plus Match Function
37:48 H lookup Function
39:23 X Lookup Function
43:32 Picture Lookup
46:17 Match Function
47:17 Filter Function
50:10 Advance Filter
51:45 If Function
55:27 And Function
58:55 OR Function
59:15 Nested if Function
1:02:00 Today Function
1:02:54 Now function
1:03:17 E Dated Function
1:04:12 EO Month Function
1:05:17 Dated if Function
1:06:46 Upper Function
1:07:05 Lower Function
1:07:21 Proper Function
1:07:43 Roman Function
1:08:31 How to Separate First Name and Last Name by excel function
1:10:29 Concat Function in Excel
1:11:11 Concatenate Function in Excel
1:11:57 Offset Function in Excel
1:21:00 Rept Function in Excel
1:22:49 PMT Function in Excel
1:25:04 EMI Calculator
1:27:40 Text Join Function in Excel
1:29:28 Is Text or Is Number Function
1:31:05 Left and Right Function
1:32:10 Choose Function in Excel
1:32:58 Row and Rows Functions in Excel
1:35:09 Sequence Function

Practice File is attached File
[ Ссылка ]
#exceltech #excelfunctions #exceltutorial #functiontraining #excelinterview #excelinterviewquestionsandanswers #excelinhindi #excelinurdu

свернуть