WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 479 reviews for our classroom and online training
Classroom training -  Power Automate Desktop

Classroom Training

Power Automate Desktop 2-day training course

Classroom training course - online version also available

£850 + VAT for most venues (£995 + VAT for London)

2 days

Power Automate Desktop is the new Robotic Process Automation (RPA) software from Microsoft which allows you to automate anything you do in Windows, including sending emails, printing, working with Excel, browsing websites, filling in forms and much, much more.  Think of it as like the Windows equivalent of VBA, allowing you to automate things that you do (you can even record what you're doing as a sequence of replayable steps), but with no programming involved. This two-day course will give practical examples of many of the most common tasks that you might want to automate (we hope!), and also explain underlying concepts of Power Automate Desktop such as variables, lists, data tables, UI elements, conditions and loops.

Course details

  • Locations for Power Automate Desktop coursesPossible locations:London, Manchester, Online
  • Next Power Automate Desktop course locationNext classroom course:Thu 22 September 2022
  • Power Automate Desktop course timesTime:09:30-16:30

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

Covered if time allows If time

PDFs

  • Reading PDFs
  • Printing PDFs
  • Using OCR to read text

Covered if time allows If time

Images

  • Adding images
  • Using in website automation
  • Deleting unused images

Covered if time allows If time

Case studies

  • Backing up files
  • Emailing files to different users
  • Compiling SEO results

Covered if time allows If time

Recording flows

  • Recording your steps
  • Limitations of recording

To attend this course you need to be a regular user of Windows.  You will get more out of the course if you're familiar with the basics of the main Microsoft Office applications.

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Informative & enjoyable."

Bethan Lavidge (Macquarie Energy Leasing)

"Great content. Great trainer; very patient and nothing was too much trouble."

Ryan Lehmann (Precision Polymer Engineering (PPE) / Idex Corp)

"(SSIS) Enjoyed the training; examples clear and concise; thanks to the trainer for helping investigate particular issues that we had, in his own time, on top of the training. (SSRS) Very useful to be able to tailor the course to our requirements. Many thanks to the trainer for responding so quickly to our questions which went quite a long way off topic."

Lucy Gooda (The Cambridge Building Society)

"Our trainer was absolutely fantastic! He explained very well the contents of the course and was very helpful."

Matteo Paravelli (Home Office)

"The course was recommended within the company as Wise Owl has an outstanding reputation."

Krzysztof Fronia (Coloplast Ltd)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Power Automate Desktop training dates

Here are the classroom Power Automate Desktop courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Thu/Fri 22-23 September 2022 2 £850 Book places
Date(s) Venue
22/09

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Power Automate training at your offices (we'll even provide and set up the computers).

Related Courses

Power Apps

Power Apps Introduction

2 day course

Introduction to Power BI

Power BI Desktop

2 day course

Other Power Automate training resources

Power Automate exercises

Power Automate exercises

We have the following PAD exercises available.

View Power Automate exercises

Power Automate blogs

Power Automate blogs

You can read the following blogs on PAD.

View Power Automate blogs

This page has 0 threads Add post