Google Sheets Full Course

Last Updated:July 5, 2021

Course Duration:7h 41m

Total Enrolled:462

rating:

5.00(6 Ratings)

Course Benefits

materials include

course content

Ratings & Reviews

course 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 में जो डाटा आप मैनेज नहीं कर सकते वो आप गूगल शीट में क्वेरी फार्मूला से आसानी से कर सकते है |

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

94% Discount for First 100 Students Hurry Up !

Good News : All Courses Video Will Be Available for Downloads

Course Benefits

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

materials include

60 Lessons
Video Tutorials
All Practice Files
Course Completion Certificate
Lifetime Access

course content

62 Lessons7h 41m

Google Sheets Full Course Videos Tutorials

1 – Google Sheets Introduction00:13:15

2 – Google Sheets – Use of Functions00:9:25

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

57 – Google Sheets – Query Formula -100:08:21

58 – Google Sheets – Query Formula – 200:07:38

59 – Google Sheets – Query Formula – 300:07:42

60 – Google Sheets – Project On Query Formula00:20:23

Trial Paper and Final Exam for Certificate

Student Ratings & Reviews

5.0

Total 6 Ratings

1 rating

0 rating

Phuntsok Namgyal

8 months ago

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.

Learn More