PC Skill

PCskill

Google Sheets Full Course

August 16, 2021
07h 41m
50

rating:

4.00(2 Ratings)

Enrolment validity: Lifetime

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

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

 

For Computer Hardware Course Support Contact us: +91 8591597259 (Team Learn More)

This course creates and Provided on the PCskill app by Satish Dhawale with the collaboration of PCSkill Founder: Abhimanyu Sir, for any query related to the course you can contact us on this Whatsapp number: +91 8591597259  we will be happy to help you

Course Benefits

  • Work on Multiple sheets
  • Use of Pivot Table in Google sheet
  • Create Dashboard in Google Sheet
  • Data validation in Google Sheet
  • Merge Multiple sheets 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 Lessons07h 41m

Google Sheets Full Course Videos Tutorials (60 videos)

1 – Google Sheets Introduction00:13:15
2 – Google Sheets – Use of Functions00:09: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:08:19
6 – Google Sheets – Hyperlink and Insert Comment00:08:40
7 – Goolge Sheeets – Share sheets with multiple people and word together00:08: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:07: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:08: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 – Google 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:08:41
29 – Google Sheets – Macro Recordings00:10:06
30 – Google Sheets – Accessibility Options00:06:36
31 – Google Sheets – Mail Merge – Send Bulk 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 Bar Columnline 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:09: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

4.0

Total 2 Ratings

5
1 rating
4
0 rating
3
1 rating
2
0 rating
1
0 rating

Nic

Nice