Google Sheets Mastery Course

Learn Google Sheets from Beginner to Advanced – Learn Pivot Tables – Graphs -Dashboards, Hands-on Practical Examples, Lots of Exercises, that will make you master in Google Sheets

4.9 Rating

★★★★★ 5/5

₹399

₹1999

80% off

Course Description

Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google.

In this course you will learn Google sheet from Beginners to Advance. (Courses by Satish Dhawale Sir) सभी कोर्सेस आसान हिंदी भाषा में | Read More पे क्लिक करे और कोर्स के फीचर्स जानने के लिए |

Course Features
✅सभी कोर्सेस सरल हिंदी भाषा में
✅Google Sheet बेसिक से एडवांस कोर्सेस
✅60+ DETAIL वीडियोस ????
✅ कोर्स प्रैक्टिस फाइल्स उपलब्ध
✅कोर्स कम्पलीशन सर्टिफिकेट
✅इंस्टेंट एक्सेस –
⬇️ Download Video in APP

Free BONUSES-
✅ PDF शॉर्टकट्स

????‍???? This course is Created by : Satish Dhawale
सतीश सर को कंप्यूटर के क्षेत्र में टीचिंग का लगभग 16 साल का अनुभव हैं जिसमे उन्होंने 14 साल तक ऑफलाइन कंप्यूटर संस्थान में 40000+ से अधिक स्टूडेंट्स को और अपने Online अपने Learn More Channel के माध्यम से लगभग 17,00,000+ से ज्यादा स्टूडेंट्स को कंप्युटर कि शिक्षा देने का कार्य किया हैं। YouTube : 7 Silver and 1 Gold Button Award Winner for their 7 YouTube Channels

Course Benefits

What is Google sheet?
Google Sheet Inteface & features
Working with Data in Google sheet
Import and export Data with Google sheet
Sorting and Filtering data in Google sheet
Create Filter views and clean data in Google Sheet
Working with Lookup Function
VLOOKUP, INDEX & MATCH, FILTER & SORTN Function
Learn Summarization Functions like SUM, COUNT, SUMIFS, COUNTIFS
Learn IF and IFS functions

Materials Included

60+ Video tutorial
8 Hours on demand lectures
Real Job Problem scenario
Downloadable Practice file available
Course completion ISO certificate
WhatsApp and Call Support

Course Curriculum

Google Sheets : Module - 1

Preview

01 - Introduction

Preview

02 - Use of Functions

Preview

03 - Inserting and Deleting Sheets, Navigating Sheets

04 – Paint Format, Currency Format, % Age Formula 12:23 Min

05 – Enable Keyboard Shortcuts, Format Sheet 08:19 Min

Google Sheets : Module - 2

01 – Hyperlink and Insert Comment 21:35 Min

02 – Share sheets with multiple people and word together 08:24 Min

03 – Insert Chart & Format Chart -1 10:51 Min

04 – Insert Chart & Format Chart – 2 11:30 Min

05 – Sort and Filter Options 12:22 Min

06 – Save Filter, Create Filter 07:29 Min

07 – Filter formula 07:15 Min

08 – File Menu – Save Version History, Open Excel file 10:00 Min

09 – File Menu – Publish file to web 06:09 Min

10 – Printing Tips 08:20 Min

11 – Edit Menu – Paste Special 10:16 Min

Google Sheets : Module - 3

01 – Edit Menu – Find and Replace 08:45 Min

02 – View Menu – Freeze Panes 08:45 Min

03 – Insert Menu – 1 – Image, Rows, Columns 12:03 Min

04 – Insert Menu – 2 – Google Forms Link to Google Sheets 11:13 Min

05 – Insert Menu – 3 – Check Boxes – Create To do List 06:02 Min

06 – Format Tab – Conditional formatting, Number formatting 11:36 Min

07 – Data Menu – Use of Slicers 07:10 Min

08 – Data Menu – Data Validation 17:18 Min

09 – Pivot Table – Create Summarize Reports 12:22 Min

10 – Add Named Ranges and Apply Formula 07:15 Min

11 – Google Protect Worksheet and Range 09:07 Min

Google Sheets : Module - 4

01 – Split Text to Columns, Remove Duplicates 08:41 Min

02 – Macro Recordings 10:06 Min

03 – Accessibility Options 06:36 Min

04 – Mail Merge – Send Bulk Emails 09:14 Min

05 – IFS formula use 04:44 Min

06 – Text Join and Concatenate formula 07:38 Min

07 – Google Translate formula 04:38 Min

08 – VLOOKUP and HLOOKUP in Google Sheet 12:13 Min

09 – Countif, Countifs, Sumif, Sumifs 12:30 Min

10 – Sumif, Sumifs Formula in Google sheet 05:04 Min

11 – CountUniqueIFS new formula 05:31 Min

Google Sheets : Module - 5

01 – Sparklines Formula Bar Column line Chart 09:32 Min

02 – All IsFormula – Isemail, IsNumber, Istext 07:30 Min

03 – Create QR Code using Formula 05:57 Min

04 – All useful Text Formulas 11:41 Min

05 – All useful Number Formulas 09:35 Min

06 – Get Unique Record 03:37 Min

07 – Use of Query Formula – Remove Blanks 06:36 Min

08 – Import Data from Web 04:19 Min

09 – Merge Sheets Data 07:15 Min

10 – Merge Workbooks 12:54 Min

11 – Remove Blank rows tricks 06:12 Min

Google Sheets : Module - 6

01 – Offset Formula Introduction 09:15 Min

02 – Real Use of Offset Formula 09:20 Min

03 – Created Monthly Report Dashboard 11:13 Min

04 – Sequence and Rand Formulas 05:45 Min

05 – Unique Rank Formula – 1 07:20 Min

06 – Send Auto Email – Add-Ons-1 14:31 Min

07 – Copy Down Formula Add-Ons 11:58 Min

08 – Query Formula – 1 08:21 Min

09 – Query Formula – 2 07:38 Min

10 – Query Formula – 3 07:42 Min

11 – Project on Query Formula 20:23 Min

Course Instructor

Satish Dhawale

Founder & CEO of CoursePe

Satish Dhawale has over 15 years of experience in the field of computer education, he has been promoting computer education through his blog www.learnmoreindia.in and YouTube channel Learn More with 1.5 M+ subscribers for more than 5 years now. 1 Gold Play and 5 Silver Play Awards have been awarded by YouTube. Learn More YouTube channel provides tutorials related to computer and technology in the Hindi language to Learn and improve your life.

Course Completion Certificate

₹399

₹1999

80% off

Course Rating By Summary

5.0

5.0 out of 5 stars (based on 8 reviews)

Excellent100%

Very good0%

Average0%

Poor0%

Terrible0%

Submit Your Feedback

ARUN KUMAR

February 9, 2023

VERY NICE TEACHING

ARUN KUMAR

Prasad Patil

February 9, 2023

Nice Sessions with Satish sir. very useful and knowledgeful course.

Prasad Patil

Sreeraj S

February 9, 2023

Very good course.

Sreeraj S

Phuntsok Namgyal

February 9, 2023

गूगल शीट में इतनी सारी चीजे होती और आपने बहुत आसानी से बताई है, ये कोर्स कम्पलीट करके आज लग रहा है की गूगल शीट मास्टर हम भी बन गए , दिलसे शुक्रिया आपका जो इतनी कम फीस में इतना बड़ा कोर्स दिया

Phuntsok Namgyal

AMOL DWIVEDY

February 9, 2023

This course is created in order to make students fully aware of Google Sheets and the similarities or differences it shares with MS-Excel. The content is extremely practical, job oriented and didactic which enables even those who are not good enough with spreadsheets to clearly understand what it means and how does it functions. The formulae taught in this course are very much empirical and easy to implement in our lives. So, Kudos to Satish Sir for elucidating a complex topic in such an intriguing manner. This ain’t my first course with Learn More Pro (now CoursePe) and for sure, wouldn’t be the last either.

AMOL DWIVEDY

Praveen Pandey

February 9, 2023

This is a wonderful course and upgrade my knowledge at optimum level & Thanks to Satish Sir

Praveen Pandey

Bhavin Goklani

February 9, 2023

Just Wow!!!

Bhavin Goklani

Aditya Agarwal

February 9, 2023

Good content.

Aditya Agarwal