Overview

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 dataHow to insert sheets, delete , rename sheets, protect the dataHow to create duplicate copies of sheets or google sheet as a wholeHow to share sheets with other colleagues in officeHow to set up the language based on your countryHow to use Filter Views Learn Sort and filter functions.How to lookup the data using VLOOKUP , MATCH , TRIM and INDEX functionsHow to join more than one function and make a single large complex formulaHow to use LARGE, SMALL function with other functions like FILTER and SORTHow to use logical functions like IF, IFAND, IFOR and new function IFS with the difference between themHow to use Error handlers like IFERROR & IFISERROR. - Use them with other lookup functionsHow to use VLOOKUP inside VLOOKUP and infact more than 3 VLOOKUPs in one formulaKnow your Date and Time functionsHow to use INDIRECT Function - the most amazing and helpful function in sheetsHow to define Name range and their practical use in G sheetsHow to create drop down and dynamic drop down - two or three level dynamic drop down with the help of INDEX and FILTERHow to restrict data from entering anything you do not want by using data validation featuresPractical Quizzes time to time to monitor your preferenceHow 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 SLICERSHow 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 sheetsHow to work with websites to import their data into sheets. Webscraping without any programming. IMPORTXML/HTMLLast 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

Skills

Reviews