HINDI

 

 Learn MS Excel 2016/2013/2010/2007 In Hindi

Gyanyagya

1 / 135

▶

9:45अभी चल रहा है

Basic Introduction of MS Excel 2016/2013/2010/2007 for Beginners in Hindi - Lesson 1

Gyanyagya

2

5:28अभी चल रहा है

How to solve online quiz on MS word, Excel & PowerPoint & download exercise & exercise file

Gyanyagya

3

7:16अभी चल रहा है

Creating New Workbook, Open File, Using Save, Save As In MS Excel In Hindi - Lesson 2

Gyanyagya

4

5:24अभी चल रहा है

How To Use Cut, Copy And Paste Options In MS Excel 2016/2013/2010/2007 In Hindi - Lesson 3

Gyanyagya

5

5:46अभी चल रहा है

How To Use Find, Replace, Find Next & Replace All In Excel 2016/2013/2010/2007 In Hindi – Lesson 4

Gyanyagya

6

4:42अभी चल रहा है

How To Change Font, Font Size, & How To Bold, Italic, Underline A Text In Excel In Hindi – Lesson 5

Gyanyagya

7

3:57अभी चल रहा है

How To Use Undo And Redo Options In MS Excel 2016/2013/2010/2007 In Hindi – Lesson 6

Gyanyagya

8

7:28अभी चल रहा है

How To Change Border Color, Font Color & Using Fill Color Options In MS Excel In Hindi – Lesson 7

Gyanyagya

9

4:48अभी चल रहा है

How To Use Text Alignment & Indent Options To Align & Indent Text In MS Excel In Hindi – Lesson 8

Gyanyagya

10

4:32अभी चल रहा है

How To Use Orientation Option Change Text Direction Of Text In Excel In Hindi – Lesson 9

Gyanyagya

11

7:13अभी चल रहा है

How To Use Format Painter In Excel 2016/2013/2010/2007 In Hindi – Lesson 10

Gyanyagya

12

7:47अभी चल रहा है

How To Use Wrap Text & Merge & Center Options In MS Excel In Hindi – Lesson 11

Gyanyagya

13

5:27अभी चल रहा है

How To Format Numbers, Dates & Time In Excel In Hindi - Lesson 12

Gyanyagya

14

10:12अभी चल रहा है

How To Do Conditional Formatting & How To Highlight Cells In MS Excel Workbook In Hindi - Lesson 13

Gyanyagya

15

6:37अभी चल रहा है

How To Use Format As Table & Cell Styles Option In Excel In Hindi - Lesson 14

Gyanyagya

16

8:11अभी चल रहा है

How To Insert & Delete Rows, Columns, Cells & Sheets In MS Excel In Hindi - Lesson 15

Gyanyagya

17

5:56अभी चल रहा है

How To Change Row Height And Column Width In MS Excel 2016/2013/2010/2007 In Hindi - Lesson 16

Gyanyagya

18

6:55अभी चल रहा है

How To Hide And Unhide A Row Or Column Using Hide And Unhide Option In Excel In Hindi - Lesson 17

Gyanyagya

19

5:27अभी चल रहा है

How To Rename And Copy Or Move A Worksheet Data In MS Excel 2016/2013/2010/2007 In Hindi - Lesson 18

Gyanyagya

20

10:09अभी चल रहा है

How To Fill Months, Days, Date & Numbers By Autofill Function In MS Excel In Hindi - Lesson 19

Gyanyagya

21

9:41अभी चल रहा है

How To Sort Numbers And Data Using Sort & Filter Option In MS Excel In Hindi - Lesson 20

Gyanyagya

22

5:45अभी चल रहा है

How to use Mini Toolbar and Shortcut Menu In MS Excel 2016/2013/2010/2007 In Hindi – Lesson 21

Gyanyagya

23

How To Use and customize Quick Access Toolbar in Excel 2016/2013/2010/2007 In Hindi - Lesson 22

Gyanyagya

24

Using Status Bar to find sum, average etc.& What is Page Break Preview In Excel In Hindi - Lesson 23

Gyanyagya

25

How to Remove Formatting, Comments & Hyperlink using Clear Function in MS Excel In Hindi - Lesson 24

Gyanyagya

26

How To Do Addition, Subtraction, Division, Multiply, autosum etc in MS Excel In Hindi – Lesson 25

Gyanyagya

27

How To Use Clipboard To Copy & Paste Several Items In Excel 2016/2013/2010/2007 In Hindi– Lesson 26

Gyanyagya

28

Using Paste Special To Copy Format, Formula, Values & its Shortcut Key In Excel In Hindi – Lesson 27

Gyanyagya

29

Copy Conditional Format, Column Width, Number Format By Paste Special In Excel In Hindi - Lesson 28

Gyanyagya

30

Using Paste Special To Transpose Data And To Add or Subtract Values In Excel In Hindi – Lesson 29

Gyanyagya

31

How To Use Data Validation Option For Whole Numbers & Error Alert In MS Excel In Hindi - Lesson 30

Gyanyagya

32

How To Create Data Validation For Decimal Numbers & Other Data Options In Excel In Hindi – Lesson 31

Gyanyagya

33

How To Create Drop Down Menu & Set Character Limit By Data Validation In Excel In Hindi - Lesson 32

Gyanyagya

34

How to Set Limit for Date & Time Using Data Validation Option in MS Excel in Hindi - Lesson 33

Gyanyagya

35

Preventing Duplicate Entries & Allow Text / Numbers Only In Excel 2016/13/10/07 In Hindi – Lesson 34

Gyanyagya

36

How To Add Data Of Multiple Sheets & Workbook By Consolidate Option In MS Excel In Hindi - Lesson 35

Gyanyagya

37

Learn To Insert & Delete Image From Background Of Data In MS Excel In Hindi - Lesson 36

Gyanyagya

38

How To Navigate Between Sheets Of A Workbook Using Go To Option In MS Excel In Hindi - Lesson 37

Gyanyagya

39

How to Use Print Option for Printing Worksheet & Setting Orientation/Margins in MS Excel – (Hindi)38

Gyanyagya

40

How To Print Title Or Heading On Every Page By Print Titles Option In MS Excel In Hindi - Lesson 39

Gyanyagya

41

How to use the LOOKUP Function in Excel 2016/2013/2010/2007 In Hindi - Lesson 40

Gyanyagya

42

How to Use Vlookup Formula to Find Particular Data in Same/Different Workbooks in Excel – (Hindi)41

Gyanyagya

43

How To Check Column & Row Number Of A Cell By Column & Row Formula In Excel In Hindi - Lesson 42

Gyanyagya

44

How to Check Number of Columns or Rows in A Table Using Columns & Rows Formula in Excel – (Hindi)43

Gyanyagya

45

How To Get Multiple Results By Using Vlookup Formula For Single Time In Excel In Hindi - Lesson 44

Gyanyagya

46

Use of Hlookup Formula to Find Data from Database in Same/Different Workbooks in Excel – (Hindi)45

Gyanyagya

47

How To Freeze & Unfreeze Multiple Rows And Columns In Excel 2016/13/10/07 In Hindi - Lesson 46

Gyanyagya

48

7:17अभी चल रहा है

Generate Random Numbers Using Rand And Randbetween Formula In Excel In Hindi - Lesson 47

Gyanyagya

49

6:07अभी चल रहा है

Learn To Calculate EMI Using PMT Formula In MS Excel 2016/2013/2010/2007 In Hindi - Lesson 48

Gyanyagya

50

5:10अभी चल रहा है

Use Of Goal Seek Formula To Know Estimated Down Payment Amount In MS Excel In Hindi - Lesson 49

Gyanyagya

51

15:36अभी चल रहा है

How To Insert Chart & Change Its Color, Style Etc. In Microsoft Excel In Hindi - Lesson 50

Gyanyagya

52

10:02अभी चल रहा है

How to calculate interest & principal amount of loan using IPMT & PPMT function in Excel – (Hindi)51

Gyanyagya

53

7:50अभी चल रहा है

How to use Averageif & Averageifs in MS Excel to calculate average based on different conditions 52

Gyanyagya

54

4:32अभी चल रहा है

How to create template in Excel with font style, font size, alignment etc. of your choice -(Hindi)53

Gyanyagya

55

10:03अभी चल रहा है

How to use COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formula in MS Excel ? (Hindi) 54

Gyanyagya

56

10:19अभी चल रहा है

How to remove different types of formula errors in MS Excel 2016/2013/2010/2007? (Hindi) 55

Gyanyagya

57

10:10अभी चल रहा है

How to use concatenate formula and "&" sign to combine data of 2 or more cells in Excel (Hindi) 56

Gyanyagya

58

8:16अभी चल रहा है

How to change case (upper, lower, proper) and concatenate text at same time in MS Excel?(Hindi) 57

Gyanyagya

59

9:52अभी चल रहा है

How to use FV formula to calculate future value of an investment in Excel 2016/13/10/07 (Hindi) 58

Gyanyagya

60

6:29अभी चल रहा है

How to protect a complete worksheet or a part of worksheet with password in MS Excel (Hindi) 59

Gyanyagya

61

3:18अभी चल रहा है

How to use clean formula in MS Excel for removing non-printable characters from data. (Hindi) 60

Gyanyagya

62

5:41अभी चल रहा है

How to calculate running total in MS Excel 2016/2013/2010/2007 using Sum Formula ? (Hindi) 61

Gyanyagya

63

8:56अभी चल रहा है

How to split full name to first and last name in microsoft excel? (Hindi) 62

Gyanyagya

64

9:20अभी चल रहा है

How to use Dsum in MS Excel to add numbers of particular column based on a condition. (Hindi) 63

Gyanyagya

65

8:13अभी चल रहा है

How to use Dget in Excel to search a record from a database according to a condition.(Hindi) 64

Gyanyagya

66

7:57अभी चल रहा है

How to use Daverage in MS Excel to find average of a data of a column based on condition. (Hindi) 65

Gyanyagya

67

4:16अभी चल रहा है

How to use sumproduct in Excel to find sum of the products of one or more cell ranges (Hindi) 66

Gyanyagya

68

13:09अभी चल रहा है

How to use ceiling/floor formula in Excel to find max/min round off number of value? (Hindi) 67

Gyanyagya

69

5:40अभी चल रहा है

How to use Forecast formula in MS Excel 2016/2013/2010/2007 to predict sales or expenses? (Hindi) 68

Gyanyagya

70

5:59अभी चल रहा है

How to find & remove duplicate data/entries by using Remove Duplicates option in MS Excel (Hindi) 69

Gyanyagya

71

4:24अभी चल रहा है

How to use Edate formula to find the name of the day of any future or past date in Excel. (Hindi) 70

Gyanyagya

72

3:51अभी चल रहा है

How to calculate lowest common multiple using LCM formula in MS Excel. (Hindi) 71

Gyanyagya

73

10:01अभी चल रहा है

How to calculate GCD and find ratio of numbers using GCD in MS Excel? (Hindi) 72

Gyanyagya

74

8:37अभी चल रहा है

How to calculate overtime hours in MS Excel ? MS Excel me overtime kaise calculate kare? (Hindi) 73

Gyanyagya

75

9:52अभी चल रहा है

Calculate age using datedif formula in Excel? kisi vyakti ki age kaise calculate kare? (Hindi) 74

Gyanyagya

76

11:35अभी चल रहा है

How to calculate Simple Interest in MS Excel ? Excel me sadharan byaj kaise nikala jaye? (Hindi) 75

Gyanyagya

77

18:12अभी चल रहा है

How to make compound interest calculation chart in MS Excel 2016/2013/2010/2007? (Hindi) 76

Gyanyagya

78

6:38अभी चल रहा है

How to use power formula in Excel? Excel me kisi number ka power kaise calculate kare?(Hindi) 77

Gyanyagya

79

16:40अभी चल रहा है

How to calculate Compound Interest using a formula in MS Excel 2016/2013/2010/2007? (Hindi) 78

Gyanyagya

80

8:39अभी चल रहा है

How to count numerical values of a column based on a condition using Dcount in MS Excel. (Hindi) 79

Gyanyagya

81

9:29अभी चल रहा है

How to use Spelling & Thesaurus option in MS Excel to check spellings & find synonyms? (Hindi) 80

Gyanyagya

82

5:29अभी चल रहा है

How to do addition of a column/row based on certain condition using Sumif formula in Excel(Hindi) 81

Gyanyagya

83

13:23अभी चल रहा है

How to use TRIM function to remove extra space & SUBSTITUTE to replace characters in Excel ? 82

Gyanyagya

84

10:00अभी चल रहा है

How to use replace formula to replace a part of a text in MS Excel? (Hindi) 83

Gyanyagya

85

9:21अभी चल रहा है

How to use Dcounta to count filled cells of a column according to a condition in Excel? (Hindi) 84

Gyanyagya

86

8:01अभी चल रहा है

How to use Sumifs to add values of column/row based on multiple conditions in Excel? (Hindi) 85

Gyanyagya

87

9:16अभी चल रहा है

How to use Frequency in Excel to check that how many times a record repeats in a table? (Hindi) 86

Gyanyagya

88

15:08अभी चल रहा है

How to use Rank Formula in MS Excel ? Rank formula ka upayog kaise karen ? (Hindi) 87

Gyanyagya

89

9:54अभी चल रहा है

How to use large function in Excel to find top largest values from list & their addition? (Hindi) 88

Gyanyagya

90

5:50अभी चल रहा है

How to use small function to find some smallest values from the list in Excel? (Hindi) 89

Gyanyagya

91

9:00अभी चल रहा है

How to use Dmax & Dmin to find largest or smallest number based on a condition in Excel? (Hindi) 90

Gyanyagya

92

13:03अभी चल रहा है

How to use round, roundup & rounddown formula to remove decimal from digits in MS Excel? (Hindi) 91

Gyanyagya

93

13:34अभी चल रहा है

Using iferror function in Excel to hide errors that occur due to formula/wrong values? (Hindi) 92

Gyanyagya

94

17:22अभी चल रहा है

How to use Vlookup function with iferror formula in MS Excel 2016/2013/2010/2007? (Hindi) 93

Gyanyagya

95

14:30अभी चल रहा है

How to use vlookup with match function to perform two-dimensional Vlookup in MS Excel? (Hindi) 94

Gyanyagya

96

11:35अभी चल रहा है

How to use index+match function in Excel? Excel me index match formula ka upyog karna? (Hindi) 95

Gyanyagya

97

14:23अभी चल रहा है

How to use choose formula with Vlookup to search a value from multiple tables in Excel? (Hindi) 96

Gyanyagya

98

8:23अभी चल रहा है

How to use array function in MS Excel to perform multiple calculations in one time? (Hindi) 97

Gyanyagya

99

8:42अभी चल रहा है

How to convert rows into columns & columns into rows using an array function in Excel ? (Hindi) 98

Gyanyagya

100

6:40अभी चल रहा है

How to use max formula as an array function in MS Excel? (Hindi) 99

Gyanyagya

101

8:48अभी चल रहा है

How to convert Vlookup in array function to search multiple data simultaeously in Excel ?(Hindi) 100

Gyanyagya

102

11:48अभी चल रहा है

How to use DB formula to calculate depreciation in Excel? depreciation calculate karna? (Hindi) 101

Gyanyagya

103

18:59अभी चल रहा है

How to use scenario manager to compare multiple scenarios of data sets in Excel?(Hindi) 102

Gyanyagya

104

14:38अभी चल रहा है

How to use nested if formula for checking multiple conditions in MS Excel ? (Hindi) 103

Gyanyagya

105

12:13अभी चल रहा है

Split full name into first, middle & last name using text to column wizard in Excel? (Hindi) 104

Gyanyagya

106

19:55अभी चल रहा है

How to use Fuzzy Lookup in Microsoft Excel? Excel me Fuzzy Lookup ka upyog kaise kare? (Hindi) 105

Gyanyagya

107

9:30अभी चल रहा है

How to use iseven & isodd formula to check whether a number is even or odd in Excel? (Hindi) 106

Gyanyagya

108

12:33अभी चल रहा है

How to organize data using recommended pivot table in microsoft Excel 2016? (Hindi) 107

Gyanyagya

109

29:19अभी चल रहा है

How to create & customize a pivot table in MS Excel? Excel me pivot table kaise banayen? (Hindi) 108

Gyanyagya

110

26:24अभी चल रहा है

How to insert and customize a pivot chart in MS Excel? Excel me pivot chart insert karna.(Hindi) 109

Gyanyagya

111

5:46अभी चल रहा है

How to create a pivot chart using a pivot table in Microsoft Excel 2016/2013/2010/2007 (Hindi) 110

Gyanyagya

112

8:56अभी चल रहा है

How to use isblank formula with if function in MS Excel? (Hindi) 111

Gyanyagya

113

12:12अभी चल रहा है

How to calculate square root & cube root in Microsoft Excel 2016/2013/2010/2007 ? (Hindi) 112

Gyanyagya

114

5:46अभी चल रहा है

How to reverse a list in Microsoft Excel? Excel me kisi list ka order reverse karna. (Hindi) 113

Gyanyagya

115

16:52अभी चल रहा है

How to use istext & isnontext formulas in Excel to check if cell contains text or not ? (Hindi) 114

Gyanyagya

116

7:29अभी चल रहा है

How to merge data of different cells into one cell separated by comma in MS Excel? (Hindi) 115

Gyanyagya

117

10:04अभी चल रहा है

How to view multiple excel workbooks/worksheets & other windows at the same time? (Hindi) 116

Gyanyagya

118

11:35अभी चल रहा है

How to use the CHAR function in Excel? Excel me CHAR function ka upyog kaise kare? (Hindi) 117

Gyanyagya

119

15:40अभी चल रहा है

How to extract required details from huge data using concatenate & char formula in Excel?(Hindi) 118

Gyanyagya

120

15:23अभी चल रहा है

How to insert a blank row in between two data rows in MS Excel 2016/2013/2010/2007? (Hindi) 119

Gyanyagya

121

12:59अभी चल रहा है

How to use hyperlinks in MS Excel? Excel me hyperlink ka upyog kaise karen? (Hindi) 120

Gyanyagya

122

8:06अभी चल रहा है

How to insert & resize picture in Microsoft Excel 2016/2013/2010/2007? (Hindi) 121

Gyanyagya

123

5:56अभी चल रहा है

How to use indirect formula in Excel? Excel me indirect formula kaise upyog kare? (Hindi) 122

Gyanyagya

124

15:12अभी चल रहा है

How to use flash fill for splitting full name, combining & extracting data in Excel? (Hindi) 123

Gyanyagya

125

17:02अभी चल रहा है

How to use left, right & mid formula in Microsoft Excel 2016/2013/2010/2007? (Hindi) 124

Gyanyagya

126

6:48अभी चल रहा है

How to block actions performed on the worksheet of Excel Workbook? (Hindi) 125

Gyanyagya

127

13:04अभी चल रहा है

How to create & use the named range in Excel? name range kaise banaye aur upyog kare?(Hindi) 126

Gyanyagya

128

9:10अभी चल रहा है

How to use Group & Ungroup options in Excel? group/ungroup options kaise upyog karen? (Hindi) 127

Gyanyagya

129

7:37अभी चल रहा है

How to protect Excel workbook with password? Excel ko password se kaise protect kare? (Hindi) 128

Gyanyagya

130

11:25अभी चल रहा है

How to use indirect formula to find sum, avg etc of values of different sheets in Excel? (Hindi) 129

Gyanyagya

131

7:55अभी चल रहा है

How to make only first letter of a sentence capital in Microsoft Excel ? (Hindi) 130

Gyanyagya

132

22:18अभी चल रहा है

How to insert & customize shapes in MS Excel ? Excel me shapes kaise insert kare ? (Hindi) 131

Gyanyagya

133

14:46अभी चल रहा है

How to insert & customize smartart in Excel? Smartart insert aur customize karna? (Hindi) 132

Gyanyagya

134

11:47अभी चल रहा है

How to record macro in MS Excel for doing repetitive calculations & tasks? (Hindi) 133

Gyanyagya

135

6:42अभी चल रहा है

How to insert screenshot in Excel? Excel me screenshot kaise insert kare? (Hindi) 134

Gyanyagya