Google Sheets Bootcamp Boost Productivity And Efficiency

Conquer Spreadsheets: Automate Tasks and Analyze Data with Google Sheets

What you’ll 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

Requirements
Basic computer knowledge

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:Introduction, Workspace and InterfaceBasics to know about working in Google Spreadsheet- Part 1Basics to know about working in Google Spreadsheet- Part 2Fundamentals of using FormulaCalculating the percentage and locking the cellLocking rows, columns and rangesCell Referencing and Referencing to a Different Sheet- Part 1Cell Referencing and Referencing to a different sheet-Part 2Sorting Data by Number, Date and Multiple ColumnsLinking working data between sheetsAfter complete this class you will be able to- Easy Collaboration- Built in version Control- Working at Scale- Analyzing very large data sets- Connecting to External Data Sources- Connecting to the entire google workspaceThis 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.

Overview
Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Introduction, Workspace and Interface

Lecture 3 Basics to know about working in Google Spreadsheet

Lecture 4 Basics to know about working in Google Spreadsheet 2

Lecture 5 Fundamentals of Using Formula

Lecture 6 Calculating the percentage and locking the cell

Lecture 7 Locking Rows, Columns and Ranges

Lecture 8 Cell Referencing and Referencing to a different sheet part 1

Lecture 9 Cell Referencing and Referencing to a different sheet part 2

Lecture 10 Sorting Data by Number, Date and Multiple Columns

Lecture 11 Linking Working Data Between Sheets

Lecture 12 Class Project-1

Lecture 13 Class Project-2

Beginner who want to learn Google sheets