Скачать или смотреть Excel Office Script for Beginners - Part 2 of 3: Manipulate Cells With Office Script

Yes, converting years of Excel VBA experience to a new programming language can be tough. I know – I’ve been working at it for 2-3 years! There is some good news, however - some VBA constructs are closely replicated in Excel Office Script. There’s even a method very close to the VBA offset function. And, as in desktop Excel, it helps us create magic in Excel spreadsheets.

💻FREE DOWNLOAD: Excel Office Script For Beginners Cheatsheet
https://tinyurl.com/p36f4t23

NOTE: downloading the cheatsheet adds your email to our marketing email list which sends new videos to your inbox when they are released - you can unsubscribe from this anytime

In this video, I demonstrate the basics of cell manipulation in online Excel using Excel Office Script, from absolute beginner level. We cover how to ‘get’ and ‘set’ values in cells with just a single line of code. You’ll be retrieving values from, and writing values to, online spreadsheets in no time!

But there’s more. The video also covers Excel Office Script’s equivalent of the VBA offset method – an absolute favourite of the channel. We talk through how to get the offset equivalent function working for you in Excel online. The video includes some cool examples you’ll love, but don’t stop there! Remember, practice is everything and these examples should only be a starting point. Don’t forget to report your ‘punch-the-air’ moments in the video comments …

Don’t miss our Excel Office Script beginner Cheatsheet, the companion PDF for this series, downloadable for free via the link. I’ve been trying to learn Office Script myself over the past few years and have not found a good beginner resource. So, I’ve collated the essential information I wish I had at my fingertips when I got started – and it’s available for free for you to download and reference.

💻IS OFFICE SCRIPT INCLUDED IN YOUR OFFICE 365 PLAN?
https://tinyurl.com/4xmh8jy8
💻FIRST VIDEO IN OFFICE SCRIPT FOR BEGINNERS SERIES
   • Excel Office Script for Beginners - Part 1...  
💻PLAYLIST: EXCEL OFFICE SCRIPT FOR BEGINNERS
   • Excel Office Script For Beginners (AND VBA...  
💻VBA EQUIVALENT OF THIS SERIES (ONE MILLION+ VIEWS)
   • Excel Visual Basic (VBA) for Beginners - P...