App Script Editor Tutorial - Google Sheets - Excel VBA Equivalent - Read & Write to Ranges & Cells

Video tutorial series about Apps Script (JavaScript) in Google Sheets (Excel VBA Equivalent).

In this tutorial we'll cover how to work with script editor, main spreadsheet app structure, how to write to a cell or a range & how to read information from a cell using Google Sheets Scripts.

Google Sheets

Website:

[Jeff-fcnf]

For 9 years I have been coming back to your videos. I have been able to produce highly integrated spreadsheet system at my company, connecting inventory, shipping schedules, orders, and more from multiple departments. Completely eliminating a lot of copy paste data input, and employees needing to travel to various spreadsheets and tabs to get resources and info they are looking for. I am starting to actually learn to code, the base level understanding of how functions, work on spreadsheets really provided a good foundation for understanding logical operators and function structure, that I learned from your many other series.

Now I am back again to learn from you how to apply scripts to spreadsheets, because thats what I am familiar with, in order to supplement my JavaScript learning.

[yazhisaiveandan]

Teaching everyone in a simple and understandable way is not that easy. You made it. Really really helpful. Thank you so much.

[benedictpaul]

You have a God given talent to teach. Please continue your service like this. Someone has commented to plan your videos a bit better just because it took 7+ minutes to start writing the code. But, I feel that your way of starting from scratch is what we want and the casual way of explaining makes me feel like I'm in a regular lecture room.

[alwayssip]

never in my life did I think I'd be "advanced" enough in coding to need to learn this.

[mercuriocadena]

"I probably forget what I was doing". I love this. If it also happens to you, I feel so much relief.

[CarlosGomes-murc]

Please do not change your way of teaching. Excellent video.

[ДмитрийПаравин]

Absolutely the best teacher for novices in programming.

[ernest]

Absolutely fantastic tutorials. The API guide was getting me nowhere. Thank you so much for creating these!

[GoodLife-rudi]

You teach very clearly and logically like Sal Khan of Khan Academy. Kudos!

[athaliaw]

Thank you for seeing the need and creating these tutorials.

[ZebaNaqvi]

Excellent.. playing at 1.25x speed works well

[MohammadaAprilianto]

thank you very much bro. my works now need this app script. this basic really helped me. from Indonesia here.

[ryandick]

Great basic introduction, covered things that other "basic" tutorials failed to.

[danilomontuanartesp]

thank you so much. I am brasilian, it's too hard to find a tutorial to begin in Goggle Sheet Script around here. Even it being a different and technicall linguage i has understood a lot and help me so much. Thanks again

[cheryll]

Hey there, this is a great tutorial for beginners. I was looking for something step by step for months now & this is perfect! Thank you so much!

[shahrizuanosman]

bro.. u r the best teacher!!! pls i want more about programming

[kara]

OMG!!! this is gold! Thank you so much for sharing your knowledge with us! And the tutorial is very understandable! Wish you all the best in life!

[datascientist]

Excellent Man this is first time I m seeing this video tutorial its so amazing and easy to follow tutorial...God Bless You Brother !!...

[jeffstokes]

You're tutorials are GREAT, thank you. This might need a little update as Macros can now be recorded in sheets.

[alisonorton]

This video was super helpful. Thanks for posting!!