Excel Automation with Office Scripts and Power Automate

In this video, I will show you how to automate Microsoft Excel repetitive work using an Office Script with Power Automate.

What is Office Scripts:

Office Scripts in Excel on the web let you automate your day-to-day tasks. You can record your Excel actions with the Action Recorder, which creates a TypeScript language script.

You can also create and edit scripts with the Code Editor. Your scripts can then be shared across your organization so your coworkers can also automate their workflows.

You will learn:

1) Apply formatting to excel data

2) Add dynamic formulas

3) Pass data from Power Automate to excel and use it in excel formulas

4) Pass data from Excel to Power Automate

Thank you for watching.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s