Master in Spreadsheet

Namaste dosto, detailed explanation of array-formula in excel is now available on YouTube channel. You can watch the video and understand the concept. Please share your queries in comment section.

Array-formula in detailed in excel In this video, we will learn details of array-formula. What is array and what exactly array-formula do? What are types of result we can expect from array-for...

Namaste dosto, This is further video of our MailApp project in apps script. Do watch video and share your valuable feedback to us.

MailApp project - creating custom messages After completing basic concepts, we will move to practical application of Google apps script. First we will learn about MailApp. It is second video of the se...

Hello everyone, I hope you are doing well in current situation and all your family members are alright.
I want to inform you guys that we can use this page to solve google sheets, excel and app script problems.

You can post your problem here and our page community will try to answer it. This way we can help one another.

Thank you.

Namaste dosto, further in apps script series, after completing major theory - now we are heading towards its practical applications. Our video on how to send mail from apps script.

MailApp Introduction in Google Apps script After completing basic concepts, we will move to practical application of Google apps script. First we will learn about MailApp. In this video, we will have ...

Namaste dosto, new video on objects datatype in google apps script is out on youtube. Do watch video and share your valuable feedback in comment section.

Object Introduction in Google Apps script In this video, we will learn about object datatype in apps script. what is object and how we can use it?Objects are similar datatype to maps where we are sto...

Namaste dosto,
After long time, new video on lookup using apps script is uploaded.
Request to share your valuable feedback in comment section.

Lookup using for loop in Apps script In this video, we will learn about how to perform lookup from data range for particular value. This process will increase our confidence in array and for loo...

Namaste dosto, new video on while and foreach loop is out on YouTube in apps script series. Do watch video and share your valuable feedback in comment section.

While and forEach loop in Apps script In this video, we will learn about while and forEach loop in apps script. These loops are often used instead of for loop to reduce code length.To view, code ...

Namaste dosto, new video on Loop in apps script is out on YouTube. You can watch the video and share your valuable feedback in comment section.

Loops in Google Apps script In this video, we will understand what is loop in programming language and how it can be useful to us in reducing our code length and building logic. In this...

Namaste dosto, New video on lookup function in google sheets is out on YouTube. Do watch video and share your valuable feedback in comment section.

Lookup in Google sheets This is very specific video on lookup function in google sheets. In this video we will learn about on a real life database how can we search through particul...

Namaste dosto, new video in Apps Script series on function is out on YouTube. Do check video and let us know how it can be useful to you.

Fahrenheit to Celsius using Google Apps Script This is the further video to function in google apps script. In this video we have show one example of function - how to convert temperature from Fahrenheit ...

Namaste dosto, new video in Google Apps script series is out on YouTube. Video is about functions. Do watch and share your valuable feedback in comment section.

Function Introduction in Apps script - YouTube In this video, I have explained solution of last problem and then brief introduction of function in apps script. Function is code of block which we want to repe...