Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Becoming a Google Sheet Wizard

person icon Kunal Ahuja

4

Becoming a Google Sheet Wizard

Learn why It's better than Microsoft EXCEL and become an Expert in 3 Hours

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Kunal Ahuja

category icon Google Sheets,Office Productivity,Google Tools

Lectures -43

Duration -2.5 hours

4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

The two most analytical software where a person learns to get a feel about data is "Microsoft Excel" and "Google Sheets". These two might be complex but they help you start learning about how you can play with and visualize data in a BETTER form.

Time to sit into my rocket ship for the next 3 hrs. and I will open up that analytical space for you.

You will get to learn : -

1) Introduction - This section contain information about the Course and Data Table which we will use throughout the course.

2) Google Sheets Basics - This will be for the beginners who have never touched Google Sheets this will give you information about the basic terminologies and data management.

3) Google Sheets Intermediate - In this section you will learn how to use conditional formatting, pivot tables and the BEST intermediate level functions.

4) Google Sheets Advanced - This section covers some high level functions which will be used in google sheet automation.

5) Mastering Automation - This section will be the final automation level you need to achieve before setting your foot into the data world and will help you in summing up everything you have learned with the help of 3 Problem Statements.

Goals

What will you learn in this course:

  • This course is for people who want to become an expert in understanding data and want to learn analytical skills. 
  • This is totally going to open your mind up and will lead you to understand the most underrated tool - Google Sheets and Microsoft Excel.
  •  Basics of Google Sheets
  • Intermediate level of Google Sheets
  •  Advanced level of Google Sheets
  • Clubbing everything together - Advance level automation (Reason why you never needed to learn scripting)

Prerequisites

What are the prerequisites for this course?

  • No google sheets or excel knowledge needed you will learn everything from the basics to the high level automation on the go.
Becoming a Google Sheet Wizard

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
2 Lectures
  • play icon Mentor Introduction 00:41 00:41
  • play icon Course and Data Table Introduction Updated 02:44 02:44
Google Sheets Basics
7 Lectures
Tutorialspoint
Google Sheets Intermediate
11 Lectures
Tutorialspoint
Google Sheets Advanced
17 Lectures
Tutorialspoint
Mastering Automation (Putting it All Together)
6 Lectures
Tutorialspoint

Instructor Details

Kunal Ahuja

Kunal Ahuja

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515