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
www.google.com/sheets/about/
Website:
www.chicagocomputerclasses.com/
Пікірлер: 343
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.
@ExcelGoogleSheets
2 жыл бұрын
👍
@jd5787
5 ай бұрын
Hi! How do all these system work together? You export right? These videos are still up to date?
@Jeff-fc7nf
5 ай бұрын
@@jd5787 At my work, a small company, each department has their own spreadsheet for which they input data that relates to a different department. For example we have a sheet for sales order, which have customer data about the order and destination, which some is relevant to our shipment department, to which they add shipping details, which become relevant to the customer service section, all these can be simply tied in via VLOOKUP functions so that data input by one department on their sheet is updated on a different departments sheet. That was one of the first basic implementations I took from this channel. You just look at a task that someone does repetitively and then use these functions to automate that task. Before you know it, you have 10 different things automated.
Teaching everyone in a simple and understandable way is not that easy. You made it. Really really helpful. Thank you so much.
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.
@georgenicholsoniii9781
6 жыл бұрын
I agree 100%. You are a talented educator. I find your conversational style conducive to learning. Don't change anything, it's perfect. Thank you!
never in my life did I think I'd be "advanced" enough in coding to need to learn this.
Thank you for seeing the need and creating these tutorials.
Great basic introduction, covered things that other "basic" tutorials failed to.
Absolutely the best teacher for novices in programming.
Muito Obrigado, por estar compartilhando esses tutoriais de excelente qualidade! Thank you so much for sharing these excellent quality tutorials!
I needed this so much. Thank you for doing this.
Very clear video! Thanks for taking time to explain deeply !
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!
thank you so much for sharing this!, your tutorials are really helping me in my job...
Great Tutorial, you really helped me start using scripts in google spreadsheet.
"I probably forget what I was doing". I love this. If it also happens to you, I feel so much relief.
@ExcelGoogleSheets
4 жыл бұрын
That's how it is :)
Great teacher! This has helped me a ton. Keep the videos coming...
Thanks for the video ! Very clear. You helped me write my first script ever.
hope you do some more on this (app scripts) as one, there isn't loads on KZread and two your content is really good 👍
Thank you for this video! Exactly what I wanted :)
Please do not change your way of teaching. Excellent video.
Your videos are incredible! thank you!
Really great video - thank-you for taking the time to make it. Much appreciated.
Excellent.. playing at 1.25x speed works well
@johnwaas4864
3 жыл бұрын
*2x lol
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
The best programming videos, really thanks
This video was super helpful. Thanks for posting!!
Great way of teaching. Great job. Please post more.
Awesome! You are a great teacher, Thanks!
Very good tutorial! Thank you!
Very easy to follow, step by step instructions. THX
Love the way you teach keep it up
this is really really really really great! thank you! you are the best! make more videos please!!!
Awesome tutorial !
Thank you so MUCH! was great!
Awesome instruction! Thank you. Perfect level of detail for my knowledge level.
Beautiful!
Great as usual. Thanks
Amazing content! Thanks for the video
Today I find something very interesting about google. This is something I want. :)
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!
@ExcelGoogleSheets
2 жыл бұрын
👍
Thank you so much! Excelent job!
Absolutely fantastic tutorials. The API guide was getting me nowhere. Thank you so much for creating these!
@ExcelGoogleSheets
2 жыл бұрын
👍
Great Vid! Thanks!
Hi thanks for this serious stuff ! great !!!
High quality stuff, thanks =)
Mister, you are awesome, thanks for your videos!
Man this is great !
bro.. u r the best teacher!!! pls i want more about programming
Really cool video and informative, I would have wanted it a bit faster, although I understand that this might also be for people that are not familiar with programming :)
You teach very clearly and logically like Sal Khan of Khan Academy. Kudos!
Awesome video tutorial. Very useful!
Excellent tutorials
Nice explaining man, thx u
well explained, awesome
Excellent!
Super tutorial, thanks
It’s very useful for me . Thank you so much
Excellent Man this is first time I m seeing this video tutorial its so amazing and easy to follow tutorial...God Bless You Brother !!...
very very helpful. thank you!!! 👍💚
thankyou for making this tutorial!
thank you very much bro. my works now need this app script. this basic really helped me. from Indonesia here.
You're tutorials are GREAT, thank you. This might need a little update as Macros can now be recorded in sheets.
@ExcelGoogleSheets
4 жыл бұрын
I have a video on macro recording on the channel, but it's not the same as writing code.
Awesome tutorial
Excellent intro!
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
Thank you for a detailed explanation
Thank you so much.
Very good videos! I hope you will make a video using filter function in app script editor. (multiple values)
Great explained
Thankyou so much for this video. Its helps me alot.
I can see the benefits of learning app scripts and you are helping me alot. Many thanks. I'm having a problem trying to send a google sheet to collaborators that have the rights to edit and share. The basic form goes through OK but the inputs both from data validations, input numbers are not showing up for collaborators when I run the script. I email it to others and to myself as a copy (delete the URL from Edit to Copy). I see all the info but the other collaborators only see the form layout with no inputs. It is a time card and my intent is to have the accountant just copy info then past into master sheet. From there it updates everything including charts, Pivot tables...lots of information breakdowns for government grants/audits. Maybe this would be a good tutorial? Being able to send data that is not a PDF so that only do a once copy and paste action would cut down lots of time. Again, many thanks and I'm retired helping out as a volunteer for a non-profit.
thank you very much. you do a great job!
@ExcelGoogleSheets
4 жыл бұрын
Thank you too!
Thank you for your sharing!
Excelente!!!!!!!
Thanks good sir!
Love the vids, Keep it up! Subbed so fass. Hope you hit us with some google sheets and redash integration.
Very fine. Thank you.
great!!!
thanks a lot!
Thank you man
Thank you so fing much
Excellent. You Deserved.
Excellent info. I see it awesomely presented because it gave me a decent start. Thank you sir for your efforts.
@ExcelGoogleSheets
2 жыл бұрын
Great to hear!
very helpful 🙂
Good video, this guy is best on youtube for google sheets. He should start a Udemy course thats super in-depth
@johnn4314
6 жыл бұрын
not that this isn't perfect. but you could make money for these
感謝製作此系列影片👍
@ExcelGoogleSheets
Жыл бұрын
👍
Hello Teacher could you please make a video about how to measure time execution of an script and how to optimuze the script according to google limit ?thank you for all your videos are very usefull
Nice Video
Thank you very much . i have small problem and hope learn me how solve it i want copy data from cell in sheet1 to another cell in sheet 2 (i make an invoice form )
thank you so much
ThanQ alot 😁
If you upload this to Udemy I will pay for it (if its less then $15 bucks). I don't have access to youtube at work and I would like to have guaranteed on demand use of this content. Either way thanks for posting this. It's really helpful. I payed for other content on Udemy but was disappointed. So far this is free and it's the best.
It wont let me run, it says i need to review permissions, but when I sign in, it says "this app isn't verified"
Is there a way to have a data validation in a cell only if the previous cell fullfill certain set criteria or say data validation with 2 criteria (range and custom formula) Thanks
Hi Sir, the function getActiveSheet doesn't seem to work with my AppScript. Even when I select Sheet2 to become the active sheet, the result still comes out at Sheet1. What possible causes are there for this?
Hi Nice videos its really very helpful for me... Can you put a video how to write a script to pull the records and copy it to the spreadsheet from bigquery?
really appreciate your tutorials. This one is getting me. I am trying to do it alongside you, and despite doing exactly the same thing, the script isn't working at all and I don't know why. Edit: So, for some reason I had to change the title of the script from my function to something else.
@ExcelGoogleSheets
2 жыл бұрын
:)
Now that a version of TensorFlow available in JS , can it be used in Google Spreadsheets scripts?
How can I get that function Prediction box you have?
Thank you! Any video on how to add something to the ACTIVE CELL?
Thank you