Master Google Sheets Course in Hindi Beginner to Advance.

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

₹399

₹399

₹4999

Play Icon 07:39:14 on-demand video

File Icon 1 article

  • Lifetime Access

  • Certificate Of Completion

  • 3 Students Enrolled

  • Created by: Satish Dhawale

  • Last updated: 2020-10-16 12:19:42

  • Hindi

 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

 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

 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

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.


Who is this Course for?

Advance Level


What Student 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


Requirement of the Course

Basic Computer Knowledge


Satish Dhawale

Learn More Earn More

Work in computer Teaching field in Mumbai from last 14 years and Teach almost 25000+ Offline Student

Play Icon Total Number of Course(s): 4

Play Icon Total Number of student(s) enrolled in all courses: 8

Play Icon Total Number of student(s) reviewed: 0

Other Courses

Students Feedback

0.0

0

0

0

0

0