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
What will you learn in this course:
- Managing a Google Sheets
- Creating Dashboards
- Data Analysis
- Connecting Various Sheets
- Creating different views
Prerequisites
What are the prerequisites for this course?
- Laptop
- Internet Connection

Curriculum
Check out the detailed breakdown of what’s inside the course
Getting Started
7 Lectures
-
Introduction - Course Curriculum
-
How to create a Google Sheet 03:33 03:33
-
SUM, COUNT, COUNTA 02:43 02:43
-
SUMIFS 04:04 04:04
-
COUNTIFS 02:57 02:57
-
Countunique 01:49 01:49
-
SUMPRODUCT 01:28 01:28
Must Know Functions
5 Lectures

Advanced Functions
4 Lectures

Extra Tips
5 Lectures

Instructor Details

Soniya
Data Analyst | Project ManagerI have studied engineering, management, and leadership. I have worked on data analysis, visualization, project management, and creating cross-functional processes using Google Sheets. I am detail-oriented and data-driven. Reading facts, books, cycling, and watching movies are some of my hobbies. I believe in being the change that one wants to see in the world. Trying to become a better human every day!
Course Certificate
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now