Course Features
Interactive content to simplify complex concepts
Get certified
Get new updates periodically
Learn from anywhere at your convenient time
Learn at your own pace
Maximum content at minimum price
Course Overview
It's not just a course but a collection of experience of more than 7 years.
To cater you the best and most relevant content, every part is refined through several selection processes.
To the point approach is adopted to ensure you get maximum knowledge in minimum time.
Infographics are used to present the content in an extremely simplified approach.
Discussion forum to clear your doubts and nourish your learning.
Get access to more than 240 ready to use formulas.
Course Advantages
Become a Google Sheets super expert, stand out of the crowd and multiply your growth.
Access a variety of ready to use formulas, immediately apply them in your daily tasks and get instant coure results.
Learn advanced formulas to automate the most complicated tasks and save hours of your precious time.
Unique infographics presentations will ensure maximum knowledge in minimum time.
FAQs
All topics of Advanced Course
Use of brackets in formula 🔒 |
Cell reference with $ 🔒 |
ARRAY FORMULA 🔒 |
IF function 🔒 |
ISBLANK function 🔒 |
General comment for all functions 🔒 |
Combining multiple functions 🔒 |
IFERROR function 🔒 |
ISNUMBER function 🔒 |
ISERROR function 🔒 |
SEARCH function 🔒 |
FIND function 🔒 |
ROW & COLUMN function 🔒 |
GOOGLETRANSLATE function 🔒 |
TEXT function 🔒 |
TRANSPOSE function 🔒 |
Date related functions 🔒 |
TRIM function 🔒 |
SUBSTITUTE function 🔒 |
LEN function 🔒 |
LEFT/RIGHT/MID function 🔒 |
REGEXEXTRACT function 🔒 |
​REGEXMATCH function 🔒 |
REGEXREPLACE function 🔒 |
Merge text 🔒 |
SPLIT function - 11 topics covering different aspects of SPLIT function 🔒 |
Merge columns 🔒 |
Combine columns 🔒 |
Merge & combine columns 🔒 |
IF function with AND/OR 🔒 |
IF function with SEARCH 🔒 |
​UPPER/LOWER/PROPER function 🔒 |
SEQUENCE function 🔒 |
IFS function 🔒 |
SORT function 🔒 |
FILTER function 🔒 |
COUNT & COUNTA function 🔒 |
COUNTIF function 🔒 |
COUNTIFS function 🔒 |
UNIQUE function 🔒 |
ROUND/ROUNDUP/ROUNDDOWN function 🔒 |
INDEX function 🔒 |
MATCH function 🔒 |
MATCH function with FILTER 🔒 |
INDIRECT/TO_DATE function 🔒 |
Count words of a cell 🔒 |
SUMIF function - 11 topics covering different aspects of SUMIF function 🔒 |
SUMIFS function 🔒 |
VLOOKUP function - 16 topics covering different aspects of VLOOKUP function 🔒 |
LOOKUP function 🔒 |
Repeat one entry in multiple rows 🔒 |
QUERY function 🔒 |
QUERY to get data matching specific criteria of one sheet into another sheet 🔒 |
QUERY to get specific data of one sheet into another and change column heading 🔒 |
QUERY to get specific data from more than one sheet with common as well as different condition for each sheet 🔒 |
QUERY to apply calculations on columns and pull the result 🔒 |
QUERY to get unique values of a column and then to get sum for unique values 🔒 |
QUERY with checkbox in criteria 🔒 |
QUERY with "AND" as well as "OR" condition in criteria 🔒 |
QUERY with CONTAINS condition in criteria 🔒 |
QUERY with VLOOKUP 🔒 |
QUERY to get positive value as negative with conditions 🔒 |
QUERY to get sum of one or more columns with conditions 🔒 |
QUERY to merge two columns with conditions 🔒 |
QUERY to get customised range from multiple sheets 🔒 |
QUERY with COUNTA function 🔒 |
ARRAY_CONSTRAIN 🔒 |
SORT with ROW function 🔒 |
SORTN function 🔒 |
Get last value (similar to VLOOKUP but get last value) 🔒 |
Auto generate serial number 🔒 |
JOIN & TEXTJOIN function 🔒 |
​Name a range concept 🔒 |
IMPORTRANGE function - Import real time data from one spreadsheet to another🔒 |
IMPORTRANGE with dynamic reference 🔒 |
IMPORTRANGE all/specific columns with specific conditions 🔒 |
Import and change the heading 🔒 |
Import and sort the data 🔒 |
Import and product of two columns 🔒 |
Import data from multiple sheets with common condition 🔒 |
Import from multiple spreadsheets with different conditions for each sheet 🔒 |
Import from multiple spreadsheets with different conditions for each sheet and common condition for both the sheets 🔒 |
Import from multiple spreadsheets with different conditions for each sheet with AND/OR criteria in condition and common condition for both the sheets 🔒 |
Import unique values (single spreadsheet and multiple spreadsheets) 🔒 |
IMPORTRANGE function with TRANSPOSE (row to column and column to row) 🔒 |
IMPORTRANGE with VLOOKUP 🔒 |
IMPORTRANGE with SUMIF 🔒 |
IMPORTRANGE with SUMIF & VLOOKUP 🔒 |
IMPORTRANGE to create dropdown list in cell from different spreadsheet 🔒 |
Import and get sum of column 🔒 |
Add prefix or suffix to numbers 🔒 |
Conditional formatting 🔒 |
Data validation 🔒 |
Course Content
Reviews From Our Learners
Vaishnavi Parmar
"This is great and extremely valuable knowledge for making software. This course is very detailed and easily understandable. With the help of this knowledge we can easily make could based tools using Google Sheets with security of Google, which is very difficult to make with other programing languages. Many thanks for the quality of your efforts!"
