Google Sheets Mastery

The "Google Sheet Mastery" course is a comprehensive program designed to help individuals develop advanced skills in using Google Sheets, the popular cloud-based spreadsheet software. The course is suitable for beginners who want to learn the basics of Google Sheets as well as for advanced users who want to expand their knowledge and improve their productivity.

Advanced 0 Students enrolled
Created by Yogesh Oberoi Updated course English
Want to Connect with Live Sessions Click Here and Join
What will i learn?
  • Advanced skills in using Google Sheets
  • Basics of Google Sheets
  • Organizing data and designing effective spreadsheets
  • Create professional-looking spreadsheets

Curriculum for this course
29 Lessons 03:37:23 Hours
Google Sheet Mastery
29 Lessons 03:37:23 Hours
  • INTRODUCTION - WHY GOOGLE SHEETS 00:02:19
  • LET_S START - CREATING NEW SHEETS 00:03:31
  • USING TEMPLATES 00:01:35
  • Managing Versions 00:06:41
  • MS EXCEL VS GOOGLE GHEETS _ EXPORTING OTHER FILES 00:06:28 Preview
  • USING DIFFERENT FEATURES IN GOOGLE SHEETS 00:06:03
  • BASIC EDITING IN GOOGLE SHEETS 00:05:52
  • AUTOFILL OPTION 00:06:23 Preview
  • BASIC FORMATTING 00:10:57
  • CELL, COLUMN _ ABSOLUTE REFERENCING 00:09:23 Preview
  • SHEETS _ FILE REFERENCING IN SHEETS 00:14:19
  • BASIC FORMULAS 00:07:27
  • SUM, SUMIF, SUMIFS 00:16:43
  • Count, Counta, Countif 00:04:24
  • IF _ IFS 00:14:18
  • CONCAT, CONCATENATE, AMPERSAND(_) 00:05:45
  • Max, Min, Average, Pluse, Minus , Divide 00:06:26
  • JOIN _ TEXTJOIN 00:06:56
  • SPLIT, CODE, CHAR, LEN, MID _ TRANSPOSE 00:12:15
  • DECIMAL PLACES _ ROUNDING FORMULAS 00:08:22
  • FORMULAS STARTING FROM _IS_ 00:07:41
  • FREEZING CELLS _ COLUMNS 00:02:02
  • PRINT _ PAGE SETUP 00:06:50
  • SORTING _ FUNCTION (SORT _ SORTN) 00:07:15
  • FILTERING 00:10:48
  • SHEETS SETTING 00:04:38
  • DATE _ TIME 00:07:25
  • DATA VALIDATION 00:06:47
  • VLOOKUP 00:07:50
Requirements
  • Laptop or Desktop
  • Internent Connection
+ View more
Description

The "Google Sheet Mastery" course is a comprehensive program designed to help individuals develop advanced skills in using Google Sheets, the popular cloud-based spreadsheet software. The course is suitable for beginners who want to learn the basics of Google Sheets as well as for advanced users who want to expand their knowledge and improve their productivity.

The course covers a wide range of topics, including formatting data, creating and managing formulas and functions, using advanced features like pivot tables and charts, collaborating with others, and automating tasks with scripts. It also covers best practices for organizing data and designing effective spreadsheets.

The course is delivered through a series of video tutorials, exercises, and quizzes. Each lesson is designed to be interactive and engaging, with practical examples and real-world scenarios to help students apply what they have learned. Additionally, the course includes access to a community of learners where students can ask questions, share their work, and receive feedback and support.

Upon completing the "Google Sheet Mastery" course, students will have the skills and knowledge to use Google Sheets effectively in a variety of settings, including business, education, and personal finance. They will be able to create professional-looking spreadsheets, analyze data, and collaborate with others in real-time. Whether you are a beginner or an advanced user, the "Google Sheet Mastery" course is an excellent resource for anyone who wants to improve their proficiency in using this powerful tool.

+ View more
Other related courses
03:05:57 Hours
Updated Thu, 07-Sep-2023
0 ₹699 ₹299
About the instructor
  • 0 Reviews
  • 0 Students
  • 3 Courses
+ View more
Student feedback
0
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews
₹299 ₹599
Buy now
Includes:
  • 03:37:23 Hours On demand videos
  • 29 Lessons
  • Access on mobile and tv
  • Full lifetime access
  • Live sessions with instructor
  • Completion certificate
  • Practice sessions
  • Compare this course with other

"