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

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

• 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

  
  

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

Url: View Details

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

Rating: 4.45

Level: All Levels

Duration: 15.5 hours

Instructor: ajay parmar