Google Sheets - Basic to Super Advance with Practical's

In-depth study of Functions, features and everything about G sheets

What you'll learn
You will learn everything about Google SHEETS- What are the fundamentals and how it is different from Microsoft Excel application
You will learn Basic, intermediate and advance functions like sum, average, count, sumif,sumifs, countif,countifs,indirect, offset, vlookup,match,hlookup
You will learn text functions from basic to advance including their practical use -Left, Right, Mid, Find,Search,Substitute,Split ,concatenate and Join function
How to share the sheets with others - how to provide read only or read-write rights.
You will be able to do simple, complex data structuring and analayis using Features like Filter, Sorting the data and filter views.
How to use SORT , UNIQUE functions with Filter .
How to use Data Validations, Data Importing, CHARTS, Conditional Formatting, PIVOTS, Date and Time functions
There are quizzes included in the course time to time to help you in getting ready for real data challenges.
How to use one function inside another function and create a long ,complex formulas like vlookup with match function , Index with match functions
How to use mix Text functions with index or vlookups. How to use CountIFs function with lookup functions and any type of combination you can think of.
Create surveys for team and collect data via google forms and take your data analysis onto a new level

Requirements
You need to have internet and gmail id . Nothing else is required.

Description
This course will educate you about how to work with Google sheets.

How to begin with Google sheets - from installing to using it.

How to use features like Cut paste, copy paste, insert rows, insert columns, sort data ,filter data

How to insert sheets, delete , rename sheets, protect the data

How to create duplicate copies of sheets or google sheet as a whole

How to share sheets with other colleagues in office

How to set up the language based on your country

How to use Filter Views

Learn Sort and filter functions.

How to lookup the data using VLOOKUP , MATCH , TRIM and INDEX functions

How to join more than one function and make a single large complex formula

How to use LARGE, SMALL function with other functions like FILTER and SORT

How to use logical functions like IF, IFAND, IFOR and new function IFS with the difference between them

How to use Error handlers like IFERROR & IFISERROR. - Use them with other lookup functions

How to use VLOOKUP inside VLOOKUP and infact more than 3 VLOOKUPs in one formula

Know your Date and Time functions

How to use INDIRECT Function - the most amazing and helpful function in sheets

How to define Name range and their practical use in G sheets

How to create drop down and dynamic drop down - two or three level dynamic drop down with the help of INDEX and FILTER

How to restrict data from entering anything you do not want by using data validation features

Practical Quizzes time to time to monitor your preference

How to do data analysis using Charts - Basic to advance - column chart, line chart, pie , doughnut chart, combo chart, scorecard chart, table chart etc.

How to control data using SLICERS

How to summarize data using Pivots and Slicers

Create an Awesome Dashboard which uses above all functions and features.

How to use SQL Query in Google sheets

How to work with websites to import their data into sheets

Last but not least, there are so many projects for your help to understand how all of this knowledge is used in Google sheets.

24*7 Support is available to answer your queries

Who this course is for
Students who work with data all the day and create reports and do the analysis on different levels.
Google Sheet is now emerging as a favorite spreadsheet among Data analysts and because it is a free spreadsheet and can update online , it is much in demand than ever before.