Google Sheets
Time ke saath apne skills ko upgrade kare. Excel ke saath saath ab jyada tar companies use kar rahe hai Google Sheets!
₹499 ₹2000 75% off
This course includes
- 60 Video Tutorials
- Access on mobile & computer
- 1 Year access to all video lessons
- Industry recognised Certification
- Lifetime certificate validity
- Online verification of your certificate
₹499 ₹2000 75% off
This course includes
- 60 Video Tutorials
- Access on mobile & computer
- 1 Year access to all video lessons
- Industry recognised Certification
- Lifetime certificate validity
- Online verification of your certificate
What you'll learn
Iss course mai hum ye topics cover karenge:
- Google Sheets Introduction
- Use of Functions
- Inserting & Deleting Sheets
- Insert Chart
- Format Chart
- Use of Pivot Table in Google sheet
- Work on Multiple 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
- Printing Tips
- Mail Merge
- Create QR Code using Formula
- Import Data from Web
- Merge Workbooks
Requirements
- Basic Internet access
- Basic Hindi & English understanding
- Access to Computer or Smartphone
Topics for this course
View All Lessons
-
1. Google Sheets Introduction
00:13:15
-
2. Use of Functions
00:09:25
-
3. Inserting and Deleting Sheets, Navigating Sheets
00:11:48
-
4. Paint Format, Currency Format, %Age Formula
00:12:23
-
5. Enable Keyboard Shortcuts, Format Sheet
00:08:19
-
6. Hyperlink and Insert Comment
00:08:40
-
7. Share sheets with multiple people and word together
00:08:24
-
8. Insert Chart & Format Chart 1
00:10:31
-
9. Insert Chart & Format Chart 2
00:11:30
-
10. Sort and Filter Options
00:12:22
-
11. Save Filter, Create Filter
00:07:29
-
12. Filter formula
00:07:15
-
13. File Menu – Save Version History, Open Excel file
00:10:00
-
14. File Menu – Publish file to web
00:06:09
-
15. Printing Tips
00:08:20
-
16. Edit Menu – Paste Special
00:10:16
-
17. Edit Menu – Find and Replace
00:08:45
-
18. View Menu – Freeze Panes
00:08:45
-
19. Insert Menu 1 – Image, Rows, columns
00:12:03
-
20. Insert Menu 2 – Google Forms Link to Google sheets
00:11:13
-
21. Insert Menu 3 – Check Boxes, Create To do List
00:06:02
-
22. Format Tab – Conditional formatting, Number formatting
00:11:36
-
23. Data Menu – use of Slicers
00:07:10
-
24. Data Menu – Data Validation
00:17:18
-
25. Pivot Table – Create summerize reports
00:12:22
-
26. Add Named Ranges and apply formula
00:07:15
-
27. Google Protect Worksheet and Range
00:09:07
-
28. Split Text to Columns, Remove Duplicates
00:08:41
-
29. Macro Recordings
00:10:06
-
30. Accessibility Options
00:06:36
-
31. Mail Merge – Send Bulk Emails
00:09:14
-
32. IFS formula use
00:04:44
-
33. Text Join and Concatenate formula
00:07:38
-
34. Google Translate formula
00:04:38
-
35. Vlookup and Hlookup in Google Sheet
00:12:13
-
36. Countif, Countifs, Sumif, Sumifs
00:12:30
-
37. Sumif, Sumifs Formula in Google sheet
00:05:04
-
38. Count Unique IFS new formula
00:05:31
-
39. Sparklines Formula Bar, Columnline Chart
00:09:32
-
40. All IsFormula – Isemail, IsNumber, Istext
00:07:30
-
41. Create QR Code using Formula
00:05:57
-
42. All useful Text Formulas
00:11:43
-
43. All useful Number Formulas
00:09:35
-
44. Get Unique Record
00:03:27
-
45. Use of Query Formula – Remove Blanks
00:06:36
-
46. Import Data from Web
00:04:19
-
47. Merge Sheets Data
00:07:15
-
48. Merge Workbooks
00:12:54
-
49. Remove Blank rows tricks
00:06:12
-
50. Offset Formula Introduction
00:09:15
-
51. Real Use of Offset Formula
00:09:20
-
52. Create Monthly report dashboard
00:11:13
-
53. Sequence and Rand Formulas
00:05:45
-
54. Unique Rank Formula
00:07:20
-
55. Send Auto Email – Add On
00:14:31
-
56. Copy Down Formula Add On
00:11:58
-
57. Query Formula 1
00:08:21
-
58. Query Formula 2
00:07:38
-
59. Query Formula 3
00:07:42
-
60. Project On Query Formula
00:20:23
Related Business Opportunities.
Find Better & Faster with Creative Group Career Services
Licensed Private Security Agency
Security
Investment Range:INR 2,00,000 - INR 3,00,000
Silca Point (Key Cutting Services)
Service
Investment Range:INR 1,50,000 - INR 2,00,000
