Google Sheets-Basic to Super Advance with Practical's(15hrs)
In-depth study of Functions, features and everything about G sheets
4.50 (54 reviews)
334
students
15.5 hours
content
Feb 2023
last update
$69.99
regular price
What you will 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
Screenshots
Related Topics
4440078
udemy ID
12/11/2021
course created date
12/19/2021
course indexed date
Bot
course submited by