Online Training
Power Automate Desktop 2-day training course
Live online training course - classroom version also available
£695 + VAT (where applicable)
Two days (09:30 to 16:30 UK time each day)
Do you find yourself repeating the same mouse clicks or keystrokes every day or week? Power Automate Desktop (PAD) allows you to automate anything you do using Windows, without having to write any lines of code (you can even use the PAD recorder to record what you're doing, allowing you to save the steps for future use). This two-day course will gives lots of practical examples on how you can use Power Automate to ... well, automate what you do, freeing up your time for other work. Along the way you'll learn about automating browsing a website (using UI elements), reading from and writing to Excel, sending and receiving emails and manipulating files and folders, to name just a few topics covered.
Course schedule
Here are our next few online Power Automate Desktop course dates:
| Dates | Times | Price (excl. VAT) | |
|---|---|---|---|
| 28-29 Jun | 09:30-16:30 | £695 | Book |
| 20-21 Oct | 09:30-16:30 | £695 | Book |
| Show full list of dates | |||
Got a handful of like-minded people in your organisation? You could consider creating your own customised online course to run on a date convenient to you).
Course Contents
The contents of this course are as follows:
Getting started
- Creating flows
- Comments
- Input and message boxes
Variables
- Referring to variables
- Managing variables
- Viewing variable values
Subflows
- Creating subflows
- Running subflows
Debugging
- Stepping through flows
- Setting breakpoints
Working with Excel
- Opening and closing
- Getting and writing data
- Other Excel actions
Error handling
- Testing buttons, files, etc.
- Error-handling for actions
- Error blocks for flows
Input and output variables
- Calling flows
- Filling output varaibles
- Referencing input variables
Lists
- Populating lists
- Looping over lists
- Adding to and clearing lists
Loops
- Looping N times
- Conditonal loops
- Looping over collections
Conditions
- Testing conditions (IF)
- Multiple conditions (SWITCH)
SQL Server
- Opening connections
- Reading data
Data tables and rows
- Populating data tables
- Looping over data rows
- Collapsing data columns
Files and folders
- Manipulating files
- Working with folders
- Reading / writing text files
- Using CSV files
Different data types
- Common text actions
- Common data actions
Mouse and keyboard
- Sending keys
- Mouse clicks
Browsing websites
- Using different browsers
- UI elements
- Problems you may encounter
- Extracting data
User intefaces (UIs)
- UI elements revisited
- Capturing data
- Filling in forms
Emails and Outlook
- Using Outlook
- Sending emails
- Extracting attachments
If time
PDFs
- Reading PDFs
- Printing PDFs
- Using OCR to read text
If time
Images
- Adding images
- Using in website automation
- Deleting unused images
If time
Case studies
- Backing up files
- Emailing files to different users
- Compiling SEO results
If time
Recording flows
- Recording your steps
- Limitations of recording
Benefits of our online training
Here are some reasons to choose Wise Owl online courses:
- Maximum of 6 people per class
- Excellent colour courseware manual posted to you in advance
- Pre-course set-up included in the days before the course
- No need to install any software on your computer
- All courses given by one of our 6 Wise Owl trainers
- 479 references viewable online
What other people have said
Many thanks to those listed below for kindly agreeing to let us use their names. All of the reviews are from the last 3 calendar years (although some may be for classroom courses):
Elspeth Clark (Central and North West London (CNWL) NHS Foundation Trust)
Julie Fottles (Network Plus)
Charlotte Steele (The Office of the Director of Public Health)
Karen Chambers (Greater Manchester Combined Authority (GMCA))
Simon Randle (Derby and Burton Hospitals NHS FT)
Refresh the page to see a different set of reviews!
How our live online training courses work
We've published a full summary of what it's like to attend a Wise Owl course online - here are the main things you need to know.
You'll need three things for the course:
- A computer (obviously) running Windows.
- A good internet connection.
- A microphone and (ideally) webcam.
In addition you'll find the course very difficult without an additional monitor (so that you can participate in the course on one screen, and use the software you're learning on the other).
Within a few hours of your booking a place on one of our online courses, we'll be in touch to get you set up correctly. This usually takes about half an hour, and can be done at any mutually convenient date/time.
A few days before your course begins you'll receive a parcel in the post (free for UK bookings) containing:
- A full colour courseware manual;
- An exercise booklet to go with the course; and
- A USB stick containing the files for the course, should you need a back-up.
Your parcel will even include a Wise Owl biro (they're good; trust us) and pad.
You won't need to install any software at all on your computer. This is because:
- you'll use Windows Remote Desktop to connect to our computers, and these will have all of the necessary files and software installed; and
- we use Teams for our online training, which you can run through most modern browsers.
On the day of the course itself you will be able to join the course up to half an hour before it begins. This will give you time to:
- familiarise yourself with the set-up;
- meet your trainer; and
- get to know the other delegates!
After the course finishes you'll receive an electronic certificate proving your attendance (we will gladly send a paper copy on request also).
You can see full details of exactly how our online courses work here.