2 - Google Sheets - Use of Functions

Lesson List

Google Sheets Full Course Videos Tutorials?

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 – Hyperlink and Insert Comment00:8:40

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

How will You get Certificate?00:04:13

Trial Paper For Final Exam

Final Exam for Certificate

Go to Course Home

2 – Google Sheets – Use of Functions

निचे दिए गए बटन से आप इस कोर्स की सभी प्रैक्टिस फाइल्स डाउनलोड कर सकते है

नोट : ये प्रैक्टिस फाइल्स कंप्यूटर पे या लैपटॉप पे ही डाउनलोड होगी | मोबाइल ऍप पे डाउनलोड नहीं होगी ..

← Previous Next →