Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
15 Hour(s) 37 Minute(s)
Language
English
Taught by
ajay parmar
Rating
Course Overview
In-depth study of Functions, features and everything about G sheets
This course will educate you about how to work with Google sheets. It has 14 sections as on date covering every minute detail about 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. Webscraping without any programming. IMPORTXML/HTML
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
Course Content
- 10 section(s)
- 69 lecture(s)
- Section 1 Introduction to Google Sheet Environment
- Section 2 Your LOOKUP Functions- Forward and Reverse
- Section 3 Logical Functions - IF & New IFS function - Basic to Advance
- Section 4 Error Handlers - Ignore errors and do meaningful things
- Section 5 TEXT Functions - Helps in Data Extraction, replacements and Finding values
- Section 6 Sort and Filters - Useful for Data Reporting
- Section 7 Name Ranges & Data Validation - Data Control and Data Restrictions
- Section 8 Count & Sum Family Functions - Complex Calculations made Easy
- Section 9 CHARTS - A wonderful way to visualize your Data
- Section 10 Excellent PIVOTS- Create Dashboards and Summaries of reports
What You’ll 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
Skills covered in this course
Reviews
-
JJoy Marie Angeles
Ajay is very detailed with his teaching content Whenever I need more in-depth understanding about a tool, he's one of the teachers here in Udemy I always check Now I am more confident with my Google Sheet skills - I would say that after taking this course, I got better with Sheet Fundamentals and how to be more creative using nested functions to solve more complex world business requirements More power Ajay! I hope you release App Script, App Sheet, and Looker too
-
RR M Naikar
It is Good
-
PProsenjit Shaw
One of the Knowledgeable teacher on Udemy Platform . Always try to give best of best for his student. Great mentor with course .. He always start from scratch and end his courses to pro level always ready to add new chapters for his students and ready to clear your doubts . My favourite teachers for Excel , Power Bi , Google sheets , Python just bcz Sir ji always try to clear your doubts in every ways with simple ecplanations..
-
OOprea Teodora
This is a good choice if you want to form a good understanding of the basics (but not only that). It has practical tasks for the students to test their knowledge and creativity. The pace is similar to that of a lecture, but this being a recorded format, you can always pause and take notes or do the tasks yourself. The instructor is supportive and tried his best to anticipate questions or possible mistakes that beginners make.
