Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power Automate Desktop - Beginner to Pro
Introduction
Welcome (0:31)
Getting Ready
Install Power Automate Desktop and browser extensions (2:36)
Power Automate Desktop Overview (1:13)
Download the lesson files (1:05)
Record Your Actions
Record your first flow (Web automation) (6:16)
Clean up and add to the flow (4:03)
Improve with the recorder (Word automation) (7:13)
Manually improve the flow (4:23)
Variables
Intro to variables and prepare data (1:43)
Text variables (8:48)
Working with lists (8:18)
Numericals (3:54)
Booleans - True/False (2:02)
Leverage DateTimes (5:49)
DataTables (3:58)
DataRows (7:32)
If and Loop
The If and Else if actions (9:22)
Loop condition (7:11)
Advanced loop conditions, part 1 (9:17)
Advanced loop conditions, part 2 (8:13)
Excel
Excel preperations (1:52)
Basic Excel (Create a master Datatable) (14:01)
Prepare the master sheet (Save to Excel) (7:23)
Add sheets for each shop dynamically (2:57)
Write data to Excel (5:26)
Automate Excel formulas, part 1 (3:50)
Automate Excel formulas, part 2 (4:36)
Resize column widths (1:22)
Advanced VB scripting (6:01)
File Handling
Prepare the project, part 1 (2:52)
Prepare the project, part 2 (subflows) (2:32)
Unzip files (4:50)
Handle error files (8:32)
Process the success files (3:45)
Create a log and variable gymnastics (8:42)
Dynamic file naming (3:01)
Browsers
Basic web automation (8:53)
Combine web automation with Excel (6:09)
Iterate Excel (5:03)
Create a log (4:59)
Advanced error-handling (8:47)
Applications
Prepare data (2:27)
Basic selector work (6:35)
Dynamic selectors (3:53)
Dynamic application entry (10:05)
Write application results to Excel (4:17)
Application work with logic (7:38)
Add conditional formatting to the results (5:07)
Web extraction
Prepare the data (1:19)
Navigate and speed things up (11:47)
Create a dynamic selector (6:12)
The rest of the 'Web extraction' lessons are coming soon :)
Outlook
Coming
Now what?
AI and Automation Black Belt
Basic Excel (Create a master Datatable)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock