Use This Trick to Automate Any Excel Task (Better Than Macros)

Use office scripts to automate any repetitive task in Excel.

The Automate ribbon in Excel is available for users with Microsoft 365 subscriptions who access Office Scripts in the web version of Excel or have Office Scripts enabled on the desktop version. The desktop version is currently only available for Windows users. This ribbon is designed for users who want to create and run scripts to automate repetitive tasks, similar to macros but more accessible through JavaScript-based scripting.

In this video we go over the essentials of office scripts in excel for desktop. This includes trying the same office scripts on removing duplicates, creating pivot tables, and highlighting blank values. After the sample scripts, we cover how to build your own custom script with the record actions button. Then, we cover the key differences between macros and office scripts. Next, we go over an advanced example of office scripts where we create a script to generate Excel worksheet invoices for each customer in a list. Finally, we use power automate to integrate office scripts with other applications like Outlook or teams.

LEARN:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Task Example 1
1:45​ - Task Example 2
2:16​ - Task Example 3
4:11 - Custom Task Automation
6:41​ - Macros vs Office Scripts
8:16​ - Advanced Task Automation
9:54 - Integrating with Outlook, teams and more

[pluto_dp]

Really looking forward to Power Automate video! Great job Kenji, as usual

[mawa]

Btw - I would really like the Power Automate video... I have been trying to understand it for a long time but without success. I would also love to participate in an "Office Automation course" in which you would describe all the mechanisms that can help Office users in automating their tasks or workflows.

[ademb]

This is great, I’d love to see more with power automate and office scripts

[sinmaan]

Power Automate tutorial would be fantastic! Thanks for sharing the wisdom!

[GurpsB]

Great video kenji. I bought your Excel and Powerbi course.

[mattlaptad]

Awesome! And voting "YES", for the Power Automate video. (Of course)!! 😃

[luisllontopbarahona]

Excellent. Looking forward to the Power Automate video....

[mawa]

I have been waiting for a video about the Scripts for ages!

[janfm]

Yes please create a video on power automate and how to leverage it across excel and other office products. Thx

[rajeshsingh]

Hi Sir you are great, I don't have words to thank you but we are doing a great job by helping people us .

[vitoc.]

Awesome video, looking forward to you making a power automate video 👍

[cristar]

I was asked how to use Power Automate to send a periodic email to a customer's email to include routing maintenance task reminders that they are to perform on a typical schedule basis. A video on that would be awesome!

[shadabanwar]

Very helpful and very informative video Kenji, but i wanna say that we want more videos like, How to use advanced excel for Data analytics using Chat GPT .

[AbdulRahman-ypoy]

Yes we need video on Power Automate
By the way this video is so excellent
Helpful and updated ❤❤

[sgadapa]

Hi Kenji, I must say i am addicted to your videos. Can you help me with any kind of automation in reconciliation

[justineborja]

Power automate would be really helpful!!

[deeprasania]

Great video. Thank you so much brother.

[hayab_u]

Thanks! i believe that automation and PowerAutomate are subjects that would need to be covered more and more often. In the case of PowerAutomate, i hope that in the near future it will be simplified and more supported by AI tutoring.

[moisestatis]

Very good helpful video. Thank you for making and share it.

[liquidapathy]

Lookong forward to a power automate video