Google Sheets Bootcamp Boost Productivity And Efficiency

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
Homepage