Master Google Sheets Course in Hindi Beginner to Advance.

Master Google Sheets Course in Hindi Beginner to Advance.

Learn advance formulas of google sheets, Create dashboard in Google sheets & Many more

Rating (0) 3 Student EnroledCourse ID: 53 
Created by: Satish Dhawale Last updated: 2020-10-16 English

2994999

Accept: USD, AUD etc

This course includes

  • 07:28:59 on-demand video
  • 0 article
  • Full lifetime access
  • Certificate Exam
  • 10 Days Refund Guarantee
Google Sheets For Beginners
  • Google Sheets Introduction
    00:13:14
  • Google Sheets - Use of Functions
    00:09:24
  • Inserting And Deleting Sheets, Navigating Sheet
    00:11:47
  • Paint Format, Currency Format, % Age Formula
    00:12:22
  • Enable Keyboard Shortcuts, Format Sheet
    00:08:18
  • Hyperlink And Insert Comment
    00:21:35
  • Share Sheets With Multiple People And Word Together
    00:08:24
  • Insert Chart & Format Chart
    00:10:31
  • Insert Chart & Format Chart - 2
    00:11:30
  • Sort And Filter Options
    00:12:22
  • Save Filter, Create Filter
    00:07:28
  • Google Sheets - Filter Formula
    00:07:14
  • Save Version History, Open Excel File
    00:09:59
  • File Menu - Publish File To Web-
    00:06:08
  • Google Sheets - Printing Tips
    00:06:31
  • Google Sheets - Edit Menu - Paste Special
    00:10:15
  • Google Sheets - View Menu - Freeze Panes
    00:08:44
  • Google Sheets - Insert Menu - 1 - Image, Rows, Columns
    00:12:02
  • Google Sheets - Insert Menu - 2 - Google Forms Link To Google Sheets-
    00:11:12
  • Google Sheets - Insert Menu - 3 - Check Boxes - Create To Do List
    00:06:01
Google Sheets for Intermediate
  • Format Tab - Conditional Formatting, Number Formatting
    00:11:36
  • Data Menu - Use Of Slicers
    00:07:09
  • Pivot Table - Create Summarize Reports
    00:12:21
  • Add Named Ranges And Apply Formula
    00:07:14
  • Google Protect Worksheet And Range
    00:09:06
  • Spilt Text To Columns, Remove Duplicates
    00:08:41
  • Google Sheets - Macro Recordings
    00:10:05
  • Accessibility Options
    00:06:36
  • Mail Merge - Send Bulk Emails
    00:09:14
  • Ifs Formula Use
    00:04:44
  • Text Join And Concatenate Formula
    00:07:38
  • Google Translate Formula
    00:04:38
  • Vlookup And Hlookup In Google Sheet
    00:12:12
  • Countif, Countifs, Sumif, Sumifs Formula in Google Sheet
    00:12:30
  • Countuniqueifs New Formula
    00:05:31
  • Sparklines Formula (Barcolumnline Chart)
    00:09:32
  • All Isformula - (Isemail, Isnumber, Istext...)
    00:07:30
Google Sheets For Advance Tutorial
  • Create QR Code Using Formula
    00:05:57
  • All Useful Text Formulas
    00:11:43
  • All Useful Number Formulas-
    00:09:34
  • Get Uniue Record In Google Sheet
    00:03:27
  • Use Of Query Formula - Remove Blanks
    00:06:35
  • Import Data From Web
    00:04:19
  • Merge Sheets Data
    00:07:15
  • - Merge Workbooks-
    00:12:53
  • Remove Blank Rows Tricks
    00:06:12
  • Offset Formula Introduction
    00:09:14
  • Real Use Of Offset Formula
    00:09:19
  • Created Monthly Report Dashoard
    00:11:13

What I will learn?

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

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

  • 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
  • Create Dashboard in Google sheets

Requirements

Basic Computer Knowledge

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.

Student feedback

0 Stars

Average rating

0

0

0

0

0