Use office scripts to automate any repetitive task in Excel.
🚀 FREE 50 Excel Hacks Template from Hubspot: https://clickhubspot.com/eykz
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.
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/ly9melh49p
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:
🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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