Become RPA Master in MS Power Automate Desktop (in 30 days)

سرفصل های دوره

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

1 - Introduction

1 - Welcome to the course

2 - Microsoft Power Automate Cloud

2 - What is Microsoft Power Automate

3 - How to Signup and signin for Power Automate

3 - Power Automate User accounts and Pricing

4 - Get Started with Accounts

5 - Pricing Model

6 - PayAsYouGo Licensing Model New

4 - Lets Start Power Automate Desktop

7 - Power Automate Desktop is now FREE for Windows 10 users

8 - How to Download and Install Power Automate Desktop

9 - Quick Look Power Automate Desktop application

10 - Microsoft Power Automate Versus Microsoft Power Automate Desktop

5 - Variables Actions

11 - How to Set Variable Truncate Number Get Random Numbers

12 - How to Increase Variable Decrease Variable

13 - Desktop Flow for Set varable Truncate & Get Rand Numbers Inc & Dec Variable.html

13 - SetVarTruncateNumberGetRandNumbersincanddecvar-1-0-0-1.zip

14 - CreateNewlistAdditemRemoveitemfromListclearlist-1-0-0-1.zip

14 - How to Create New List Add Item to List Remove Item From List Clear List

15 - How to Work with Remove Duplicate items from List Reverse List Shuffle List

15 - RemoveDuplicateitems-Reverse-ShuffleList-1-0-0-1.zip

16 - How to Work with Merge Lists Subtract Lists Find Common List items

16 - MergeListsSubtractListsFindCommonListitems-1-0-0-1.zip

6 - Conditional Actions

17 - Learn Conditional Actions Theoretical

18 - How to work with Conditional Actions Practical Use case

19 - Working with Conditional Actions If and Else

20 - Working with Conditional Actions If Else If Switch Case Default Case

21 - Working with If File Folder Exists and If Process Conditional Actions

7 - Loop Actions

22 - Learn and Work with Loops Loop Loop Condition Next loop & Exit loop

23 - Learn and Work with For Each Loop

8 - Database Actions

24 - Open and Close SQL Connection Execute SQL Statement

25 - Database Actions with Stored Procedure

9 - Excel Automation

26 - Employee.xlsx

26 - Employee-Selection.xlsx

26 - LaunchExcelReadDatafromExcelCloseExcel-1-0-0-1.zip

26 - Launch Excel Read from Excel Close Excel

27 - WritetoExcelWorksheet-1-0-0-1.zip

27 - Write to Excel Worksheet

28 - AddNewWorksheet-1-0-0-1.zip

28 - How to Add New Worksheet

29 - How to Set Active Excel Worksheet

29 - SetActiveExcelWorksheet-1-0-0-1.zip

30 - GetFirstFreeColumnRowFromExcelWorksheet-1-0-0-1.zip

30 - How to work with Get First free Column Row from Excel Worksheet action

31 - Employee.xlsx

31 - GetfirstfreerowoncolumnfromExcelWorksheet-1-0-0-1.zip

31 - How to work with Get first free row on column from Excel Worksheet

32 - Employee.xlsx

32 - Employee-Selection.xlsx

32 - ExcelAutomationdesktopFlows-1-0-0-2.zip

32 - Sample Desktop flows for Excel Automation.html

10 - Advanced Excel

33 - GetActiveExcelWorksheet-1-0-0-1.zip

33 - How to Get Active Excel Worksheet

34 - GetAllexcelworksheets-1-0-0-1.zip

34 - How to Get All Excel Worksheets

35 - DeleteExcelWorksheet-1-0-0-1.zip

35 - How to work with Delete Excel Worksheet

36 - How to work with Rename Excel Worksheet

36 - RenameExcelWorksheet-1-0-0-1.zip

37 - InsertColumnInsertRowtoExcelWorksheet-1-0-0-1.zip

37 - Insert Column Insert Row to Excel Worksheet

11 - Excel as Database Using SQL Queries

38 - EmployeesList.xlsx

38 - Introduction for Excel as Database

39 - PreRequisites for OLEDB provider

40 - OLEDB Connection String

41 - Install Microsoft Access database Engine

42 - Topic1ReadExcelFileDataUsingASQLConnection-1-0-0-1.zip

42 - Topic 1 Read Excel File Data Using A SQL Connection From Multiple WorkSheets

43 - Topic 2 How to Filter the Records from the excel

43 - howtoFiltertheRecordsfromtheexcel-1-0-0-1.zip

44 - GetTop5salaries-1-0-0-1.zip

44 - Topic 3 Get Top 5 salaries by Using SQL Query

12 - Data table Variable actions

45 - Introduction to Data table variable actions

46 - How to work with Create new Data table variable Action

47 - How to create a data table using Set Variable Action

47 - createnewdatattable-1-0-0-1.zip

47 - variable.zip

48 - How to add a row to data table using Insert Row into Data table action

48 - insertrowintodatatable-1-0-0-1.zip

49 - How to work with Update data table item action

49 - updatedatatableitem-1-0-0-1.zip

13 - Files Actions

50 - Learn and Work with Files Actions

51 - Read Text from file and Write to Text File

52 - Get Filepath Part Action

53 - Read from CSV file and Write to CSV File

14 - Folder Actions

54 - Learn and Work with Folder Actions

55 - Work with Folder Actions Empty Delete Copy Move and Rename Folder

15 - Compression Actions

56 - Learn How to Work with Compression Actions Zip and Unzip Files

16 - Text Actions

57 - How to work with Append line to Text

58 - How to work with Get SubText Action

59 - How to work with Pad Text Action

60 - How to work with Trim Text Action

61 - How to work with Change Text Case Action

62 - How to work with Create Random Text Action

63 - How to work with Join Text Action Text Actions

64 - How to work with Split Text Action Text Actions

65 - How to work with Replace Text Action Text Actions

66 - How to work with Parse Text Action Text Actions

67 - How to work with Escape Text for Regular Expression

68 - How to work with Convert Text to Number

69 - How to work with Convert Number to Text Action

70 - How to work with Convert Text to DateTime Action

71 - How to work with Convert DateTime To Text Action

17 - Working with Regular Expressions

72 - Understanding Regular Expressions

73 - RegEx Global & Case Insensitive Character Sets Ranges Repeating characters

74 - RegEx Metacharacters Special & Alternate Characters Starting & End Patterns

75 - Real Time Example To Extract Email IDs from Outlook with Regular Expressions

76 - Developed Desktop Flows for Regular Expressions.html

76 - RegularExpressions-1-0-0-1.zip

18 - Email Automation GMAIL Features are getting deprecated

77 - Overview of Email Automation

78 - How to work with Retrieve Emails Action

79 - How to work with Email FiltersRetrieve Emails Actions

80 - How to work with Process Emails Action

81 - How to work with Send Email Action

19 - Outlook Automation

82 - Introduction of Outlook Automation

83 - How to work with Retrieve Email Messages from Outlook

84 - How to work with Retrieve Email Messages from Outlook Part 2

85 - How to work with Sent Email through Outlook

86 - How to work with Respond to Outlook Mail Message

87 - How to work with Process email Messages in Outlook

88 - How to work with Save Outlook email Messages

20 - PDF Automation

89 - Introduction of PDF Automation

90 - Extract Images from PDF

91 - Extract Text from PDF

92 - Extract PDF pages to new PDF

93 - Merge PDF Files

21 - XML Automation

94 - Read XML From File

95 - Execute XPath Expression

96 - Get XML Element Attribute

97 - Get XML Element value

98 - Set XML Element Attribute

99 - Set XML Element Value

100 - Insert XML Element

101 - Write XML to File

102 - Remove XML Element attribute

103 - Remove XML Element

22 - Automate using UI Elements

104 - Working with UI Elements

105 - How to Handle Dynamic UI Elements for Web Pages

23 - WebBrowser Automation

106 - Introduction of Web Automation

107 - Live Application for Browser Automation Web Form Filling

108 - Automation With UI Elements

109 - Work with Web Form Filling Actions Launch New Browser Close Web Browser

110 - Working with Entire Web Form Filling Actions Demo Project Detailed

111 - Data Entry Project with Web Form Filling Actions & Excel Automation

112 - Web Data Extraction Extract Data from Web Page

113 - Web Data Extraction Get details of web page

24 - UI Automation

114 - Introduction of UI Automation

115 - Form Filling Actions Part 1

116 - Form Filling Actions Part 2

117 - Get Details of Window UI Automation Data Extraction

118 - Get Details of an UI Element in Window UI Automation Data Extraction

119 - Get Selected Radio Button in Window UI Automation Data Extraction

120 - Get Selected CheckBox in Window UI Automation Data Extraction

121 - Extract Data From Window UI Automation Data Extraction

25 - Recorders

122 - Web Recorder

123 - Desktop Recorder

26 - Schedule Share and Monitor Desktop Flows

124 - How to schedule Desktop Flows

125 - How to share the Desktop Flows

126 - Monitor Desktop Flows

27 - Environments Export & Import Desktop Flows

127 - Learn About Power Automate Environments Create & Switching Environments

128 - How to Export and Import Desktop Flows

28 - OnPremises data gateway

129 - What is onpremises data gateway

130 - How to trigger Power Automate desktop Flows from another flow

29 - Scripting Actions

131 - Introduction to Scripting Actions

132 - How to work with Run VBScript Action

133 - How to work with Run JavaScript Action

134 - How to work with Run JavaScript Function on web Page Action

135 - How to work with Run Python Script Action

136 - How to work with Run Powershell Script Action

30 - Power Automate Machine Runtime

137 - Introducing Power Automate Machine Runtime App

138 - Manage Machines

139 - Machine Group

140 - How to Trigger a desktop Flow Direct to Machine to run on our machine

31 - December 2021 Features

141 - How to Create a copy of Desktop Flow

142 - Unified Recorder Web Recorder Desktop Recorder

32 - SharePoint Actions Preview

143 - Introduction to SharePoint Actions Preview

144 - SharePoint Connection and Connection Reference

145 - How to upload a file to SharePoint By using Create a file Action

145 - SharePointcreateFileAction-1-0-0-1.zip

146 - How to update a file in SharePoint By using Update file Action

146 - SharePointUpdateFile-1-0-0-1.zip

147 - GetFoldermetadatausingpath-1-0-0-1.zip

147 - How to work with Get Folder metadata using path action

148 - How to work with List Folder Action

148 - SharePointlistfolder-1-0-0-1.zip

149 - GetFilemetadatausingpath-1-0-0-1.zip

149 - How to work with Get File metadata using path action

150 - GetFilecontentusingpath-1-0-0-1.zip

150 - How to work with Get File content using path action

151 - How to work with Delete File action

151 - Sharepointdeletefile-1-0-0-1.zip

33 - Project 1 HR Use case Employee Onboarding Process

152 - Employee-onboarding-Process.xlsx

152 - Part 1 Demo for Employee Onboarding Process Employee ID & Email Generation

152 - Weblink.txt

153 - Part 2Desktop Flow for Browser Web Automation for Employee Onboarding process

153 - Weblink.txt

154 - Employee-onboarding-Process.xlsx

154 - Part 3 Desktop Flow for Excel Automation for Employee Onboarding process

154 - Weblink.txt

155 - EmployeeOnboardingProcess-1-0-0-4.zip

155 - Part 4 Desktop Flow for Email Automation

34 - Project 2 WorkItem Management Integration With Azure DevOps

156 - Introduction to WorkItem Management

157 - Demo WorkItem Management

157 - Project-Management.xlsx

157 - WorkItemManagementProject-1-0-0-1.zip

157 - azure-devops-rest-api-urls.zip

158 - Set Up and Configure Azure DevOps Rest API

159 - Personal Access Token

160 - Test Azure DevOps Rest API

161 - Components for Azure DevOps Rest API

162 - Create a desktop Flow to invoke Azure DevOps Ret API

163 - Add Workitems to Azure Boards Dynamically

164 - Update Workitems

165 - WIQL WorkItem Query Language

35 - Project 3 RPA Challenge with Dynamic UI Elements for Web form Filling

166 - Usecase for RPA challenge

167 - Demo for RPA Challenge

168 - Steps to Solve RPA challenge

169 - How to Capture UI Elements

170 - How to handle dynamic UI elements on a web page

171 - Create a desktop flow for web form filling with dynamic UI elements

172 - Read Excel data and populate on web page

173 - Create Subflow for RPA challenge

174 - Error Handling

175 - Complete & Final Run for RPA Challenge

176 - RPA Challenge Source Code Developed Desktop Flow.html

176 - RPA-Challenge-1-0-0-1.zip

176 - challenge.xlsx

36 - Interview Questions and Answers

177 - Power Automate Desktop Interview Questions Series 1

178 - Power Automate Desktop Interview Questions Series 2

37 - Congratulations

179 - Congratulations

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training