Language

Category

# Getting to know Google Sheets

## Through this course, the formula that are most useful in organizations for excel, can be learnt.

4.70 (20 reviews)

Students

Content

Last Update
Regular Price

## What you will learn

Counting unique values, and basic calculations

Advanced commands such as importrange, sort, FILTER, merging multiple sheets into one

Pivot Table

Vlookup

iferror

Advanced functions such as FILTER, IMPORTRANGE, QUERY, and many more

## 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.

See you in the course!

## Content

Getting Started

Introduction - Course Curriculum

SUM, COUNT, COUNTA

SUMIFS

SUMIFS - Quiz

COUNTIFS

COUNTIFS - QUIZ

COUNTUNIQUE

SUMPRODUCT

Section1 - Quiz

Must know functions

Useful Functions - Part 1

Useful Functions - Part 2

Useful functions - Quiz

QUERY

Project 1: Creating a dashboard - Description

Project 1: Creating a dashboard - Solution

Pivot tables

vlookup and iferror

If else

Data validation and Dropdown

Conditional Formatting

IMPORTRANGE

FILTER

FILTER - Quiz

SORT

Merging two tabs' data into one

Extra Tips

Freezing rows and columns

Sharing a sheet with others

Cell and Sheet protection

Checking Sheet/Cell history

Useful shortcuts

Quiz

## Reviews

H
Harshita3 April 2021

This course accurately addresses the workplace demands regarding spreadsheet. The way the concepts have been explained is very crystal clear and the basics have been explained really well. I found this course very helpful.

Udemy ID

## 9/29/2020

Course created date

## 4/6/2021

Course Indexed date
Bot
Course Submitted by