Google Sheets-Basic to Super Advance with Practical’s(15hrs)

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

Created by: ajay parmar
Instructor -Excel,Vba ,Access, Access Vba,BI,PQ,G SHEETS

What Will I Learn?

• This course as on date has 14 Sections - A complete training on G sheets
• 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
• How to use Query function and retrieve data like a pro using Select SQL Synatax
• How to do WebScraping using Google Functions ImportXML, ImportHTML - Its amazing

Requirements

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

Target audience

• 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.