Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

Power Automate and Power Automate Desktop Training

This page contains information on all of the training that we provide on Power Automate and Power Automate Desktop.

We currently run the following scheduled Power Automate and PAD courses:

Power Automate Desktop Introduction to Power Automate Advanced Power Automate
Not exactly the course contents you want? Why not consider organising your own tailored Power Automate and PAD course)?

More about our Power Automate and Power Automate Desktop training

If you're not sure whether you should be using Power Automate, Power Automate Desktop, both or neither, here's a quick comparison!

You can see a longer comparison in this blog, which tries to show in more details the differences between these two products which have such deceptively similar names!

Power Automate Desktop

The purpose of Power Automate Desktop is to create flows like this one:

Excel flow

As it happens, this flow would open Excel, read in some data from a workbook and then close Excel down again.

Power Automate Desktop allows you to read from (or write to) parts of web browser or other application forms:

Web form

You can select any part of a web page or application, and either write text in to it or read from it.

You can use loops, conditions and variables, although there's no language to learn:

Loops and variables

This program is looping over a range of Excel cells, doing something for each (and using variables to hold the intermediate values).

 

Here are most of the commands that you can use in Power Automate:

The main commands

The commands that you select from.

 

However, each of these commands contains a host of subcommands.  Here as one example is what you get if you choose Mouse and keyboard: 

Mouse and keyboard

The mouse and keyboard events that you can automate.

 

The best way to think of Power Automate Desktop is like this: it does for the whole of Windows what VBA macros do for Excel.

Power Automate

Whereas Power Automate Desktop is designed to automate things that you do on your computer, Power Automate allows you to create cloud flows.  Typical applications that you might want to automate could include:

Applications Notes
File storage Cloud flows can move, copy, rename and delete files and folders, providing that you give them access to the relevant storage sites.  Typically you might use Power Automate to save data in SharePoint, OneDrive, DropBox, Google Drive or any other cloud storage medium.
Email servers If you use a cloud-based app like GMail or Outlook to manage your messages, you can link to it to download emails, save attachments and create rules for processing incoming emails (to give just a few ideas).
Social media Provided that you have the security rights to connect to a social media platform, you can interrogate it.  A typical use of this might be to monitor Twitter for a particular hashtag's use.
Collaboration Obvious collaborative software to play around with in flows would be Teams (so you could automatically add approved holidays to your organisation's Teams calendar, for example).

The best way to see what you might use a Power Automate flow for is to have a look at some of the template flows provided:

Template flows

A (very) small sample of templates for flows that you can create in Power Automate.

Another good way to understand what you might do within a Power Automate flow is to have a look at some of the connectors available:

Popular connectors

Some of the most popular things you might connect to are OneDrive, Excel 365 and SharePoint.

Crucial to Power Automate is the concept of triggering flows with actions:

Some triggers

Just a few ideas for things you could do to trigger a flow.

 

Any flow consists of a range of possible actions, and this is where Power Automate becomes more like its sister program Power Automate Desktop:

Some Excel actions

Some of the actions that you can do for Excel Online, for example.

 

What the above shows is that you would typically learn Power Automate Desktop to automate things that you do from your desktop computer and Power Automate to automate things that you do in the cloud, although there is some overlap between the functionality of the two products.

10 things our courses include

Each of our scheduled courses (whether classroom or online) includes:

  1. Small course sizes - we have a maximum of 6 people on each classroom or online course.
  2. A trainer! And not just anyone - our courses are only ever given by full-time Wise Owls.
  3. Full colour courseware and exercises of oustanding quality.
  4. A no cancellation guarantee (once you've booked and confirmed your training course, it will run).
  5. A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too, together with a nice pen.
  6. Unofficial help after the course (although we don't have a dedicated post-course support line, in practice trainers will be happy to answer the odd ad hoc question after a course has taken place).
  7. A certificate sent out digitally or in paper form (your choice) after each course, together with (for tailored courses) the trainer's thoughts on how the course went.

In addition, our classroom courses also include:

  1. A computer for each delegate (obviously).
  2. Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
  3. Unlimited refreshments during the day, including Tassimo or Nespresso coffee and a range of biscuits and snacks to keep you going through those dark afternoon hours.

Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.

Scheduled Power Automate and PAD training dates

Here are the Power Automate and PAD courses we have scheduled for the next 3 months:

Course Dates Days Venue Price Booking
Power Automate Desktop Thu/Fri 18-19 January 2024 18-19 Jan 2 Online £725 Book places
Introduction to Power Automate Thu/Fri 25-26 January 2024 25-26 Jan 2 Online £725 Book places
Power Automate Desktop Thu/Fri 22-23 February 2024 22-23 Feb 2 Online £725 Book places
Introduction to Power Automate Tue/Wed 27-28 February 2024 27-28 Feb 2 Online £725 Book places

All prices exclude VAT. If you can't see the dates you want, don't forget that you always have the option of arranging onsite Power Automate and PAD training at your offices (we'll even provide the computers and projector).

Other Power Automate and Power Automate Desktop training resources

There are many ways in which we can help you learn Power Automate and PAD!

Try our Power Automate and PAD exercises

You can test your knowledge of Power Automate and of Power Automate Desktop with these exercises.

Power Automate Desktop exercises Power Automate exercises

Blogs on Power Automate and PAD

We have the following blogs on Power Automate to help you.

Power Automate Desktop blogs Blogs on Power Automate

Videos on Power Automate and PAD

We have the following Power Automate videos available.

Power Automate videos

Power Automate and PAD training venues

Here are the venues for our Power Automate courses.

Power Automate training in Manchester Power Automate training in London Onsite Power Automate and PAD training (UK)

Power Automate and PAD courseware manuals

Introduction to Power Automate Desktop Introduction to Power Automate
This page has 0 threads Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2023. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...