Course Description

Synopsis:

In this third Power Automate Desktop module, participants deepen their abilities of automation by learning how Power Automate Desktop can interact with Microsoft Excel and web browsers. With Excel, participants delve into the manipulation of datatables – essentially spreadsheets inside Power Automate Desktop – and learn how to read from and write to Excel. The curriculum then dives into utilising the recorder function to interact with web browsers, enabling users to automate web-based tasks with precision and versatility. By combining interactions with Excel, datatables, and web browsers, participants acquire a comprehensive skill set to tackle more challenging automation challenges using Power Automate Desktop.

This course is relevant to professionals interested in enhancing their productivity and efficiency by automating repetitive tasks, streamlining workflows, and optimizing data processing robotic process automation.

This course (comprises 3 parts) is a series of videos to guide you through RPA exercises and examples, and let you learn at your own convenience.

• Part 3 of this course focuses on integrating tools used by accountants such as Excel, with Power Automate Desktop, to create efficient automation flows.
• Automate Your Accounting: Power Up with Power Automate Desktop (Part ONE) covers an overview of why accountants may need RPA, and the Power Automate Desktop software. 
• Automate Your Accounting: Power Up with Power Automate Desktop (Part TWO) focuses on foundational programming concepts (e.g. variables, conditionals and loops) essential for creating more complex automation flows in real-life scenarios.

Intended For:

•    Audit Professionals / PAIP
•    Finance Professionals/ PAIB
•    Public Sector Finance
•    C-suite & Directors 
•    Business Owners

Competency Mapping: 

•    CPE Category 5 = 1.5 CPE Hours