During this 2 day session, participants will be guided on the following :

DAY 1 - INTRODUCTION TO POWER AUTOMATE DESKTOP

1. Overview of Microsoft Power Automate Desktop

Understanding its purpose and potential in custom business application development. Understanding what's possible with Power Automate. Exploring the Power Automate Desktop ecosystem :

• Introduction to Power Automate Desktop
• What's Power Automate Desktop
• Key features and benefits
• Used cases and real world examples

2. Power Automate Desktop Basics

Introduction To Robotic Process Automation (RPA)

• What is RPA and its applications
• Introduction to Power Automate - gain a better understanding of what Power Automate is and how to use Flows
• Understand the difference between Power Automate Web and Desktop
• Learn to navigate the user interface
• Understand Flow diagrams and how they visually represent a task
• Learn about the different types of Flows

3. Building Desktop Flows

• An introduction to Power Automate Desktop, a non-web version of Power Automate that uses Artificial Intelligence (AI) to interact with your screen (just like Excel Macros)

4. Programming Logic For Desktop Flows

• Basics of building Desktop Flows - Variables, Conditionals, Lists & Loops
• Hands-on : Variables and Conditionals challenge

5. Excel and Data Tables (Spreadsheets inside Power Automate)

• Hands-on : error-checking data
• Hands-on : merging data from different sources

6. Using the Recorder to interact with legacy software

• Hands-on: account creation for new customers/suppliers

7. Mini quiz for learning reinforcement

DAY 2 - INTERACTING WITH FILES AND FOLDERS

• Hands-on : checking for new data (and appending it if needed)
• Hands-on : bulk creation of documents
• Hands-on : read data and take conditional actions

1. Interacting with web platforms

• Intro to HTML and how we interact with it
• Web Scraping
• Hands-on : extracting specific data from the web with regular expressions
• Data in images : using Optical Character Recognition
• Working with APIs
• Handling with JSON data

2. Evaluation and Adoption

• A realistic look at the viability and steps needed to adopt Power Automate Desktop for individual and corporate use
• Adoption Tips - hidden costs, identifying optimal tasks, challenges and potential pitfalls
• Adoption Rate
• The Future of Automation

3. Mini quiz for learning reinforcement

Note : Participants are expected to bring and work on their own laptop during the 2 days.

At the end of the workshop, participants would be able to :

• have an overview of RPA and appreciate its benefits
• implement Power Automate in various industries or departments
• pick up valuable critical thinking and problem solving skills in process planning

This workshop is for working level executives in Finance & Accounting, Administration, Customer Service Operations, IT/System Development, Sales & Marketing or anyone who is tasked to look into cost management and process improvement for their organisations.