Power Automate & Office Scripts... better together

This webinar will guide intermediate Excel users through the essentials of Power Automate & Office Scripts. You will learn to combine Excel with these tools to boost productivity, streamline data tasks, and tackle complex business processes efficiently.

Recording & downloads

• A recording will be made available after the event.
• Download files will be shared at the time of the event.

By the end of this free online training, you’ll understand:

• The key functionalities of Power Automate & Office Scripts and their advantages over traditional automation tools in Excel.
• How to construct and oversee automated workflows in Excel, utilizing Power Automate & Office Scripts for tasks like data management, analysis, and reporting.
• Integration capabilities between Excel and external services using Power Automate, simplifying your business operations.

And you’ll be able to:

• Implement automated workflows in Excel to efficiently handle routine data tasks, minimizing manual input and reducing errors.
• Develop tailored automation strategies with advanced features of Power Automate & Office Scripts to address specific challenges in data management.
• Share and control Power Automate flows, fostering consistent and scalable automation solutions across your team or organization.

Who this is for

Typical job titles might include:

• Data analysts
• Financial analysts
• Marketing coordinators
• Accountants
• Controllers
• Operations analysts

Prerequisites

• Please confirm you have access to Power Automate by logging into make.powerautomate.com.
• Please confirm you have access to Office Scripts by checking you have an Automate tab on the ribbon of Excel. You can learn more about Office Scripts licensing here.
• To make the most of the workshop, you will have some experience in topics such as taking sums and counts, creating calculated columns, and using relative and absolute references in Excel.
• It is recommended to attend this workshop on a Windows machine
• No other preparation is needed.

About your instructor

George Mount is the founder of Stringfest Analytics. He has over 10 years of experience in data analytics and holds master’s degrees in both finance and information systems from Case Western Reserve University. George is the author of Advancing into Analytics: From Excel to Python and R (O’Reilly, 2021) and Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics (O'Reilly, 2024). He is a recipient of the Most Valuable Professional (MVP) award from Microsoft for technical excellence & community advocacy.

I look forward to seeing you at the event!

If your team is looking for custom training in Modern Excel, check out my corporate workshops.