4 – If and If or Formula (Watch Free)

Lesson List

Excel Introduction

1 – Excel Introduction (Watch Free)13:55

Excel for Beginners 2 to 20 Tutorials?

Excel Beginners

2 – Basic Formula in Excel (Watch Free)00:20:13

3 – If Formula in Excel (Watch Free)00:18:12

4 – If and If or Formula (Watch Free)9:02

5 – Nested IF Formula in Excel10:30

6 – Nested if Calculate Discount00:14:51

7 – Salary Sheet Basic Formula00:13:08

8 – Salary Sheet Nested if00:15:32

9 – Attendance Sheet00:14:02

10 – Attendacne Sheet Countif Formula00:12:06

11 – Sort, Custom Sort & Filter00:17:41

12 – Conditional Formatting Basic00:13:23

13- Conditional Formatting Advance00:10:16

14- C F Higlight Alt Rows00:8:38

15 – Advance Filter00:12:26

16 – Advance filter Macro00:13:59

17 – Auto Sort Macro00:7:39

18 – Text to Columns00:4:59

19 – Flash Fill in Excel00:13:30

20 – Remove Duplicate and Consolidate00:8:39

Demo Questions & Answers Excel Basic Test

Basic Excel Test

Excel for Intermediate 21 To 60 Tutorials?

Excel for Intermediate

21 – 3D Formula00:7:15

22 – Data Validation00:28:16

23 – Scenario Manager00:6:21

24- Goal Seek00:8:51

25 – Data Table00:5:31

26 – Home Tab 112:24

27 – Home Tab 200:11:10

28 – Home Tab 300:6:32

29 – Home Tab 400:9:53

30 – Find and Replace00:12:40

31 – Goto Special00:20:14

32 – Paste Special00:17:32

33 – Pivot Table Introduction00:13:28

34 – Pivot Table Filter Use00:8:23

35 – Pivot Table Options00:11:42

36 – Slicer and Timeline00:15:10

37 – Pivot Chart in Excel00:10:56

38 – Auto Refresh Pivot Table00:6:21

39 – Table in Excel00:10:56

40 – Insert Tab – 100:8:48

41 – Insert Tab200:8:05

42 – Excel Chart00:12:21

43 – Excel Chart and Formatting00:8:16

44 – Excel Sparkline Chart00:5:30

45 – Hyperlink in Excel00:4:32

46 – Insert Tab 300:11:58

47 – Watermark in Excel00:5:40

48 – Pagelayout Tab Themes and Margins00:11:13

49 – Pagelayout Tab Print Settings00:11:14

50 – Pagelayout Tab 200:7:03

51 – Pagelayout Tab300:11:38

52 – Formula Tab Name Manager00:11:24

53 – Formula Tab Formula Auditing00:9:01

54 – Data Tab Get External Data00:8:08

55 – Data Tab SubTotal00:7:22

56 – Data Tab Solver add ins00:6:28

57 – Reveiw Tab00:9:38

58 – View Tab00:10:34

59 – Macro Recording00:12:12

60 – Create your own Tab00:5:57

Demo Question & Answer Intermediate Final Test

Excel for Intermediate Exam Test

Advance Excel 61 To 150 Tutorials?

Advance Excel

61 – Vlookup 1 Intro00:16:38

62 – Vlookup 2 Use of Range Lookup00:13:02

63 – Vlookup 3 Double Vlookup00:8:28

64 – Vlookup 4 Nested Vlookup00:7:46

65 – Vlookup 5 Vlookup Project00:9:24

66 – Vlookup 6- Unique Example of Vlookup00:5:39

67 – CountA and Count Blank Formula00:7:10

68 – Countif Formula00:5:59

69 – Countifs Formula00:11:33

70 – Sumif and Sumifs00:7:22

71 – Averageif and Averageifs00:6:57

72 – Frequency Formula00:7:25

73 – Index and Match00:7:10

74 – Lookup Formula00:5:06

75 – SumProduct , Left and Find formula00:7:13

76 – Right and Find00:5:01

77 – Mid and Find Formula00:9:57

78 – Repeat and Substitute Formula00:4:25

79 – PMT, PV, FV Formula00:10:51

80 – IPMT AND PPMT00:8:34

81- V lookup with Match00:10:20

82 – Text Formulas00:6:46

83 – Date in Quarter00:6:19

84 – Datedif Formula00:6:43

85 – Date Formula00:5:13

86 – Switch Date00:6:31

87 – More Date Formulas00:7:23

88 – Ranking Formula00:5:19

89 – Concatenate and Vlookup00:4:05

90 – Sheet Tips00:6:32

91 – Excel To Powerpoint00:6:14

92 – Change Excel Icon00:6:25

93 – Number to Word00:6:14

94 – Custom Cells Tips00:8:00

95 – Picture Lookup 00:11:27

96 – Picture Game00:8:22

97 – Data Entry form00:4:22

98 – File Menu00:6:06

99 – Excel Settings00:11:00

100 – Short formulas00:11:07

101 – Excel – Database function DGET Formula of Excel00:10:36

102 – Excel – DSUM Formula in Excel00:7:24

103 – Excel – DAVERAGE Formula00:2:41

104 – Excel – DCOUNT, DCOUNTA Formula00:4:11

105 – Excel -DMAX Formula, DMIN Formula, DPRODUCT Formula00:6:10

106 – Excel – Vlookup on Multiple Tables00:6:54

107 – Excel – Offset Formula Introduction00:11:01

108 – Excel – Offset Formula Calculate Sum of Last 6 Days00:9:37

109 – Excel – Offset Formula Real Job Use00:5:21

110 – Excel – Sumifs, Index, Match Real Job Use00:8:24

111 – Excel – Practical use of Isblank and Istext Formula00:4:35

112 – Excel – Counting Words in Excel Interview Question00:8:54

113 – Excel – Build Login in Excel Formula00:5:55

114 – Excel – Create Dynamic List Using Index, Match Formula00:4:07

115 – Excel – Conditional Formatting with Text and Or Formula00:4:33

116 – Excel – Unique Example of Conditional Formatting00:5:53

117 – Excel – Auto Sort data using Countif, Match and Index Formula00:9:02

118 – Excel – Condition Inside Rank using CountIFS Formula00:5:40

119 – Excel – Camera, Autofilter, Form – 3 Hidden Features00:6:55

120 – Excel – Max IF and Min IF Formula using Array00:5:39

121 – Excel – Choose Formula in Excel00:7:14

122 – Excel – Swap range in Excel00:4:18

123 -Excel- Reverse Lookup Using Choose Formula00:5:37

124 – Excel – Reverse Lookup using Match and Index00:6:40

125 – Excel – Find & Vlookup Real Job Query00:9:41

126 – Excel – Vlookup Duplicate Names Issue00:4:09

127 – Excel – Vlookup with Chooze formula and array00:9:09

128 – Excel – Text Join Formula in Excel 201900:5:02

129 – Excel – IFS Formula in Excel 201900:4:47

130 – Excel – MaxIFS and MinIFS in Excel 201900:4:36

131 – Excel – Filter Formula of Office 36500:5:20

132 – Excel – Sort Formula of Office 36500:6:56

133 – Excel – Real Job use of Aggregate Formula in Excel00:10:34

134 – Excel – Xlookup In Office 36500:6:37

135 – Excel – Xlookup In Office 36500:6:42

136 – Excel – Xlooup Work Reverse00:9:47

137 – Excel – Xlooup In Office 36500:5:40

138 – Excel – Xlooup In Office 36500:9:56

139 – Excel – Xlookup in Office 36500:8:38

140 – Excel – Xlookup in Office 36500:6:22

141 – Excel – Xlookup in Office 36500:5:06

142 – Excel – Xlookup in Office 36500:5:36

143 – Excel – Xlookup in Office 36500:5:20

144 – EXCEL – XMATCH Formula office 36500:13:07

145 – Excel – Create Searchable Drop Down List In Office 36500:9:45

146 – Excel – Analyze Data And Get Ideas Office 36500:6:31

147 – Excel – Map Chart In Office 36500:8:04

148 – Excel – Dynamic Conditional Formatting00:9:53

149 – Excel – Unique Formula In Office 36500:5:15

150 – Excel – Sequence And Random Array Formula In Office 36500:4:34

Assignment Video with Answer 151 To 154 Tutorials

151 – EXCEL – Assignment 1 With Answer 36500:13:17

152 – EXCEL – Assignment 2 With Answer 36500:06:40

153 – EXCEL – Assignment 3 With Answer 36500:04:37

154 – EXCEL – Assignment 4 With Answer 36500:03:14

Excel Interview Questions

155 – Excel Interview Questions-100:41:51

156 – Excel Interview Questions-200:26:12

157 – Use your Brain – Interview Question00:35:50

158 – Interview Question – Mode Function00:11:54

159 – Interview Question – Goto and Conditional Formatting00:08:02

Trial Paper and Final Exam for Certificate

How will You get Certificate?00:04:13

Demo Question & Answer Advance Excel

Advance Excel Final Test

Go to Course Home

4 – If and If or Formula (Watch Free)

Attachments

2 To 5 Sheets.xlsx 10.13 KB

← Previous Next →

Learn More

Excel Introduction

1 – Excel Introduction (Watch Free)13:55

Excel for Beginners 2 to 20 Tutorials?

2 – Basic Formula in Excel (Watch Free)00:20:13

3 – If Formula in Excel (Watch Free)00:18:12

4 – If and If or Formula (Watch Free)9:02

5 – Nested IF Formula in Excel10:30

6 – Nested if Calculate Discount00:14:51

7 – Salary Sheet Basic Formula00:13:08

8 – Salary Sheet Nested if00:15:32

9 – Attendance Sheet00:14:02

10 – Attendacne Sheet Countif Formula00:12:06

11 – Sort, Custom Sort & Filter00:17:41

12 – Conditional Formatting Basic00:13:23

13- Conditional Formatting Advance00:10:16

14- C F Higlight Alt Rows00:8:38

15 – Advance Filter00:12:26

16 – Advance filter Macro00:13:59

17 – Auto Sort Macro00:7:39

18 – Text to Columns00:4:59

19 – Flash Fill in Excel00:13:30

20 – Remove Duplicate and Consolidate00:8:39

Demo Questions & Answers Excel Basic Test

Basic Excel Test

Excel for Intermediate 21 To 60 Tutorials?

21 – 3D Formula00:7:15

22 – Data Validation00:28:16

23 – Scenario Manager00:6:21

24- Goal Seek00:8:51

25 – Data Table00:5:31

26 – Home Tab 112:24

27 – Home Tab 200:11:10

28 – Home Tab 300:6:32

29 – Home Tab 400:9:53

30 – Find and Replace00:12:40

31 – Goto Special00:20:14

32 – Paste Special00:17:32

33 – Pivot Table Introduction00:13:28

34 – Pivot Table Filter Use00:8:23

35 – Pivot Table Options00:11:42

36 – Slicer and Timeline00:15:10

37 – Pivot Chart in Excel00:10:56

38 – Auto Refresh Pivot Table00:6:21

39 – Table in Excel00:10:56

40 – Insert Tab – 100:8:48

41 – Insert Tab200:8:05

42 – Excel Chart00:12:21

43 – Excel Chart and Formatting00:8:16

44 – Excel Sparkline Chart00:5:30

45 – Hyperlink in Excel00:4:32

46 – Insert Tab 300:11:58

47 – Watermark in Excel00:5:40

48 – Pagelayout Tab Themes and Margins00:11:13

49 – Pagelayout Tab Print Settings00:11:14

50 – Pagelayout Tab 200:7:03

51 – Pagelayout Tab300:11:38

52 – Formula Tab Name Manager00:11:24

53 – Formula Tab Formula Auditing00:9:01

54 – Data Tab Get External Data00:8:08

55 – Data Tab SubTotal00:7:22

56 – Data Tab Solver add ins00:6:28

57 – Reveiw Tab00:9:38

58 – View Tab00:10:34

59 – Macro Recording00:12:12

60 – Create your own Tab00:5:57

Demo Question & Answer Intermediate Final Test

Excel for Intermediate Exam Test

Advance Excel 61 To 150 Tutorials?

61 – Vlookup 1 Intro00:16:38

62 – Vlookup 2 Use of Range Lookup00:13:02

63 – Vlookup 3 Double Vlookup00:8:28

64 – Vlookup 4 Nested Vlookup00:7:46

65 – Vlookup 5 Vlookup Project00:9:24

66 – Vlookup 6- Unique Example of Vlookup00:5:39

67 – CountA and Count Blank Formula00:7:10

68 – Countif Formula00:5:59

69 – Countifs Formula00:11:33

70 – Sumif and Sumifs00:7:22

71 – Averageif and Averageifs00:6:57