Become RPA Master in Microsoft Power Automate Desktop

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the course

Chapter 2: Robotic Process Automation

Lecture 1: Introduction to RPA

Lecture 2: Major RPA Roles and Responsibilities

Lecture 3: RPA Life Cycle

Chapter 3: Microsoft Power Automate Cloud

Lecture 1: What is Microsoft Power Automate

Lecture 2: How to Sign-up and sign-in for Power Automate

Chapter 4: Power Automate User accounts and Pricing

Lecture 1: Get Started with Accounts

Lecture 2: Pricing Model

Lecture 3: Pay-As-You-Go Licensing Model (New !!!)

Chapter 5: Lets Start Power Automate Desktop

Lecture 1: Power Automate Desktop is now FREE for Windows 10 users

Lecture 2: Hardware and Software Requirements

Lecture 3: How to Download and Install Power Automate Desktop

Lecture 4: Quick Look Power Automate Desktop application

Lecture 5: Microsoft Power Automate Versus Microsoft Power Automate Desktop

Lecture 6: How to Create a Desktop Flow

Chapter 6: Variables Actions

Lecture 1: How to Set Variable, Truncate Number, Get Random Numbers

Lecture 2: How to Increase Variable , Decrease Variable

Lecture 3: Desktop Flow for Set varable , Truncate & Get Rand Numbers , Inc & Dec Variable

Lecture 4: How to Create New List, Add Item to List, Remove Item From List, Clear List

Lecture 5: How to Work with Remove Duplicate items from List, Reverse List, Shuffle List

Lecture 6: How to Work with Merge Lists, Subtract Lists, Find Common List items

Chapter 7: Conditional Actions

Lecture 1: Learn Conditional Actions (Theoretical)

Lecture 2: How to work with Conditional Actions (Practical Use case)

Lecture 3: Working with Conditional Actions (If and Else)

Lecture 4: Working with Conditional Actions (If , Else If, Switch, Case, Default Case)

Lecture 5: Working with If File / Folder Exists and If Process Conditional Actions

Chapter 8: Loop Actions

Lecture 1: Learn and Work with "Loops" (Loop, Loop Condition, Next loop & Exit loop)

Lecture 2: Learn and Work with "For Each Loop"

Chapter 9: Database Actions

Lecture 1: Open and Close SQL Connection, Execute SQL Statement

Lecture 2: Database Actions with Stored Procedure

Chapter 10: Excel Automation

Lecture 1: Launch Excel, Read from Excel, Close Excel

Lecture 2: Write to Excel Worksheet

Lecture 3: How to Add New Worksheet

Lecture 4: How to Set Active Excel Worksheet

Lecture 5: How to work with Get First free Column / Row from Excel Worksheet action

Lecture 6: How to work with "Get first free row on column from Excel Worksheet"

Lecture 7: Sample Desktop flows for Excel Automation

Chapter 11: Advanced Excel

Lecture 1: How to "Get Active Excel Worksheet"

Lecture 2: How to "Get All Excel Worksheets"

Lecture 3: How to work with "Delete Excel Worksheet"

Lecture 4: How to work with "Rename Excel Worksheet"

Lecture 5: Insert Column , Insert Row to Excel Worksheet

Chapter 12: Excel as Database (Using SQL Queries)

Lecture 1: Introduction for Excel as Database

Lecture 2: Pre-Requisites for OLEDB provider

Lecture 3: OLEDB Connection String

Lecture 4: Install Microsoft Access database Engine

Lecture 5: Topic 1 : Read Excel File Data Using A SQL Connection (From Multiple WorkSheets)

Lecture 6: Topic 2 : How to Filter the Records from the excel

Lecture 7: Topic 3 : Get Top 5 salaries by Using SQL Query

Chapter 13: Power Fx

Lecture 1: Power Fx is now available in Power Automate for desktop (in preview)

Chapter 14: Data table – Variable actions

Lecture 1: Introduction to Data table – variable actions

Lecture 2: How to work with "Create new Data table" variable Action

Lecture 3: How to create a data table using "Set Variable" Action

Lecture 4: How to add a row to data table using "Insert Row into Data table" action

Lecture 5: How to work with "Update data table item" action

Lecture 6: How to work with "Retrieve data table Column to list" action

Lecture 7: How to work with "Find or Replace in data table" action

Lecture 8: How to work with "Delete row from data table" action

Chapter 15: Files Actions

Lecture 1: Learn and Work with Files Actions

Lecture 2: Read Text from file and Write to Text File

Lecture 3: Get Filepath Part Action

Lecture 4: Read from CSV file and Write to CSV File

Chapter 16: Folder Actions

Lecture 1: Learn and Work with Folder Actions

Lecture 2: Work with Folder Actions (Empty, Delete, Copy, Move and Rename Folder)

Chapter 17: Compression Actions

Lecture 1: Learn How to Work with Compression Actions (Zip and Unzip Files)

Chapter 18: Text Actions

Lecture 1: How to work with "Append line to Text"

Lecture 2: How to work with "Get SubText" Action

Lecture 3: How to work with "Pad Text" Action

Lecture 4: How to work with "Trim Text" Action

Lecture 5: How to work with "Change Text Case" Action

Lecture 6: How to work with "Create Random Text" Action

Lecture 7: How to work with "Join Text" Action (Text Actions)

Lecture 8: How to work with "Split Text" Action (Text Actions)

Lecture 9: How to work with "Replace Text" Action (Text Actions)

Lecture 10: How to work with "Parse Text" Action (Text Actions)

Lecture 11: How to work with "Escape Text for Regular Expression"

Lecture 12: How to work with "Convert Text to Number"

Lecture 13: How to work with "Convert Number to Text" Action

Lecture 14: How to work with "Convert Text to DateTime" Action

Lecture 15: How to work with "Convert DateTime To Text" Action

Chapter 19: Working with Regular Expressions