लर्न मोरे प्रो पे आपका स्वागत है Life Time Access + Download Videos + Practice Files

Google Sheets Full Course

5.00(6)

Google Sheets Full Course

  • Duration 7h 41m
  • Total Enrolled 258
  • Last Update January 22, 2021

Description

Now every organization switching there task on google sheets to work smart, to work in group, and mainly to work from home so if you are one of them then this is for you but if you are thinking that “it’s not my cup of tea excel is OK for me.” Then I must tell you that you are not upgrading yourself.

तो आप क्या सीखोगे ?

Excel में जो डाटा आप मैनेज नहीं कर सकते वो आप गूगल शीट में क्वेरी फार्मूला से आसानी से कर सकते है |

गूगल शीट में आप एक साथ मल्टीप्ल लोग काम कर सकते है | और सभी को अलग अलग टास्क दे सकते और हर एक को प्रोटेक्ट सेल्स में काम दे सकते है |

Title of the document

Good News : All Courses Video Will Be Available for Downloads

What Will I Learn?

  • Work on Multiple sheet
  • Use of Pivot Table in Google sheet
  • Create Dashboard in Google Sheet
  • Data validation in Google Sheet
  • Merge Multiple sheet in Google sheet
  • Create Google Forms
  • Use Mail Merge in Google sheet
  • Create Bar code in Google sheet
  • Use of Query Formula
  • Many formulas of Google sheet

Topics for this course

57 Lessons7h 41m

Google Sheets Full Course Videos Tutorials?

Google Sheets Full Course Videos Tutorials
3 – Google Sheets – Inserting and Deleting Sheets, Navigating Sheets00:11:48
4 – Google Sheets – Paint Format, Currency Format, %Age Formula00:12:23
5 – Google Sheets – Enable Keyboard Shortcuts, Format Sheet00:8:19
6 – Google Sheets – Hyperling and Insert Comment00:21:35
7 – Goolge Sheeets – Share sheets with multiple people and word together00:8:24
8 – Google Sheets – Insert Chart & Format Chart -100:10:31
9 – Google Sheets – Insert Chart & Format Chart – 200:11:30
10 – Google Sheets – Sort and Filter Options00:12:22
11 – Google Sheets – Save Filter, Create Filter00:07:29
12 – Google Sheets – Filter formula00:7:15
13 – Google Sheets – File Menu – Save Version History, Open Excel file00:10:00
14 – Google Sheets – File Menu – Publish file to web00:06:09
15 – Google Sheets – Printing Tips00:08:20
16 – Google Sheets – Edit Menu – Paste Special00:10:16
17 – Google Sheets – Edit Menu – Find and Replace00:08:45
18 – Google Sheets – View Menu – Freeze Panes00:8:45
19 – Google Sheets – Insert Menu – 1 – Image, Rows, columns00:12:03
20 – Google Sheets – Insert Menu – 2 – Google Forms Link to Google sheets00:11:13
21- Google Sheets – Insert Menu – 3 – Check Boxes – Create To do List00:06:02
22 – Google Sheets – Format Tab – Conditional formatting, Number formatting00:11:36
23 – Google Sheets – Data Menu – use of Slicers00:07:10
24 – Google Sheets – Data Menu – Data Validation00:17:18
25 – Google Sheets – Pivot Table – Create summerize reports00:12:22
26 – Goolge Sheets – Add Named Ranges and apply formula00:07:15
27 – Google Protect Worksheet and Range00:09:07
28 – Google Sheets – Split Text to Columns, Remove Duplicates00:8:41
29 – Google Sheets – Macro Recordings00:10:6
30 – Google Sheets – Accessibility Options00:6:36
31 – Google Sheets – Mail Merge – Send Bluk Emails00:09:14
32 – Google Sheets – IFS formula use00:04:44
33 – Google Sheets – Text Join and Concatenate formula00:07:38
34 – Google Sheets – Google Translate formula00:04:38
35 – Google Sheets – Vlookup and Hlookup in Google Sheet00:12:13
36 – Google Sheets – Countif, Countifs, Sumif, Sumifs00:12:30
37 – Google Sheets – Sumif, Sumifs Formula in Google sheet00:05:04
38 – Google Sheets – CountUniqueIFS new formula00:05:31
39 – Google Sheets – Sparklines Formula BarColumnline Chart00:09:32
40 – Google Sheets – All IsFormula – Isemail, IsNumber, Istext00:07:30
41 – Google Sheets – Create QR Code using Formula00:05:57
42 – Google Sheets – All useful Text Formulas00:11:43
43 – Google Sheets – All useful Number Formulas00:09:35
44 – Google Sheets – Get Uniue Record00:03:27
45 – Google Sheets – Use of Query Formula – Remove Blanks00:06:36
46 – Google Sheets – Import Data from Web00:04:19
47 – Google Sheets – Merge Sheets Data00:07:15
48 – Google Sheets – Merge Workbooks00:12:54
49 – Google Sheets – Remove Blank rows tricks00:06:12
50 – Google Sheets – Offset Formula Introduction00:09:15
51 – Google sheets – Real Use of Offset Formula00:9:20
52 – Google Sheets – Created Monthly report dashboard00:11:13
53 – Google Sheets – Sequence and Rand Formulas00:05:45
54 – Google Sheets – Unique Rank Formula-100:07:20
55 – Google Sheets – Send Auto Email – Add-Ons-100:14:31
56 – Google Sheets – Copy Down Formula Add-Ons00:11:58
Total 60 Videos (Will Upload Very Soon….)

About the instructor

4.88 (212 ratings)

15 Courses

8292 students

Student Feedback

5.0

Total 6 Ratings

5
6 ratings
4
0 rating
3
0 rating
2
0 rating
1
0 rating

Enjoyed every bit of your demonstration and example. If you could design a course to link Google sheet with Awesome Table then it would be wonderful. Thank you. I feel I have not wasted even a single rupee on my investment. My return was much more than my initial investment.

I am impress with your PowerPoint course that's why I enrolled to this and I must tell you sir this one is also best course.

Thanku sir for providing this Useful Course

Ye course mere liye hai sahi me bahut jaruri tha ji, maine youtube video dekhe par jyada tar english me hi the par ab mujhe mila sahi wala course, bahut Shurkiya ji

गूगल शीट में इतनी सारी चीजे होती और आपने बहुत आसानी से बताई है, ये कोर्स कम्पलीट करके आज लग रहा है की गूगल शीट मास्टर हम भी बन गए , दिलसे शुक्रिया आपका जो इतनी कम फीस में इतना बड़ा कोर्स दिया

Sir You are really awesome and obviously your every videos are also very perfect and simply anyone can learn anything from you

4,999.00 299.00

Material Includes

  • Video Tutorials
  • All Practice Files
  • Course Completion Certificate
  • Download All Course Videos

Requirements

  • Basic Excel Knowledge

Target Audience

  • Job Seeker
Chat on WhasApp
Hello
* Only Courses related support Available
* Support Between 12 pm To 9 Pm
* आप अगर लर्न मोर प्रो के कोर्सेस से रिलेटेड कुछ सवाल पूछना चाहते है तो आपका सवाल टाइप कीजिये |