Udemy

Platform

English

Language

Google

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)

Getting to know Google Sheets

Students

1.5 hours

Content

Aug 2021

Last Update
Regular Price


What you will learn

From what a spreadsheet is to linking multiple spreadsheets and creating dashboards

Basics of Google Spreadsheets

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

How to create a spreadsheet

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

Advanced Functions

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.


3535442

Udemy ID

9/29/2020

Course created date

4/6/2021

Course Indexed date
Bot
Course Submitted by