[Work Automation Using Free MS RPA] Power Automate Desktop - Excel Automation

If you have completed the basic and essential lectures to understand Power Automate Desktop, now you will learn the most frequently used Excel automation flow in your work through hands-on practice so that you can automate more in your actual work.

(4.8) 8 reviews

105 learners

Level Basic

Course period 3 months

Power Automate
Power Automate
RPA
RPA
MS-Office
MS-Office
Power Automate
Power Automate
RPA
RPA
MS-Office
MS-Office

Reviews from Early Learners

Reviews from Early Learners

4.8

5.0

hyeri-seo

64% enrolled

It's so much fun~!!

5.0

2025 회사탈출

100% enrolled

Honestly, I didn't understand it well when I first heard it ㅠㅠ (This is my first time using this kind of program ㅠ) After listening to it twice, I gradually understood it and applied it ㅎㅎ Since I can listen to it unlimitedly for 3 months? I'll keep listening whenever I have free time and make it mine ㅎㅎ There are times when I have to process a file in the same way every week and send it to a client or team leader. (In my case, it was an order list) When I have to do the same thing every week, I get a little dizzy. ㅎ I didn't come to the company for this ㅋㅋ But I used the knowledge I learned here to create a flow (Of course, creating a flow for the first time can take more time than editing Excel myself, but you only have to create it once), and whenever I need to, I just press Run and a new file comes out in no time. I can also automatically send emails to clients with this. ㅎㅎ It's so great. It saves time!! Please create more advanced lectures! ㅎㅎ

What you will gain after the course

  • Using Power Automate Desktop Excel Automation Templates

  • Create and save Excel in Power Automate Desktop

  • Add and rename a sheet to an Excel file

  • Create an Excel file with values entered in Power Automate Desktop

  • Copy Internet data to create an Excel file and save it

  • Copy Excel data and save it to a notepad file

  • Copy only the data that meets the conditions from Excel and save it to a notepad file

  • Create a new file by copying only the desired columns from an existing Excel file

  • Open an existing Excel file and calculate the empty sales average value

  • Insert Good/Bad according to sales value in empty column of existing Excel file

  • Update specific columns in current file by referencing values from another Excel file

  • Merge two Excel files into one new Excel file, attach the file, and automatically send it by email

  • Copy only the necessary columns from a specific file, create a new Excel, create a sheet with today's date, paste the values, and save it.

Work Less, Do More
Start automating your work with free tools 🤖

Have you taken the RPA transfer course?
I recommend that you start from the basics and then take this course!

Power Automate Desktop is This is Microsoft's RPA tool. Introducing variables and learning grammar from the beginning seemed overwhelming, but the basic course introduced installation, menus, and screens. By following along and automating tasks, I was able to overcome my preconceived notions of difficulty and reduce my resistance.

In the Essentials course, I learned about variables and grammar in Power Automate Desktop to better automate my work. Of course, you can start with the Essentials course and then move on to the Basics course, depending on your preference!


Power Automate Desktop? 🧐

With the implementation of a digital office environment due to COVID-19, Robotic Process Automation (RPA) has begun replacing previously simple tasks. RPA is now performing a wide range of repetitive tasks, such as collecting and analyzing data for use in business processes. The processing speed is incomparably faster than human labor, and the reduced risk of errors is boosting corporate competitiveness.

Power Automate, Microsoft's RPA tool, is a workflow service that uses desktop flows and UI-based automation to connect existing and new systems and help reduce repetitive tasks.

We've made Power Automate Desktop available for free , with over 400 pre-loaded actions for automating desktop-centric workflows . You can create and use automation flows for free, automating tasks across the various applications you use for work.


Learn through practice
Microsoft Power Automate Desktop
Welcome to the lecture!


Learn things like this 📚

  1. Warming Up with an Excel Automation Template
    • Start Excel
    • Find and replace values in Excel
    • Run Excel and extract the table
  2. Create and save a new Excel file, add sheets, and rename them.
  3. Create an Excel file with entered values in Power Automate Desktop
  4. Copy Internet data and save it to an Excel file
  5. Copy Excel data and save it to a Notepad file
  6. Copy only the data that meets the conditions from Excel and save it in Notepad.
  7. Create a new file by copying only the desired columns from an existing Excel file.
  8. Open an existing Excel file and calculate the empty sales average value.
  9. Insert Good/Bad values based on sales values into an empty column in an existing Excel file.
  10. Update a specific column in the current file by referencing values from another Excel file.
  11. Business Utilization Scenarios
    •  Automatically send email by merging two Excel files
    •  Copy only the necessary columns from a specific file, create a new Excel sheet, paste the values, and save.

What you need for the lecture ✒️


  • Microsoft 365 or Microsoft free account, school account
  • Microsoft Excel (1-month free trial available)
  • Power Automate Desktop (free)
  • PC with internet access
  • headset or speakers

Reference lecture 📑

This course is designed to provide hands-on experience in automating tasks using Power Automate Desktop .
If you would like to learn automation using Power Automate Web , please refer to the lecture below.

RPA Series 🦾


Preview Q&A 💬

Q. Do I need to purchase a license to attend the lecture?

  1. Power Automate Desktop is free. It's available to anyone running Windows 10 or later.
  2. Excel is paid. If it's installed on your PC, you can use it. If not, you can sign up for a one-month trial of Microsoft 365 and use it for free for one month.

Q. Do I need any prior knowledge to take the course?

You must have Power Automate Desktop installed!

Q. Is it possible to do this even if I don't know anything about coding or development?

Yes, the lectures are structured so that you can do it if you follow along slowly, one by one.


Introducing the knowledge sharer 🙋‍♀️


Recommended for
these people

Who is this course right for?

  • For those curious about Power Automate Desktop

  • Anyone who wants to automate their work

  • Anyone who wants to automate Excel tasks

  • Anyone who wants to experience MS RPA

  • Anyone who wants to automate their work through free RPA

Need to know before starting?

  • I'll teach you from the basics, but you'll need to install Power Automate Desktop!

Hello
This is omas

2,697

Learners

306

Reviews

165

Answers

4.6

Rating

47

Courses

Nice to meet you! We are "Omas", Microsoft 365 experts.
As Microsoft 365 experts, we will help you work more easily and smartly.

Introducing Omas's instructors!!

Instructor Hyunjung Ko
Microsoft MVP (Microsoft 365 Apps & Services, 2016 – Present)

 

Official Blog & Café

 

YouTube

 

Books 

  • Microsoft 365 Business for Users & Admins

  • OMAS: My Smart Work using Office 365

  • Office 365 Quick Guide Series 1. Creating a SharePoint Site for Collaboration

  • Office 365 Quick & Easy Series 2. BI that business users can apply to work immediately without expert help

  • Office 365 Quick & Easy Series 3. From Basics to Advanced All at Once! OneDrive for Business

  • Office 365 Quick Series 4. Creating mobile apps your company needs: PowerApps

  • Office 365 in SMBs: My Smart Work using Office 365

  • Using OneNote 2016! - Basic Edition

  • OneNote 2016 Utilization! - Advanced Guide

  • Female office workers, never do this! A cheerful look at how to succeed in your professional life by thinking outside the box.

 

Recognitions

  • MS-102 - Microsoft 365 Certified: Administrator Expert

  • MS-100 - Microsoft 365 Identity and Services

  • Teams Meetings and Meeting Rooms Technical Assessment

  • MS-700 - Microsoft 365 Certified: Teams Administrator Associate

  • MS-900 - Microsoft 365 Certified: Fundamentals

  • AZ-104 - MS Azure Administrator Associate

  • AZ-900 - Microsoft Certified: Azure Fundamentals

  • SC-900 - Microsoft Certified: Security, Compliance, and Identity Fundamentals

  • PL-900 - Microsoft Certified: Power Platform Fundamentals

  • Exam 347: Enabling Office 365 Services

  • Microsoft Office Specialist Word 2016 Expert

  • Microsoft Office Specialist PowerPoint 2016 Core

  • Certificate of Qualification. Presentation Speech 1st  Level

Other Qualifications

  • Presentation Speech Level 1 (Korea Vocational Skills Certification Association, Ministry of Employment and Labor)

  • CS Instructor Level 1 (Korea Vocational Competency Assessment Association, Ministry of Trade, Industry and Energy)

  • e-Learning Senior Consultant (Korea U-Learning Association)

  • e-Learning Instructor Level 2 (Korea U-Learning Association)

  • Computer Science Teacher Certificate (Minister of Education)

  • Lifelong Education Specialist Level 2 (Seoul University of Buddhism and Culture)

More

Curriculum

All

14 lectures ∙ (2hr 30min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

8 reviews

4.8

8 reviews

  • hyeriseo3167님의 프로필 이미지
    hyeriseo3167

    Reviews 3

    Average Rating 5.0

    5

    64% enrolled

    It's so much fun~!!

    • omas
      Instructor

      Kyaa!!! 😍😍 Thank you so much for listening with such enjoyment~~~~ !!

  • untilwhen님의 프로필 이미지
    untilwhen

    Reviews 5

    Average Rating 5.0

    5

    100% enrolled

    Honestly, I didn't understand it well when I first heard it ㅠㅠ (This is my first time using this kind of program ㅠ) After listening to it twice, I gradually understood it and applied it ㅎㅎ Since I can listen to it unlimitedly for 3 months? I'll keep listening whenever I have free time and make it mine ㅎㅎ There are times when I have to process a file in the same way every week and send it to a client or team leader. (In my case, it was an order list) When I have to do the same thing every week, I get a little dizzy. ㅎ I didn't come to the company for this ㅋㅋ But I used the knowledge I learned here to create a flow (Of course, creating a flow for the first time can take more time than editing Excel myself, but you only have to create it once), and whenever I need to, I just press Run and a new file comes out in no time. I can also automatically send emails to clients with this. ㅎㅎ It's so great. It saves time!! Please create more advanced lectures! ㅎㅎ

    • omas
      Instructor

      Wow...... Just learning is amazing, but applying it to your work... I'm really touched!!! You have no idea how touched I was when I came to work this morning and saw these course reviews! Thank you so much! The next course is currently about 50% complete, so I'll work hard and launch it soon. Could you please send me an email to support@ocl.co.kr? I'll send you a 50% discount coupon when the new course is created! ❤️

  • hcsoo8382님의 프로필 이미지
    hcsoo8382

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    • roekd33님의 프로필 이미지
      roekd33

      Reviews 1

      Average Rating 5.0

      5

      36% enrolled

      • bhchae5369님의 프로필 이미지
        bhchae5369

        Reviews 5

        Average Rating 4.6

        5

        36% enrolled

        omas's other courses

        Check out other courses by the instructor!

        Similar courses

        Explore other courses in the same field!

        $34.10