[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개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 3개월

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

먼저 경험한 수강생들의 후기

먼저 경험한 수강생들의 후기

4.8

5.0

hyeri-seo

64% 수강 후 작성

It's so much fun~!!

5.0

2025 회사탈출

100% 수강 후 작성

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! ㅎㅎ

강의상세_배울수있는것_타이틀

  • 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 🙋‍♀️


강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • 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

선수 지식, 필요할까요?

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

강의소개.지공자소개

2,634

수강생

294

수강평

165

답변

4.6

강의 평점

47

강의_other

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)

더보기

커리큘럼

전체

14개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

전체

8개

4.8

8개의 수강평

  • roekd33님의 프로필 이미지
    roekd33

    수강평 1

    평균 평점 5.0

    5

    36% 수강 후 작성

    • jyeon6360님의 프로필 이미지
      jyeon6360

      수강평 1

      평균 평점 5.0

      5

      36% 수강 후 작성

      • hyeriseo3167님의 프로필 이미지
        hyeriseo3167

        수강평 3

        평균 평점 5.0

        5

        64% 수강 후 작성

        It's so much fun~!!

        • omas
          지식공유자

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

      • bhchae5369님의 프로필 이미지
        bhchae5369

        수강평 4

        평균 평점 4.5

        5

        36% 수강 후 작성

        • hcsoo8382님의 프로필 이미지
          hcsoo8382

          수강평 1

          평균 평점 5.0

          5

          100% 수강 후 작성

          omas님의 다른 강의

          지식공유자님의 다른 강의를 만나보세요!

          비슷한 강의

          같은 분야의 다른 강의를 만나보세요!

          강의상세.할인문구

          $30,800.00

          30%

          $34.10