🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Since we are working everyday it excel, maybe you can showcase power automate or power automate desktop on how to build flows to copy data from one excel to another, delete row/columns update pivots, save and send via email as attachment. That will be amazing
Great video Kevin. Never heard of this word Office Scripts but you've now explained Office scripts are useful to automate your day-to-day tasks and how it works. Thanks Kevin 😀
Hi Kevin, your video are very interesting with simple and to the point explanation. Thank you for your video which help us to understand this excel with interest.
Hi Kevin. This is great!!! I'd love it if you would do videos showcasing more advanced applications of Power Automate and Office Scripts. Thanks so much!
great stuff Kevin! one thing i must say is that you got really good voice to deliver the training. normally i cannot bear any vid over 15 min, but this 25 min, it felt pretty short. if you got any courses available in udemy or elsewhere, please let me know. thanks.
Hi Kevin, thanks for sharing this video. Can you please advise how to look up data in the active worksheet from another worksheet and how to put in the flow.
Hi @Kevin! Thank you very much for a great video! I plan to use this at work :-). Can you pls show how can we change a range. For example you bolded the first column A4:A9. If my range changes everyday, how can I say rage A2: A “end”of the row? Thanks a lot and you are the best! Cheers, E.
Great Video. I need to use Power Automate calling an Officescript that would pivot a dynamic table. The Original table created by PowerAutomate has Year-weeks on the rows and sme Student info ( attendance) on the columns. I need to pivot the table, so that the Year-weeks ( changing every year) are columns and the rows are Student plus attendance. I have implemented this scenario using SSIS Packages and also calling a Script but now I am converting the SSIS package to a PowerAutomate flow using cloud data. Do you have a video or an example over how to achieve this? Thanks
Great video, Kevin! Thank you very much! As someone that has several repetitive monthly reports to do, I've been seeking a way to automate them for a long time. I've developed a lot of macros to help with automation, but was unfamiliar with Scripts until this video. My question is how to use both macros and scripts to completely automate this process.
Hey Kevin, I would like to thank you first for all your videos, tutorials and all helpful stuff your are sharing. May i do a request? I m trying to send PDF files to one email address. I would like to use Power Automate or mailmerge. I followed your helpful tutorial (how to send mails with attachment with mailmerge) with succes! Do you have any suggestions how to do this? The title of the mails is the name of the pdf file, there has to be no Body text, maybe just the word archive on the titel as prefex for each mail. Thanks in advance! Keep the good work Greetings Simo
Great video and it could help with some of our processes. But our organization has a mix of Business Premium and Business Basic accounts. Only the Business Premium accounts have access to automate in Excel. If a Premium user creates a script for a spreadsheet and shares it with a Basic user with full edit permissions, would the Basic user be able to run the scripts?
Same question here. Got any info about this already? In my team we all have basic 365 so we are wondering if upgrading just one license to make scripts will allow other users with access to the workbook to run them (for example, making a button that registers data from a userform into a database so that every member in the team can use it). Thanks!
Nice basic presentation. I would like to know what I can't do with Office Scripts compared to VBA on the desktop. For example, can I clear filters when a user exits from Excel?
Great video and very easy to follow. ExcelScript seem to have lots of capability working inside a workbook. I need to export/print/save the first worksheet to a PDF. Does ExcelScript's capabilities extend to file handling?
Great tutorial! I am getting an error of 'The file format is not recognized. Please check that the selected workbook is valid. clientRequestId: d2ded74b-3b89-4ebc-a5dc-b3cdde83738e.' The Excel file is .xlsx saved in the correct SP library. When running the script outside of Power Automate, works perfectly well. Thanks!
Hi Kevin.. Thank you for the above guide, I want to merge multiple excel files existing in share point document folder to one Master file and each time new file is updated in share point folder Flow need to pick up the latest excel file & copy to my Master file. Can you please help.
Very useful video! I have some source data in text file that I need to distribute to other teams in excel file using automate on a daily basis. Do you know if there is a way to convert text file to excel using the script? Thanks
Hi Kevin. Very clear introduction. I would like to insert data from an Excel online spreadsheet to a Word online document (I do non use desktop office). Is that possible? In word online I do not see the developer tab and do not know how to activetate it or if it's possible to activate it. Thanks for any suggestion.
Great vedio Kevin, I have the files in sharepoint server instead of onedrive. Is it possible to run office scripts for files which is present in sharepoint server using power automate flow? When I for the files present in onedrive it worked but not for files present in sharepoint. I would be better if I got calrity on this. Thanks in advance!
it is a great illustration and very enlightening dear @KevinStratvert ! Thank you so much ! I just wanted to know, how we can get data ( text, numbers and some pictures ) from the available pdf documents and create new Word documents as per our conditions ( if, then, Loop) 😊 Could you please suggest a way out ? Appreciate your support !
can u make a tutorial on how can i give permision on users who can edit my worksheet per selected cell range like in google sheet you can select and restrict users what cells they can edit and cannot. thanks in advance
Great video. Thanks. Can office scripts connect to SQL databases to run stored procedures? I have VBA written and need to convert to office script for web based excel users. Thanks in advance.
Hi Kevin, Thanks for the useful info...I'm struggling splitting a number in excel using scripts...I would like to split in thousands, hundreds and dozens in the respective cells...ex: 1234 splitted in 1 uK, 2 h, 3da and 4u, showing the result in the relative cells...I tried to use a script in js but don't know why doesn't recognize a variable and script goes in error. Please, any advise? Appreciate the support, Thanks
Hi Kevin, Thank you for tutorial. Is it possible to edit the Office Script offline on a code editor like VS Code locally on the desktop and then again upload to the cloud , where the initial one was. Also is it possible to expand the code editor for Office Script on web to cover the entire screen so as to give more screen real estate
Office Script is great! The weak spot is the inability of running them if internet is unavailable. If a file is synced to disk, and already has a Script associated with it, it should be possible to run them offline.
Hi Kevin, I have a requirement like excell with color based on status when download excell data from gallery items. can we do it like that using power automate? Please let me know if any possible ways. thanks in advance.
Hi Kevin, I have used a run script command in my flow & I have shared the flow with my colleague. But when he runs the flow, it stops at run script & doesn't execute even after all the permissions are given. Any idea what can be the solution?
How does this differ from power query? And when would you use one vs the other? In your example what it the number of rows varied from report to report?
Power Query is ideal for formatting data before importing into Excel. With Office Scripts, you can set up logic to do all sorts of things (e.g. when someone fills out a Microsoft Form, enter the data into Excel and then update the worksheet based on the form responses). For variable number of rows, you can select the entire column or alternatively you can set up a loop to go through row by row until it hits an empty row.
By VBA or macros we assign a code or command to a button. How can we do that with using scripts. (I mean if I clicked a shape button then excel should be converted in to PDF and should be saved on onedrive)
Hello everyone, Please i have a question about VBA vs Sheets scripts for 365 office. In company we use both and i‘ve been learning vba for 1 year. I have excel macros on my workbook and this workbook is shared through 2 departments which can work at the same time, but there is some problems with saved worbooks through departments.. i heard about 365 office which can work with other people, but i need some protected cells, automaticaly fill some cells and other and other. What is it better for use it if i want to use my workbook in realtime with others? And can scripts the same as macro or are scripts better? And sorry for my english, Greetings from Czech! 😊
Hello Kevin can u make a video on automating excel to send an automated email with power automate and scripts , u gave an insight , pleas share that in detail
Thanks, what version did Excel make Javascript default over VBA? I'm in 2016 & VBA is still default. I know you can reference external libraries in VBA; I'm just asking out of general interest.
@@KevinStratvert Thank you very much, We are very happy that the content you post is very nice ... One content which I am looking forward is Bing programmable search and python
Hi Kevin when I create the script on power automate like you did i have an error message “body is required” and i don’t understand the error ! Can you or someone help me ? Thank you in advance! 🤗
I'm encountering an issue where my script calls a URL using fetch when integrated into Power Automate. It throws the error 'fetch is not defined'. Do you have a solution? Thanks
Hey, may I ask, I already made the office script to my excel online file and share to other team member under same organization. However, when she copied the file, the script wont show and I need to click share again. Is there anyway I could attach the script to the file?
Thanks for the video. Great info. There's a very annoying problem with office scripts and power automate. Scripts use the ID of the file and not the name of the file, even though you select by name. That means you cannot run the script on new files, even of the same name, as it comes back with workbook not found. I have an email that comes in every day with purchase order information which I need to reformat and email onwards however I cannot automate it as the file that gets created from saving the attachment has a new file id every time it is saved therefore the script fails. You have to open the file and run the script manually so it's utility with Power Automate seems very constrained as files would have to be changed in Excel in order for it treat it as the same file or you have to do as I do and run the script manually. Not so great for automation.
I'm trying to figure out a script to hide columns based on the date. I know it would be easy to do with a macro, but I'm at a bit of a loss on scripts and haven't found a lot of good resources for it yet. Anyone that could help would be much appreciated. Thanks!
Excellent video thanks!!! Is it possible to make a video of Script Lab, for those who don't have a business or school version of Office 365? Thanks very much!!!
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Since we are working everyday it excel, maybe you can showcase power automate or power automate desktop on how to build flows to copy data from one excel to another, delete row/columns update pivots, save and send via email as attachment. That will be amazing
It's amazing what Microsoft can do to help automate one's workflow -- very curious to learn more!
This channel is really helpful it should get more attention. I hope you will reach 1 mill some day
Great video Kevin. Never heard of this word Office Scripts but you've now explained Office scripts are useful to automate your day-to-day tasks and how it works. Thanks Kevin 😀
Great to hear!
Amazing!
I was new in Office Scripts and understood in one go Thanks!
Might be best to convert sample dataset to a table, that way if new rows are added your profit column calculation formulae won't be impacted.
Thanks!
Thanks so much! Much appreciated 🙏
Hi Kevin, your video are very interesting with simple and to the point explanation.
Thank you for your video which help us to understand this excel with interest.
Hi Kevin. This is great!!! I'd love it if you would do videos showcasing more advanced applications of Power Automate and Office Scripts. Thanks so much!
Seems like Office Scripts is the love child of: Macros + Office VBA + Nice User Interface = Office Scripts.
I suppose this is a good thing.
0:05 - Hi Kevin! 👋
24:53 - 238th thumbs up from me! 👍 Cheers!
What a great tool! Love it and Power Automate too! Thank you for a great explainer video. :)
great stuff Kevin! one thing i must say is that you got really good voice to deliver the training. normally i cannot bear any vid over 15 min, but this 25 min, it felt pretty short. if you got any courses available in udemy or elsewhere, please let me know. thanks.
Very.much interesting. I will start today itself and it will save tons of time. Many thanks Kevin for your invaluable information in this video
I never thought you can program in Microsoft office this is just very useful to me
Very insight tutorial on Office Script
Hi Kevin, thanks for sharing this video. Can you please advise how to look up data in the active worksheet from another worksheet and how to put in the flow.
Beautiful video, Thank you Kevin Stratvert & You are the best
Thanks Maalouf!
@@KevinStratvert You are the best
Very nice intro video about Office Scripts!
That is pretty cool. Thanks and keep them coming.
More to come!
Thanks you kevin for this video you are the best youtuber
Wow, thanks!
i am so hooked watching your vids
Thanks kevin for this video!!. I have a query that can we run macro script using power automate cloud flow only directly or indirectly??
This is exactly what I was looking for... 😍👏
Yes, it's very useful, its level more than macro, but a lot to learn for using this😁
Hi Kevin, can I perform the recording on the desktop version, save the file online, and then perform power automation?
Hi @Kevin!
Thank you very much for a great video! I plan to use this at work :-). Can you pls show how can we change a range. For example you bolded the first column A4:A9. If my range changes everyday, how can I say rage A2: A “end”of the row? Thanks a lot and you are the best! Cheers, E.
Great video, thank you! I was wondering if it's possible to use the script to refresh Power Query or DAX queries?
This is fun!!! thanks for the content. Looking forward for more from you :D
Thanks a lot Kevin, Can you give a guide to Script Lab as well, It works in desktop versions as well..
Great Video. I need to use Power Automate calling an Officescript that would pivot a dynamic table. The Original table created by PowerAutomate has Year-weeks on the rows and sme Student info ( attendance) on the columns. I need to pivot the table, so that the Year-weeks ( changing every year) are columns and the rows are Student plus attendance. I have implemented this scenario using SSIS Packages and also calling a Script but now I am converting the SSIS package to a PowerAutomate flow using cloud data. Do you have a video or an example over how to achieve this? Thanks
Great video, Kevin! Thank you very much! As someone that has several repetitive monthly reports to do, I've been seeking a way to automate them for a long time. I've developed a lot of macros to help with automation, but was unfamiliar with Scripts until this video. My question is how to use both macros and scripts to completely automate this process.
Thank you much Kevin! 🥂
holy crap, this is brilliant.
Another gem! Keep up the good work!
Much appreciated!
Hi Kevin. This was a great introduction to Office scripts. Please suggest if there is a way to run these scripts on desktop files
Hey Kevin, great video. As an insider (I know, not any more), any idea when Microsoft will support Excel Online auto refresh connections?
Hey Kevin, I would like to thank you first for all your videos, tutorials and all helpful stuff your are sharing. May i do a request? I m trying to send PDF files to one email address. I would like to use Power Automate or mailmerge. I followed your helpful tutorial (how to send mails with attachment with mailmerge) with succes! Do you have any suggestions how to do this? The title of the mails is the name of the pdf file, there has to be no Body text, maybe just the word archive on the titel as prefex for each mail. Thanks in advance! Keep the good work
Greetings Simo
Great video and it could help with some of our processes. But our organization has a mix of Business Premium and Business Basic accounts. Only the Business Premium accounts have access to automate in Excel. If a Premium user creates a script for a spreadsheet and shares it with a Basic user with full edit permissions, would the Basic user be able to run the scripts?
Same question here. Got any info about this already? In my team we all have basic 365 so we are wondering if upgrading just one license to make scripts will allow other users with access to the workbook to run them (for example, making a button that registers data from a userform into a database so that every member in the team can use it). Thanks!
You looks like my little brother. Love your video, very high quality
Nice basic presentation. I would like to know what I can't do with Office Scripts compared to VBA on the desktop. For example, can I clear filters when a user exits from Excel?
Kevin, you are awesome!
HI Kevin， I love your videos, but why I can not see the automate tab in my office 365? neither in desktop or web
Great video and very easy to follow. ExcelScript seem to have lots of capability working inside a workbook. I need to export/print/save the first worksheet to a PDF. Does ExcelScript's capabilities extend to file handling?
Awesome!! TQVM!
Thank you for sharing this. Please do you know if we can insert multi select drop down list in Excel web? I can't find an answer ou there :/
what options do ppl have who own the 2021 office version (not 365)? can you use timed script that run weekly or daily?
Nice!
Thanks Kevin.
Thanks for watching!
awesome tutorial..
Great tutorial! I am getting an error of 'The file format is not recognized. Please check that the selected workbook is valid.
clientRequestId: d2ded74b-3b89-4ebc-a5dc-b3cdde83738e.' The Excel file is .xlsx saved in the correct SP library. When running the script outside of Power Automate, works perfectly well. Thanks!
Hi Kevin..
Thank you for the above guide, I want to merge multiple excel files existing in share point document folder to one Master file and each time new file is updated in share point folder Flow need to pick up the latest excel file & copy to my Master file. Can you please help.
Hi Kevin, is there a way to save this into a new workbook with a dynamic name? or to create a new workbook using office scripts? Thanks!
Very useful video! I have some source data in text file that I need to distribute to other teams in excel file using automate on a daily basis. Do you know if there is a way to convert text file to excel using the script? Thanks
Thanks Kevin. How do I get "Automate" to the excel online? I use Microsoft 365 family.
Hi Kevin. Very clear introduction. I would like to insert data from an Excel online spreadsheet to a Word online document (I do non use desktop office). Is that possible? In word online I do not see the developer tab and do not know how to activetate it or if it's possible to activate it. Thanks for any suggestion.
Great vedio Kevin, I have the files in sharepoint server instead of onedrive. Is it possible to run office scripts for files which is present in sharepoint server using power automate flow? When I for the files present in onedrive it worked but not for files present in sharepoint. I would be better if I got calrity on this. Thanks in advance!
@Kevin S. is there a way to migrate Excel VBA code into Office Scripts?
it is a great illustration and very enlightening dear @KevinStratvert !
Thank you so much !
I just wanted to know, how we can get data ( text, numbers and some pictures ) from the available pdf documents and create new Word documents as per our conditions ( if, then, Loop) 😊
Could you please suggest a way out ?
Appreciate your support !
can u make a tutorial on how can i give permision on users who can edit my worksheet per selected cell range like in google sheet you can select and restrict users what cells they can edit and cannot. thanks in advance
Great video. Thanks. Can office scripts connect to SQL databases to run stored procedures? I have VBA written and need to convert to office script for web based excel users. Thanks in advance.
Hi Kevin. I do not have the Automate Tab on my version. Can you give me some ideas please. I am in Office Insider.
Can we use Power Automate to export sales funnel charts created in Excel for multiple categories/brands so that they all appear in one slide?
Excellent. Thanks
Cool video. Can scripts automatically identify keywords within workbooks before running?
Hi Kevin, Thanks for the useful info...I'm struggling splitting a number in excel using scripts...I would like to split in thousands, hundreds and dozens in the respective cells...ex: 1234 splitted in 1 uK, 2 h, 3da and 4u, showing the result in the relative cells...I tried to use a script in js but don't know why doesn't recognize a variable and script goes in error. Please, any advise? Appreciate the support, Thanks
Can you create custom functions in office script? if not how would you accomplish that in excel online?
Hi Kevin, Thank you for tutorial. Is it possible to edit the Office Script offline on a code editor like VS Code locally on the desktop and then again upload to the cloud , where the initial one was.
Also is it possible to expand the code editor for Office Script on web to cover the entire screen so as to give more screen real estate
Office Script is great!
The weak spot is the inability of running them if internet is unavailable.
If a file is synced to disk, and already has a Script associated with it, it should be possible to run them offline.
Well, there is nothing to say! You rock!
Thanks Dark Dudes AI... appreciate all your comments!
Hi Kevin, I have a requirement like excell with color based on status when download excell data from gallery items. can we do it like that using power automate?
Please let me know if any possible ways. thanks in advance.
Great video! Is it possible to use type script in excel for desktop as well? And create scripts online and use on desktop version and vice versa?
Hi Kevin, I have used a run script command in my flow & I have shared the flow with my colleague. But when he runs the flow, it stops at run script & doesn't execute even after all the permissions are given. Any idea what can be the solution?
Similar to macro. Great tip! Can you please do a video on how to create and run a script with Google Sheets?
Great suggestion!
How does this differ from power query? And when would you use one vs the other? In your example what it the number of rows varied from report to report?
Power Query is ideal for formatting data before importing into Excel. With Office Scripts, you can set up logic to do all sorts of things (e.g. when someone fills out a Microsoft Form, enter the data into Excel and then update the worksheet based on the form responses). For variable number of rows, you can select the entire column or alternatively you can set up a loop to go through row by row until it hits an empty row.
By VBA or macros we assign a code or command to a button. How can we do that with using scripts. (I mean if I clicked a shape button then excel should be converted in to PDF and should be saved on onedrive)
It is possible to run a Office Script that has one or more input parameters in the main function directly from excel?
Will this excel work on Android OS devices..?
hey kevin, can u make a video on filmora X
Could you do a piece on how to calculate CAGR% on a series of periods for an investment?
Hello everyone,
Please i have a question about VBA vs Sheets scripts for 365 office.
In company we use both and i‘ve been learning vba for 1 year. I have excel macros on my workbook and this workbook is shared through 2 departments which can work at the same time, but there is some problems with saved worbooks through departments..
i heard about 365 office which can work with other people, but i need some protected cells, automaticaly fill some cells and other and other.
What is it better for use it if i want to use my workbook in realtime with others? And can scripts the same as macro or are scripts better?
And sorry for my english, Greetings from Czech! 😊
Hello Kevin can u make a video on automating excel to send an automated email with power automate and scripts , u gave an insight , pleas share that in detail
Check out this video: th-cam.com/video/Nl5AoLusNR4/w-d-xo.html
Thanks, what version did Excel make Javascript default over VBA? I'm in 2016 & VBA is still default. I know you can reference external libraries in VBA; I'm just asking out of general interest.
I don't see the "Automate" option in my excel, how can I activate it?
It's available in excel online version, not in desktop app.
Please explain about the "developer" tab in PowerPoint.
Thanks for the suggestion! I've added this to my list. Stay tuned. Cheers!
Can you run script's in shared mailboxes in outlook?
Can you also do a video on Script lab
Thanks for the suggestion! I've added this to my list. Stay tuned. Cheers!
@@KevinStratvert Thank you very much, We are very happy that the content you post is very nice ...
One content which I am looking forward is Bing programmable search and python
Great great video
Just curious. Is Office Script also have buttons as the macros in Excel app?
Hi Kevin when I create the script on power automate like you did i have an error message “body is required” and i don’t understand the error ! Can you or someone help me ? Thank you in advance! 🤗
'Record action' option not available in my excel automate group. Any help
It has to be Excel online. Upload it to your OneDrive. Then you'll see "Automate" in the top ribbon.
Great video
I'm encountering an issue where my script calls a URL using fetch when integrated into Power Automate. It throws the error 'fetch is not defined'. Do you have a solution?
Thanks
Is it possible to automate between MS apps. Like copy text from Excel then paste into Word?
Can i assign script in a shape to trigger the code..??
Hey, may I ask, I already made the office script to my excel online file and share to other team member under same organization. However, when she copied the file, the script wont show and I need to click share again. Is there anyway I could attach the script to the file?
Thanks for the video. Great info. There's a very annoying problem with office scripts and power automate. Scripts use the ID of the file and not the name of the file, even though you select by name. That means you cannot run the script on new files, even of the same name, as it comes back with workbook not found. I have an email that comes in every day with purchase order information which I need to reformat and email onwards however I cannot automate it as the file that gets created from saving the attachment has a new file id every time it is saved therefore the script fails. You have to open the file and run the script manually so it's utility with Power Automate seems very constrained as files would have to be changed in Excel in order for it treat it as the same file or you have to do as I do and run the script manually. Not so great for automation.
I have no automate tap in my excel. I am using MS Office Professional Plus. Any way to add this tap?
I'm trying to figure out a script to hide columns based on the date. I know it would be easy to do with a macro, but I'm at a bit of a loss on scripts and haven't found a lot of good resources for it yet. Anyone that could help would be much appreciated. Thanks!
Excellent video thanks!!! Is it possible to make a video of Script Lab, for those who don't have a business or school version of Office 365? Thanks very much!!!
Thanks Toni! Great suggestion, I'll add to my list. Cheers!