Skill Course By Satish Dhawale

SkillCourse

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

₹499

₹1999

80% off

Play Video

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

Materials Included

Course Curriculum

Google Sheets : Module - 1

Preview

Play Video

01 - Introduction

Preview

Play Video

02 - Use of Functions

Preview

Play Video

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

₹499

₹1999

80% off

Course Rating By Summary

5.0
Rated 5.0 out of 5
5.0 out of 5 stars (based on 8 reviews)
Excellent100%
Very good0%
Average0%
Poor0%
Terrible0%

Submit Your Feedback

ARUN KUMAR

Rated 5.0 out of 5
February 9, 2023

VERY NICE TEACHING

ARUN KUMAR
Verified

Prasad Patil

Rated 5.0 out of 5
February 9, 2023

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

Prasad Patil
Verified

Sreeraj S

Rated 5.0 out of 5
February 9, 2023

Very good course.

Sreeraj S
Verified

Phuntsok Namgyal

Rated 5.0 out of 5
February 9, 2023

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

Phuntsok Namgyal
Verified

AMOL DWIVEDY

Rated 5.0 out of 5
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
Verified

Praveen Pandey

Rated 5.0 out of 5
February 9, 2023

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

Praveen Pandey
Verified

Bhavin Goklani

Rated 5.0 out of 5
February 9, 2023

Just Wow!!!

Bhavin Goklani
Verified

Aditya Agarwal

Rated 5.0 out of 5
February 9, 2023

Good content.

Aditya Agarwal
Verified

Send your doubt

“Please note: You will receive a reply from our team on your email ID within 24 to 48 hours.”

Subscribe Now

Get Helpful Newsletters Daily