Google Sheets Course in Hindi for Beginners

Google Sheets Course in Hindi for Beginners free download

Learn Google Sheets in 2025!, Functions, Lookup functions, Macros, Looker studio, App Script, Web Scraping and more.

My Google Sheets Complete Course in Hindi Language is about 16 hours long. I have Covered Google Spreadsheet Course in Hindi, Data Analysis, Visualization, Chart making , and Nifty Option Chain Live Data web scraping.

Google Sheets, एक पुरे एक्सेल-जैसा स्प्रेडशीट ऐप है, जो गूगल ड्राइव के हिस्से के रूप में तकरीबन सभी उपयोगकर्ताओं के लिए उपलब्ध होता है। इस कोर्स के माध्यम से, आप सीधे गूगल शीट्स पर काम करने का अवसर प्राप्त करेंगे, और यहाँ तक कि आप अपनी कोशिशों को बढ़ावा देकर आप विशिष्ट फ़ंक्शन, और वर्कशीट और चार्ट्स के बारे में गहराई से समझ सकेंगे।

यह कोर्स आपकी सफलता के दरवाजे खोल देगा क्यों कि ये आपको सिखाता है कि कैसे आप गूगल शीट्स का उपयोग करके अपने काम को आसान बना सकते हैं।

Google Sheets - गूगल शीट कम्प्लीट कोर्स हिन्दी मे । यह मेरे कोर्स का नाम है।

मैंने अपने कोर्स को 136 लेक्चर में बाँटा है।

यह लगभग 16 घंटे का कोर्स है।

यह कोर्स आपको सभी गूगल शीट्स के प्रमुख और उपयोगी फ़ंक्शन के साथ परिचय तक ले जाएगा, जो आपको इस विशेष कोर्स से सीखने में मदद करेगा। गूगल शीट्स कोर्स सीखने के बाद, आप अपनी सटीकता को बढ़ा सकते हैं । और आंकड़ों का विश्लेषण करके आप अपने ऑफिस मे अपनी वैल्यू बढ़ा सकते हैं।

अपनी ऑफिस प्रोडक्टिविटी बढ़ा सकते हैं।

तो आपको इस कोर्स की आवश्यकता हैं। आप इसे खरीद सकते हैं।

Google Sheets is a web-based spreadsheet program created by Google. So i Make this Google Sheets Complete Course in Hindi Language. Google Sheets is a cloud-based alternative to traditional desktop-based spreadsheet applications such as Microsoft Excel.

Google Sheets offers users the ability to create, edit, and collaborate on spreadsheets in real time, which makes it an excellent tool for team projects or for sharing data with others. It also allows for easy integration with other Google apps, such as Google Docs and Google Forms, making it a versatile and powerful tool for data analysis and reporting.

One of the key features of Google Sheets is its cloud-based nature, which means that users can access and work on their spreadsheets from any device with an internet connection. This makes it easy to work on the go and ensures that the most up-to-date version of a spreadsheet is always available.

I made it in 136 lectures.

Some of the topics that i have covered here are listed below:-

1.0 Introduction of Google Sheets

2.0 Overview of Google Sheets

3 Syntax of Google Sheets

4.0 Ranges in Google Sheets

5 Fills in Google Sheets

6 Move Cells in Google Sheets

7 Add Cells in Google Sheets

8.0 Delete Cells in Google Sheets

9.0 Undo and Redo in Google Sheets

10.0 Formulas in Google Sheets

11.0 Relative references in Google Sheets

12.0 Addition subtraction multiplication and division Operator in Google Sheets

13.0 Parentheses use for order of operation in Google Sheets

14.0 Functions in Google Sheets

15.0 Location Settings in Google Sheets

16.0 Formatting in Google Sheets

17.0 Format Painter in Google Sheets

18.0 Format Fonts in Google Sheets

19.0 Format Borders in Google Sheets

20.0 Format Numbers in Google Sheets

21.0 Format Gridlines in Google Sheets

22.0 Clear Format in Google Sheets

23.0 Sorting in Google Sheets

24.0 Sort Range in Google Sheets

25.0 Conditional Formatting in Google Sheets

26.0 AND Function in Google Sheets

27.0 Average Function in Google Sheets

28.0 AVERAGEIF Function in Google Sheets

29.0 AVERAGEIFS Function in Google Sheets

30.0 Count Function in Google Sheets

31.0 COUNTBLANK Function in Google Sheets

32.0 COUNTIF Function in Google Sheets

33.0 COUNTIFS Function in Google Sheets

34.0 IF Function in Google Sheets

35.0 IFS Function in Google Sheets

36.0 MAX Function in Google Sheets

37.0 MEDIAN Function in Google Sheets

38.0 MODE Function in Google Sheets

39.0 OR Function in Google Sheets

40.0 STDEV.P Function in Google Sheets

41.0 SUM Function in Google Sheets

42.0 SUMIF Function in Google Sheets

43.0 SUMIFS Function in Google Sheet

44.0 VLOOKUP Function in Google Sheets

45.0 XOR Function in Google Sheets

46.0 Array constrain in Google Sheets

47.0 BYCOL and BYROW function Google Sheets

48.0 ChooseCols and ChooseRows function in Google Sheets

49.0 FLATTEN function in Google Sheets

50.0 FREQUENCY in Google Sheets

51.0 GROWTH Function in Google Sheets

52.0 HSTACK function in Google Sheets

53.0 MAKEARRAY function in Google Sheets

54.0 MAP Function in Google Sheets

55.0 REDUCE function in Google Sheets

56.0 SCAN function in Google Sheets

57.0 SUMX2MY2 Function in Google Sheets

58.0 SUMPRODUCT Function in Google Sheets

59.0 SUMX2PY2 Function in Google Sheets

60.0 SUMXMY2 Function in Google Sheets

61.0 TOCOL Function in Google Sheets

62.0 TOROW function in Google Sheets

63.0 TRANSPOSE Function in Google Sheets

64.0 TREND Function in Google Sheets

65.0 VSTACK Function in Google Sheets

66.0 WRAPCOLS and WRAPROWS Functions in Google Sheets

67.0 DAVERAGE Function in Google Sheets

68.0 DSUM DMAX and DMIN functions in Google Sheets

69.0 DSTDEVP Function in Google Sheets

70.0 DATE NOW and Today function in Google Sheets

71.0 DAYS function in Google Sheets

72.0 BIN2DEC Function in Google Sheets

73.0 BITAND BITOR and BITXOR function in Google Sheets

74.0 COMPLEX NUMBERS in Google Sheets

75.0 FILTER function in Google Sheets

76.0 SORT function in Google Sheets

77.0 UNIQUE function in Google Sheets

78.0 DETECTLANGUAGE in Google Sheets

79.0 GOOGLETRANSLATE Function in Google Sheets

80.0 IMAGE function in Google Sheets

81.0 SPARKLINE Function in Google Sheets

82.0 GOOGLEFINANCE Function in Google Sheets

83.0 ERROR.TYPE Function in Google Sheets

84.0 Various info functions in Google Sheets

85.0 AND IF and IFS functions in Google Sheets

86.0 LAMBDA function in Google Sheets

87.0 LET Function in Google Sheets

88.0 Switch Logical function in Google Sheets

89.0 Address and Columns Lookup Functions Google Sheets

90.0 GetPivotData Function in Google Sheets

91.0 Hlookup Function in Google Sheets

92.0 INDEX Function in Google Sheets

93.0 LookUp functions in Google Sheets

94.0 VLOOKUP Function in Google Sheets

95.0 XLOOKUP Function in Google Sheets The ABS function returns the absolute value of a number.
The ACOS function returns the inverse cosine of a value in radians.
The ASIN function returns the inverse sine of a value in radians.
The BASE function converts a decimal number into a text representation in another base.
The CEILING function rounds a number up to the nearest integer multiple of specified significance.
The COS function returns the cosine of an angle provided in radians.
Countif returns a conditional count across a range.
Countifs returns the count of a range depending on multiple criteria.
The countunique function counts the number of unique values in a list of specified values and ranges.
The DECIMAL function converts the text representation of a number in another base, to base 10.
The DEGREES function converts an angle value in radians to degrees.
The Even function rounds a number up to the nearest even integer.
The FLOOR function rounds a number down to the nearest integer multiple of specified significance.
The FACT function returns the factorial of a number.
The GCD function returns the greatest common divisor of one or more integers.
The IMSQRT function computes the square root of a complex number.
The ISEVEN function Checks whether the provided value is even.
The ISODD function Checks whether the provided value is odd.
The POWER function returns a number raised to a power.
The PRODUCT function returns the result of multiplying a series of numbers together.
The quotient function returns one number divided by another, without the remainder.
The RAND function returns a random number between 0 inclusive and 1 exclusive.
The RANDARRAY function generates an array of random numbers between 0 and 1.
The RandBetween function returns a uniformly random integer between two values, inclusive.
The ROUND function rounds a number to a certain number of decimal places according to rules.
The SIGN function on applying on input returns returns `-1` if input is negative, `1` if input is positive, and `0` if input is zero.

The SQRT function returns the positive square root of a positive number.

The SUM function returns the sum of a series of numbers and/or cells.
The SUMIF function returns a conditional sum across a range.
The SUMIFS function returns the sum of a range depending on multiple criteria.
The TRUNC function truncates a number to a certain number of significant digits by omitting less significant digits.
The ADD function returns the sum of two numbers.
The CONCAT function returns the concatenation of two values and it is equivalent to the `&` operator.
The DIVIDE function returns one number divided by another.
The UMINUS function returns a number with the sign reversed.
The EQ function returns "TRUE" if two specified values are equal and "FALSE" otherwise.
The GT function returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise and it is equivalent to the `>` operator.
The GTE function returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise and it is equivalent to the `>=` operator.
The LT function returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator.
The LTE returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator.
The NE function returns "TRUE" if two specified values are not equal and "FALSE" otherwise. Equivalent to the "<>" operator.
The MINUS function returns the difference of two numbers.
The MULTIPLY function returns the product of two numbers. Equivalent to the `*` operator.
The UNIQUE function returns unique rows in the provided source range, discarding duplicates.
The ISBETWEEN function checks whether a provided number is between two other numbers either inclusively or exclusively.
The CONVERT function converts a numerical value to a different unit of measure.
The TO_DOLLARS function converts a provided number to a dollar value.
The TO_PERCENT function converts a provided number to a percentage.
The TO_PURE_NUMBER function converts a provided date/time, percentage, currency or other formatted numerical value to a pure number without formatting.
The TO_TEXT function converts a provided numeric value to a text value.
The CORREL function calculates r, the Pearson correlation coefficient of a dataset.
The COVAR function calculates the covariance of a dataset.
The MAX function returns the maximum value in a numeric dataset.
The MAXIFS function returns the maximum value in a range of cells, filtered by a set of criteria.
The MEDIAN function returns the median value in a numeric dataset.
The MINIFS function returns the minimum value in a range of cells, filtered by a set of criteria.

The STDEV function calculates the standard deviation based on a sample.
The MODE function returns the most commonly occurring value in a dataset.
The VAR function calculates the variance based on a sample.
The CHAR function converts a number into a character according to the current Unicode table.
The CONCATENATE function appends strings to one another.
The DOLLAR function formats a number into the locale-specific currency format.
The EXACT function tests whether two strings are identical.
The LEN function returns the length of a string.
The LOWER function converts a specified string to lowercase.
The MID function returns a segment of a string.
The PROPER function capitalizes each word in a specified string.
The REPLACE function replaces part of a text string with a different text string.
The RIGHT function returns a substring from the end of a specified string.
The SEARCH function returns the position at which a string is first found within the text, ignoring the case.
The SPLIT function divides text around a specified character or string and puts each part into a separate cell in the row.
The SUBSTITUTE function replaces existing text with new text in a string.
The TEXT function converts a number to text according to a specified format.
The TEXTJOIN function combines the text from multiple strings, with a specifiable delimiter separating the different texts.
The TRIM function removes leading, trailing, and repeated spaces in text.
The AVERAGE function returns the numerical average value in a dataset, ignoring text.
The AVERAGEA function returns the numerical average value in a dataset.
The AVERAGEIF function returns the average of a range depending on criteria.
Its syntax is given by AVERAGEIF(criteria_range, criterion, [average_range])
The AVERAGEIFS function returns the average of a range depending on multiple criteria. Its syntax is AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
The HYPERLINK function creates a hyperlink inside a cell.
The ENCODEURL function encodes text so it can be used in the query string of a URL.
The IMPORTHTML function imports data from a table or list within an HTML page. Its syntax is IMPORTHTML(url, query, index).

The IMPORTXML function imports data from any of various structured data types including XML, HTML, CSV, TSV, RSS and ATOM XML feeds. Its syntax is IMPORTXML(url, xpath_query, locale).

The IMPORTRANGE function imports a range of cells from a specified spreadsheet. Its syntax is IMPORTRANGE(spreadsheet_url, range_string).
The ISURL function checks whether a value is a valid URL.
The IMPORTHTML imports data from a table or list within an HTML page of any website.
The IMPORTFEED function imports an RSS or ATOM feed. Its syntax is IMPORTFEED(url, [query], [headers], [num_items]).

110.0 Google Sheets Chart Part 1

111.0 Google Sheets Chart Part 2

112.0 make drop down list in Google Sheets

113. How to freeze rows or columns during scrolling action in google Sheets

114. How to use Ampersand in google Sheets

115. google Sheets Left Right and mid functions to cut strings

116. How to hide columns in google Sheets

117. How to share a file in google Sheets

118. How to use Query function in google Sheets Part 1

119. Query functions in Google Sheets part 2

120. Form Creation in Google Sheets

121. APP Sheet in Google Sheets part1

122. APP Sheet in Google Sheets part 2

123. How to use Chat GPT in Google sheets

124. Apps Script in Google Sheets Part 1

125. Apps Script in Google Sheets Part 2

126. Apps Script in Google Sheets Part 3

127. Apps Script in Google Sheets Part 4

128. Apps Script in Google Sheets Part 5

129. Apps Script in Google Sheets Part 6

130. Apps Script in Google Sheets Part 7

131. Google Sheets Triggers on 'NIFTY option chain data' of Indian share market

132. Google Sheets Macros

133. Google Sheets Looker Studio Part 1

134.0 data validation in google Sheets