Master in Spreadsheet

14/08/2021

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.

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...

30/05/2021

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

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...

26/05/2021

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.

08/03/2021

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.

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 ...

23/01/2021

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.

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...

03/01/2021

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

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...

06/12/2020

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.

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 ...

28/11/2020

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.

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...

21/11/2020

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.

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...

07/11/2020

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.

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 ...

03/11/2020

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.

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...