You must have JavaScript enabled in order to use this order form. Please enable JavaScript and then reload this page in order to continue.

Course added to cart
Course removed from cart
Course Preview

₹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

Business Opportunity

Licensed Private Security Agency

Security

Investment Range:INR 2,00,000 - INR 3,00,000

View Details
Business Opportunity

Silca Point (Key Cutting Services)

Service

Investment Range:INR 1,50,000 - INR 2,00,000

View Details
App Screen

Start your Second Innings with us.

Aapka second career ab aapki muthi mai

Whatsapp