Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Development
No-Code Development
Microsoft Power Automate
Become RPA Master in Microsoft Power Automate Desktop

Become RPA Master in Microsoft Power Automate Desktop

Loại khoá học: No-Code Development

This Course is designed with 35+ hours & 4 live Projects to learn MS Power Automate Desktop to Automate repetitive Tasks

image
50.000 VND
100 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

<<Covering all concepts* of Power Automate desktop related to PL-500 Certification>>

This Course is Designed to Learn RPA with orientation and structure of Microsoft Power Automate desktop, installation, error handling, flow control, debugging and automation of business processes. This Course covers many aspects of RPA to keep the technology up to speed.


This course is for everyone (Beginners , Intermediate ,Experts) , how wants to learn Power Automate Desktop step by step about Desktop flows, creating automated steps, and flow development essentials.

By the End of the course , you will  be able to :

  1. Introduction to the Power Automate Desktop

  2. How to Install Power Automate Desktop

  3. Hardware and Software requirements

  4. Create  a simple Desktop Flow

  5. Working with Variable Actions (Set Variable, Truncate Number, Get Random Numbers , Increase Variable , Decrease Variable , Create New List, Add Item to List, Remove Item From List, Clear List , Remove Duplicate items from  List, Reverse List, Shuffle List, Merge Lists, Subtract Lists, Find Common List items)

  6. Working with Conditional Actions (If and Else, If , Else If, Switch, Case, Default Case , If File / Folder  Exists and If Process )

  7. working with Loops

  8. working with Excel Automation

  9. working with Database Automation

  10. Working with File Actions

  11. Working with Folder Actions

  12. Work with Compression Actions (Zip and Unzip Files)

  13. Work with Text Actions

  14. Working with Date and Time Actions

  15. working with Email Automation Actions

  16. working with Outlook Automation Actions

  17. working with web recorder

  18. working with web Automation Actions

  19. working with UI Automation Actions

  20. working with Desktop recorder

  21. working with  PDF Automation Actions

  22. working with XML Automation Actions

  23. DataVerse

We will  learn Every action step by step with basic examples.

Bạn sẽ học được gì

By the end of the course, you will be capable of working on real time projects

You will get, Complete Knowledge on Power Automate Desktop

You will learn, How to Install Power Automate Desktop

You will learn, How to create Desktop Flow

You will learn, How to Connect with MS Excel ,Database and Outlook

You will learn, How to use Web and Desktop recorders to develop flows

You will become master in Microsoft Power Automate Desktop

*Microsoft PL-500 Covering all Power Automate Desktop Concepts*

Microsoft Power Automate RPA Developer - Questions

Yêu cầu

  • No Programing Knowledge / Coding Knowledge Required
  • Better to have basic understanding on MS Excel, Outlook, SQL Database
  • No Prerequisites are Required.

Nội dung khoá học

49 sections

Introduction

1 lectures
Welcome to the course
01:22

Robotic Process Automation

3 lectures
Introduction to RPA
05:43
Major RPA Roles and Responsibilities
11:20
RPA Life Cycle
09:17

Microsoft Power Automate Cloud

2 lectures
What is Microsoft Power Automate
08:39
How to Sign-up and sign-in for Power Automate
13:11

Power Automate User accounts and Pricing

3 lectures
Get Started with Accounts
11:42
Pricing Model
12:04
Pay-As-You-Go Licensing Model (New !!!)
14:43

Lets Start Power Automate Desktop

7 lectures
Power Automate Desktop is now FREE for Windows 10 users
10:19
Hardware and Software Requirements
03:00
How to Download and Install Power Automate Desktop
09:54
Quick Look Power Automate Desktop application
10:27
Microsoft Power Automate Versus Microsoft Power Automate Desktop
13:53
How to Create a Desktop Flow
06:29
Knowledge Check
2 questions

Variables Actions

6 lectures
How to Set Variable, Truncate Number, Get Random Numbers
13:49
How to Increase Variable , Decrease Variable
07:32
Desktop Flow for Set varable , Truncate & Get Rand Numbers , Inc & Dec Variable
00:05
How to Create New List, Add Item to List, Remove Item From List, Clear List
12:07
How to Work with Remove Duplicate items from List, Reverse List, Shuffle List
08:03
How to Work with Merge Lists, Subtract Lists, Find Common List items
12:04

Conditional Actions

5 lectures
Learn Conditional Actions (Theoretical)
04:58
How to work with Conditional Actions (Practical Use case)
05:08
Working with Conditional Actions (If and Else)
05:43
Working with Conditional Actions (If , Else If, Switch, Case, Default Case)
08:02
Working with If File / Folder Exists and If Process Conditional Actions
10:59

Loop Actions

2 lectures
Learn and Work with "Loops" (Loop, Loop Condition, Next loop & Exit loop)
13:25
Learn and Work with "For Each Loop"
04:31

Database Actions

2 lectures
Open and Close SQL Connection, Execute SQL Statement
13:46
Database Actions with Stored Procedure
15:59

Excel Automation

7 lectures
Launch Excel, Read from Excel, Close Excel
20:41
Write to Excel Worksheet
11:35
How to Add New Worksheet
04:37
How to Set Active Excel Worksheet
06:19
How to work with Get First free Column / Row from Excel Worksheet action
08:45
How to work with "Get first free row on column from Excel Worksheet"
11:20
Sample Desktop flows for Excel Automation
00:09

Advanced Excel

5 lectures
How to "Get Active Excel Worksheet"
04:37
How to "Get All Excel Worksheets"
03:58
How to work with "Delete Excel Worksheet"
04:40
How to work with "Rename Excel Worksheet"
08:21
Insert Column , Insert Row to Excel Worksheet
12:30

Excel as Database (Using SQL Queries)

7 lectures
Introduction for Excel as Database
02:41
Pre-Requisites for OLEDB provider
01:26
OLEDB Connection String
02:12
Install Microsoft Access database Engine
06:40
Topic 1 : Read Excel File Data Using A SQL Connection (From Multiple WorkSheets)
20:21
Topic 2 : How to Filter the Records from the excel
12:49
Topic 3 : Get Top 5 salaries by Using SQL Query
07:18

Power Fx

1 lectures
Power Fx is now available in Power Automate for desktop (in preview)
02:31

Data table - Variable actions

8 lectures
Introduction to Data table - variable actions
02:40
How to work with "Create new Data table" variable Action
10:37
How to create a data table using "Set Variable" Action
08:48
How to add a row to data table using "Insert Row into Data table" action
14:02
How to work with "Update data table item" action
06:37
How to work with "Retrieve data table Column to list" action
05:29
How to work with "Find or Replace in data table" action
20:20
How to work with "Delete row from data table" action
04:52

Files Actions

4 lectures
Learn and Work with Files Actions
13:07
Read Text from file and Write to Text File
08:58
Get Filepath Part Action
02:59
Read from CSV file and Write to CSV File
11:07

Folder Actions

2 lectures
Learn and Work with Folder Actions
13:36
Work with Folder Actions (Empty, Delete, Copy, Move and Rename Folder)
10:01

Compression Actions

1 lectures
Learn How to Work with Compression Actions (Zip and Unzip Files)
13:16

Text Actions

15 lectures
How to work with "Append line to Text"
10:29
How to work with "Get SubText" Action
08:17
How to work with "Pad Text" Action
06:47
How to work with "Trim Text" Action
08:02
How to work with "Change Text Case" Action
07:26
How to work with "Create Random Text" Action
06:02
How to work with "Join Text" Action (Text Actions)
06:05
How to work with "Split Text" Action (Text Actions)
06:13
How to work with "Replace Text" Action (Text Actions)
10:34
How to work with "Parse Text" Action (Text Actions)
10:26
How to work with "Escape Text for Regular Expression"
05:10
How to work with "Convert Text to Number"
05:55
How to work with "Convert Number to Text" Action
05:46
How to work with "Convert Text to DateTime" Action
06:53
How to work with "Convert DateTime To Text" Action
07:25

Working with Regular Expressions

5 lectures
Understanding Regular Expressions
03:40
RegEx (Global & Case Insensitive, Character Sets, Ranges, Repeating characters)
13:13
RegEx (Metacharacters, Special & Alternate Characters, Starting & End Patterns)
11:05
Real Time Example : To Extract Email IDs from Outlook with Regular Expressions
23:03
Developed Desktop Flows for Regular Expressions
00:04

Email Automation (GMAIL Features are getting deprecated)

5 lectures
Overview of Email Automation
04:26
How to work with "Retrieve Emails" Action
09:41
How to work with "Email Filters"(Retrieve Emails Actions)
09:53
How to work with "Process Emails" Action
12:45
How to work with "Send Email" Action
10:29

Outlook Automation

7 lectures
Introduction of Outlook Automation
04:31
How to work with "Retrieve Email Messages from Outlook"
11:24
How to work with "Retrieve Email Messages from Outlook" - Part 2
12:07
How to work with "Sent Email through Outlook"
08:04
How to work with "Respond to Outlook Mail Message"
09:43
How to work with "Process email Messages in Outlook"
08:13
How to work with "Save Outlook email Messages"
10:09

PDF Automation

6 lectures
Introduction of PDF Automation
02:45
Extract Images from PDF
08:26
Extract Text from PDF
06:15
Extract PDF pages to new PDF
06:06
Merge PDF Files
06:41
Extract Tables from PDF
08:40

XML Automation

10 lectures
Read XML From File
16:00
Execute XPath Expression
15:32
Get XML Element Attribute
07:43
Get XML Element value
06:32
Set XML Element Attribute
07:29
Set XML Element Value
05:32
Insert XML Element
05:50
Write XML to File
08:58
Remove XML Element attribute
04:44
Remove XML Element
05:23

Automate using UI Elements

2 lectures
Working with UI Elements
13:43
How to Handle Dynamic UI Elements for Web Pages
13:24

Web/Browser Automation

11 lectures
Introduction of Web / Browser Automation
08:09
Live Application for Browser Automation (Web Form Filling)
01:37
Automation With UI Elements
11:59
Work with Web Form Filling Actions (Launch New Browser, Close Web Browser)
12:55
Working with (Entire) Web Form Filling Actions - Demo Project (Detailed)
19:06
Data Entry Project with Web Form Filling Actions & Excel Automation
14:01
Web Data Extraction - Extract Data from Web Page
09:34
Web Data Extraction - Get details of web page
11:53
Go to web page Action
07:39
Create New Tab action
07:20
Click Link on web page
05:35

UI Automation

8 lectures
Introduction of UI Automation
03:13
Form Filling Actions - Part 1
08:07
Form Filling Actions - Part 2
08:03
Get Details of Window (UI Automation - Data Extraction)
07:21
Get Details of an UI Element in Window (UI Automation - Data Extraction)
05:35
Get Selected Radio Button in Window (UI Automation - Data Extraction)
05:20
Get Selected CheckBox in Window (UI Automation - Data Extraction)
03:38
Extract Data From Window (UI Automation - Data Extraction)
05:27

Recorders

3 lectures
Web Recorder
11:27
Desktop Recorder
05:55
Knowledge Check
3 questions

Exception Handling

4 lectures
Introduction Of Exception handling
02:00
Exception handling Properties
06:36
Action Level Exception handling
11:59
Block Level Exception handling
04:33

Schedule, Share and Monitor Desktop Flows

3 lectures
How to schedule Desktop Flows?
11:43
How to share the Desktop Flows?
07:00
Monitor Desktop Flows
05:09

Environments ,Export & Import Desktop Flows

2 lectures
Learn About Power Automate Environments (Create & Switching Environments )
13:41
How to Export and Import Desktop Flows?
12:53

On-Premises data gateway

3 lectures
What is on-premises data gateway?
12:13
How to trigger Power Automate desktop Flows from another flow ?
10:11
Knowledge Check
1 question

System Actions

5 lectures
Introduction
00:59
Run Application Action
12:34
Terminate Process Action
05:58
If Process action
03:58
Wait for Process
03:31

Manage Variables

2 lectures
Input Variables
10:33
Output Variables
06:13

Scripting Actions

6 lectures
Introduction to Scripting Actions
04:19
How to work with "Run VBScript" Action
20:59
How to work with "Run JavaScript" Action
06:46
How to work with "Run JavaScript Function on web Page" Action
16:41
How to work with "Run Python Script" Action
08:16
How to work with "Run Powershell Script" Action
11:45

Power Automate Machine Runtime

4 lectures
Introducing Power Automate Machine Runtime App
05:39
Manage Machines
09:29
Machine Group
16:17
How to Trigger a desktop Flow (Direct to Machine) to run on our machine
08:44

December 2021 Features

2 lectures
How to Create a copy of Desktop Flow
02:50
Unified Recorder ( Web Recorder , Desktop Recorder )
11:14

SharePoint Actions (Preview)

9 lectures
Introduction to SharePoint Actions (Preview)
02:38
SharePoint : Connection and Connection Reference
09:28
How to upload a file to SharePoint (By using Create a file Action)
11:05
How to update a file in SharePoint (By using Update file Action)
08:17
How to work with "Get Folder metadata using path" action
04:57
How to work with "List Folder" Action
06:34
How to work with "Get File metadata using path" action
05:26
How to work with "Get File content using path" action
09:08
How to work with "Delete File" action
07:23

Microsoft Teams (Released on October 2023)

22 lectures
Introduction to Microsoft Teams
09:01
Create a Chat
06:24
Post message in chat or channel (using Chat)
07:52
Error Solved : Create a chat (Cloud connector failed with status code Forbidden)
02:52
Create a Channel
06:05
Post message in chat or channel (using Channel)
07:17
Create a Team
05:53
Add a member to a Team
05:10
List Teams
03:28
List Channels
08:44
List Members
04:22
Create a tag for a team
07:43
Add a member to a tag
04:56
List all tags for a Team
03:19
List the members for a tag
08:50
Get a Team
04:18
Create a Teams meeting
12:14
Get messages
06:21
List Chats
07:58
Reply with a message in a channel
09:25
Post a card in a chat or channel
09:17
Reply with adaptive card in a channel
08:33

Project #1 : HR Use case : Employee Onboarding Process

4 lectures
Part 1 : Demo for Employee Onboarding Process (Employee ID & Email Generation)
12:36
Part 2:Desktop Flow for Browser / Web Automation for Employee Onboarding process
12:01
Part 3: Desktop Flow for Excel Automation for Employee Onboarding process
23:20
Part 4 : Desktop Flow for Email Automation
11:30

Project #2 : WorkItem Management {Integration With Azure DevOps}

10 lectures
Introduction to WorkItem Management
01:05
Demo || WorkItem Management
06:58
Set Up and Configure Azure DevOps Rest API
01:36
Personal Access Token
03:19
Test Azure DevOps Rest API
03:24
Components for Azure DevOps Rest API
03:49
Create a desktop Flow to invoke Azure DevOps Ret API
11:01
Add Workitems to Azure Boards Dynamically
22:35
Update Workitems
13:29
WIQL (WorkItem Query Language)
13:26

Project #3 : RPA Challenge with Dynamic UI Elements for Web form Filling

11 lectures
Usecase for RPA challenge
02:09
Demo for RPA Challenge
02:05
Steps to Solve RPA challenge
00:33
How to Capture UI Elements
04:01
How to handle dynamic UI elements on a web page ?
06:55
Create a desktop flow for web form filling with dynamic UI elements
06:38
Read Excel data and populate on web page
11:23
Create Subflow for RPA challenge
04:17
Error Handling
04:30
Complete & Final Run for RPA Challenge
02:14
RPA Challenge - Source Code (Developed Desktop Flow )
00:06

Project #4 : National Stock Exchange (NSE)

14 lectures
Introduction to Web Scraping
07:38
Web Scraping : National Stock Exchange
10:07
What are the learning Concepts as part of Web scraping?
01:50
Data Extraction from NSE (Working with “Extract Data from web page “ action)
15:11
Work with "Wait for Web page Content" action
07:56
How to get list of items from dropdown using “Extract Data from web page“ Action
08:04
Get list of items from dropdown using “Run JavaScript Function on web page“ -2
13:38
NSE : How to work with "Set Drop-Down List value on the web page" action
08:08
NSE : Working with Excel actions to store data in Excel file
09:54
NSE: Creating a folder for Excel data
08:36
NSE : Exception Handling
11:11
NSE : How to Schedule NSE Desktop flow using Power Automate Cloud?
07:45
NSE : Final Output
04:19
Complete Solution for NSE Project - Developed Cloud Flow & Desktop Flows
00:02

ChatGPT with Power Automate Desktop

7 lectures
Lets start ChatGPT
00:42
What is ChatGPT?
03:28
Sign up or Create an account on ChatGPT
05:22
Overview, Features, Benefits and Limitations of ChatGPT
07:03
ChatGPT API
10:26
Integrate ChatGPT with Power Automate Desktop
19:02
ChatGPT References
01:32

OneDrive for Business

16 lectures
Introduction to OneDrive for Business Actions
02:40
Connection Reference for OneDrive for Business Actions
05:20
Create / Upload File Action
07:09
Create Share Link Action
09:15
"Create Share Link by path" Action
08:58
Get File Metadata and Get File Metadata using path Actions
08:35
Get File Content Action
06:59
"Get File Content using path" Action
03:36
"List files in folder" Action
07:59
"List files in root folder" Action
03:03
"List files in root folder" vs "List files in folder" Action
01:59
Copy File
08:03
Copy File Using Path
05:39
Move or Rename a file
07:12
Move or Rename a file using path
05:52
Extract Archive to folder
06:18

Dataverse

4 lectures
what is Dataverse ?
04:42
Dataverse Tables
07:10
Dataverse DataTypes
13:25
How to create a Table in Dataverse
13:20

Best Practices

1 lectures
Best Practices in Power Automate Desktop
00:59

Interview Questions and Answers

2 lectures
Power Automate Desktop Interview Questions - Series 1
08:49
Power Automate Desktop Interview Questions - Series 2
08:25

Microsoft CoPilot

3 lectures
What is Microsoft CoPilot?
02:27
Features of CoPilot
06:06
CoPilot in Power Automate Desktop
09:35

Congratulations!!!

1 lectures
Congratulations!!!
00:20

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

The Complete UML Course (2024): Learn to Design UML Diagrams

The Complete UML Course (2024): Learn to Design UML Diagrams

25 VND
50.000 VND
Master Network Automation with Python for Network Engineers

Master Network Automation with Python for Network Engineers

1.699.000 VND
50.000 VND
Unity Mobile Game Development - Exterminator

Unity Mobile Game Development - Exterminator

1.499.000 VND
50.000 VND
Mastering CSS Grid 2023 - With 3 cool projects

Mastering CSS Grid 2023 - With 3 cool projects

99 VND
50.000 VND
Django 3 - Full Stack Websites with Python Web Development

Django 3 - Full Stack Websites with Python Web Development

1.699.000 VND
50.000 VND
Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

95 VND
50.000 VND
Appium - Mobile Testing with Latest 2.0 and Live Projects

Appium - Mobile Testing with Latest 2.0 and Live Projects

70 VND
50.000 VND
Deep Learning for Object Detection with Python and PyTorch

Deep Learning for Object Detection with Python and PyTorch

899.000 VND
50.000 VND
Full Android Development Masterclass | 14 Real Apps-46 Hours

Full Android Development Masterclass | 14 Real Apps-46 Hours

1.699.000 VND
50.000 VND
Go Java Full Stack with Spring Boot and Angular

Go Java Full Stack with Spring Boot and Angular

90 VND
50.000 VND
Machine Learning Practical Workout | 8 Real-World Projects

Machine Learning Practical Workout | 8 Real-World Projects

79 VND
50.000 VND
WordPress 2024: The Complete WordPress Website Course

WordPress 2024: The Complete WordPress Website Course

90 VND
50.000 VND
Android App Development Master Course with Java | Android

Android App Development Master Course with Java | Android

99 VND
50.000 VND
Unreal Engine 5: Soulslike Melee Combat System

Unreal Engine 5: Soulslike Melee Combat System

1.399.000 VND
50.000 VND
ASP.NET Core Web Application Using Razor Pages

ASP.NET Core Web Application Using Razor Pages

1.699.000 VND
50.000 VND
Build Undetectable Malware Using C Language: Ethical Hacking

Build Undetectable Malware Using C Language: Ethical Hacking

75 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi