• Post category:StudyBullet-16
  • Reading time:5 mins read


Conquer Spreadsheets: Automate Tasks and Analyze Data with Google Sheets

What you will learn

Introduction, Workspace and Interface

Basics to know about working in Google Spreadsheet

Fundamentals of using Formula

Calculating the percentage and locking the cell

Locking rows, columns and ranges

Cell Referencing and Referencing to a Different Sheet

Sorting Data by Number, Date and Multiple Columns

Linking working data between sheets

Description

Hello everyone welcome to our class of Google Sheet for learning data management and data storage easily so if you are planning to learn data management and data storage from a beginner level to an advanced level than you are in right place because we will cover from basic to advanced. This is a beginner level class so if you have no previous experience than also you can join our class.

Lets take a look what you will learn from this class:

  1. Introduction, Workspace and Interface
  2. Basics to know about working in Google Spreadsheet- Part 1
  3. Basics to know about working in Google Spreadsheet- Part 2
  4. Fundamentals of using Formula
  5. Calculating the percentage and locking the cell
  6. Locking rows, columns and ranges
  7. Cell Referencing and Referencing to a Different Sheet- Part 1
  8. Cell Referencing and Referencing to a different sheet-Part 2
  9. Sorting Data by Number, Date and Multiple Columns
  10. Linking working data between sheets

After complete this class you will be able to

Easy Collaboration

Built in version Control

Working at Scale


Get Instant Notification of New Courses on our Telegram channel.


Analyzing very large data sets

Connecting to External Data Sources

Connecting to the entire google workspace

This is a project based class so during learning you will have class project so what you learned you will be able to participate in class project so you can do practice while you are learning. You will have supporting resource in this class so it will be easier for you to learn.

During learning if you face any issue or if you have any question than feel free to ask me I am always there for you to help you. So lets start Google Spreadsheet for learning data management together.

English
language

Content

Introduction

Introduction
Introduction, Workspace and Interface
Basics to know about working in Google Spreadsheet
Basics to know about working in Google Spreadsheet 2
Fundamentals of Using Formula
Calculating the percentage and locking the cell
Locking Rows, Columns and Ranges
Cell Referencing and Referencing to a different sheet part 1
Cell Referencing and Referencing to a different sheet part 2
Sorting Data by Number, Date and Multiple Columns
Linking Working Data Between Sheets
Class Project-1
Class Project-2