Course Sessions

Our popular course “INTRODUCTION TO MICROSOFT POWER AUTOMATE DESKTOP” consists of the following:

  • Homework: Participants are expected to use 1-2 hours of preparation before session 1.
  • Interactive sessions: Participants are expected to use two full days for interactive sessions.

We recommend that the sessions take part over 1-2 weeks, ideally not too far apart, for the participants to keep the focus on their learnings.

Teacher

Anders will teach the course himself. Anders is an experienced RPA developer and a teacher with experience in both the public and private sectors. Anders’ YouTube channel has trained more than 130.000 Citizen Developers in just one video.

Participants

To ensure sufficient time for Q&A and the interaction between participants and the instructor, we recommend a maximum of 8-10 participants in the course.

Course Content

Homework

  • Duration: 1-2 hours
  • Content:
    • Before session 1, the participants will receive a homework package designed and recorded by Anders Jensen.
    • This package will consist of video material, in which the participants are guided through cases and “Best Practices”.
    • Participants are expected to build in the tool alongside the video to prepare for the interactive sessions.

Interactive sessions

  • Duration: 2 full days
  • Content:
    • Variables:
      • The most common variable types: Text, Number, and List
      • Flow variables
      • Basic Power Automate activities
      • Input/output variables
      • String Manipulation
    • The recorder:
      • The recorder function on Browsers and Applications
      • How to combine the recorder with our flows
      • Write text files
    • If and Loop:
      • Business logic
    • Excel:
      • Excel automation
      • Using Excel macros/VBA
      • Working with variables
    • Applications:
      • Open applications
      • Automate applications
      • Dynamic selectors
      • Close applications
    • Browsers:
      • Browser automation: Open a browser, Click elements, Type into fields and Extract data
      • Write data to a text file
    • File Handling:
      • Work with files
      • Create a log
      • For each loops
      • Date and time
      • Lists
    • Web Scraping:
      • Web scraping
      • Dynamic web scraping
      • Excel
      • Regex
    • Combine Excel Files:
      • Combine .xlsx or .csv files
      • Advanced Excel work
      • Work with files and folders
    • Selectors:
      • Advanced selector work
      • Browser automation
      • Get data from Excel
      • Optimize the performance of your robots

Learning materials

  • All materials will be digitally available on www.andersjensen.org.
  • The participants will get access to a unique password-protected site before, during, and after the training.
  • The site will provide opportunities for help, links to additional learning resources, and much more.
  • After completing the course, participants will still have access to the site and materials. Likewise, participants will automatically get access to updated materials over time from the site.

Price

The course price is €4750 (+ VAT if applicable).

Booking

Contact Stine for more details and booking. 

Terms

  • If the course is conducted physically, facilities and catering are at your cost.
  • Transportation is included in the prices in the Greater Copenhagen area. Costs of transportation elsewhere are agreed upon on a case-by-case basis.
  • All additional costs, e.g., preparation, planning, coordination, etc., are included in the prices.
  • In addition, our standard, straightforward terms of business apply:
    • We do business based on mutual trust.
    • All our services are pre-paid and non-refundable.
    • Project planning, content creation, and the overall collaboration start once the agreed payment is received.