Tutorialspoint

Working with Google Sheets

Learn the most useful functions in Google Sheets

Course Description

I have worked in both small and large organizations and have found that excel is the basic tool that is used starting from the CEO to the fresher joining the company. I had done courses on excel multiple times but due to the large number of functions covered in those courses, I would end up forgetting the formula. Through this course, I have tried to minimize the content and have covered the functions that are most used in organizations for creating trackers, dashboards, and analyzing the data.

The course is 1.5 hours long. I have added downloadable resources, exercises, quizzes, and a project to make the learning experience better.

The course has four sections covering the following topics:

1. Basics: How to create a spreadsheet. Understanding basic formula such as count, sum, countifs, sumifs, etc.

2. The most used functions such as vlookup, left, right, pivot tables, etc.

3. Advanced functions such as importrange, filter, sort, etc.

4. Extra Tips: A few shortcuts and features that are frequently used.

After finishing this course you will have the skills to use spreadsheets with confidence.

Hope you will find the course useful. If you want more lectures to be added to the course, feel free to connect.

Goals

  • Managing a Google Sheets
  • Creating Dashboards
  • Data Analysis
  • Connecting Various Sheets
  • Creating different views

Prerequisites

  • Laptop
  • Internet Connection
Show More

Curriculum

  • Introduction - Course Curriculum
  • How to create a Google Sheet
    03:33
    Preview
  • SUM, COUNT, COUNTA
    02:43
  • SUMIFS
    04:04
  • COUNTIFS
    02:57
  • Countunique
    01:49
  • SUMPRODUCT
    01:28
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Working with Google Sheets
This Course Includes
  • 1 hours
  • 21 Lectures
  • 2 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate