강의

멘토링

커뮤니티

Productivity

/

Task Automation

Automating tasks Level 2 - Power Automate

If you have understood the basics of Power Automate through the Power Automate Level 1 lecture, now let's take it up a level and try automating it.

(4.5) 11 reviews

117 learners

  • omas
Power Automate
MS-Office

Reviews from Early Learners

What you will learn!

  • Power Automate

  • Flow

  • Automation of business

  • Automate schedule registration (outlook ↔ group/team schedule)

  • Automatically save Excel backup when adding a SharePoint List

  • Automatically send notification emails when adding/modifying SharePoint List items

  • Automatically send notification emails when SharePoint List items are deleted

  • Automation from event registration to guidance

Automate your work with Power Automate
Let's become a profiler!

Since both Power Automate and SharePoint are conducted online, the coding screens can be difficult to see clearly. Therefore, I'll be capturing all the coding screens during the lecture to ensure a clear view for students. For those who require live coding, please note that this lecture will be conducted via screen capture.

Lecture Introduction 📝

If you've taken the Power Automate Level 1 course, "Automating My Repetitive Tasks - Power Automate (Flow)" and automated tasks by applying simple Flows, let's automate tasks in more steps with the Level 2 course!

I want to automatically copy my calendar and group calendars in Outlook, automatically save SharePoint List items to Excel files, receive emails with the information I want when adding/editing/deleting SharePoint List items, and automate everything from event registration to participation guidance!

This course will help you automate repetitive tasks, focus on more important tasks, and become a professional!


What I learned in class ✏️

So, let's see what tasks we can automate.

  1. When you register a schedule in your Outlook calendar, the schedule is automatically copied to the desired group calendar.
  2.  Automatically save to a specified Excel file when new items are added to a SharePoint list


  3.  Automatically notify you by email when items are added/modified in a SharePoint list.


  4. Automatically send email notifications with the necessary information when an item is deleted from a SharePoint list.


  5. Event registration is received through Forms, automatically saved as a SharePoint List, and an email is sent out informing participants of the participation schedule.

What you need to attend the lecture 💡

  1. Power Automate
  2. SharePoint Online
  3. OneDrive Business
  4. Forms
  5. PC with internet access

Tools covered here 💡

  1. Power Automate paid or free trial ( https://asia.flow.microsoft.com/ko-kr/)
    Or, if you are an Office 365 or Dynamics 365 subscriber, you can use the free Power Automate.
    However, it is not provided free of charge to Business Apps or Enterprise Apps subscribers.
  2. Of Office 365 (Outlook, OneDrive, SharePoint, OneNote, Forms)

Expected Questions Q&A 🙋🏻‍♂️

Q. Do I need to buy any tools to take the course?
A. No~~~!! You can take the course with the free trial version!

Q. Do I need any IT development or programming knowledge to take this course?
A. No~~~!! Just follow the lectures and you'll be fine! You can do it in no time, even without any programming knowledge!


Recommended for
these people

Who is this course right for?

  • Office workers who want someone to do repetitive tasks for them

  • Office workers who want to automate their work

  • Anyone who wants to learn Power Automate

  • Those who want to automate more advanced steps after taking the Power Automate Level 1 course

Hello
This is

2,440

Learners

261

Reviews

164

Answers

4.5

Rating

43

Courses

반갑습니다! Microsoft 365 전문가 "오마스"입니다.
Microsoft 365 전문가가 여러분이 보다 쉽게 스마트하게 업무를 할 수 있도록 돕겠습니다. 

오마스의 강사를 소개합니다!!
 

고현정 강사
Microsoft MVP (Microsoft 365 Apps&Services, 2016 ~ 현재)

 

운영 Blog & Café

 

YouTube

 

저서 

  • Microsoft 365 Business for Users & Admins

  • Office 365를 활용한 My Smart Work 오마스

  • Office 365 뚝딱 시리즈 1. 협업을 위한 SharePoint Site 만들기

  • Office 365 뚝딱 시리즈 2. 전문가 도움 없이 현업 담당자가 바로 업무에 적용하는 BI  

  • Office 365 뚝딱 시리즈 3. 기초부터 활용까지 한 번에! 비즈니스용 OneDrive

  • Office 365 뚝딱 시리즈 4. 우리 회사에서 필요한 모바일 앱 만들기 PowerApps

  • Office 365 in 중소기업 오피스 365를 활용한 마이 스마트워크

  • 원노트 2016 활용! - 기본편 

  • 원노트 2016 활용! - 활용편

  • 여자 직장인, 이것만은 절대 하지 마라! 유쾌하게 뒤집어 생각해보는 직장생활 성공법

 

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

그 외 자격

  • 프레젠테이션 스피치 1급 (한국직업능력검정협회, 고용노동부)

  • CS 강사 1급 (한국직업능력검정협회, 산업통상자원부)

  • 이러닝 최고 컨설턴트 (한국U러닝연합회)

  • e러닝 지도사 2급 (한국U러닝 연합회)

  • 전자계산 교원자격증 (교육부장관)

  • 평생교육사 2급 (서울문화예술대학교)

Curriculum

All

8 lectures ∙ (1hr 10min)

Published: 
Last updated: 

Reviews

All

11 reviews

4.5

11 reviews

  • suhyounglee8865님의 프로필 이미지
    suhyounglee8865

    Reviews 9

    Average Rating 4.8

    5

    100% enrolled

    Nội dung được cấu trúc với những thông tin có thể hữu ích trong công việc thực tế nên rất tốt.

    • omas
      Instructor

      Rất vui khi biết rằng tôi đã giúp ích được cho bạn, cảm ơn bạn vì đánh giá khóa học tràn đầy năng lượng!!! 👍👍

  • yongkyuncho7514님의 프로필 이미지
    yongkyuncho7514

    Reviews 1

    Average Rating 3.0

    3

    88% enrolled

    ..

    • jonggilyoun6892님의 프로필 이미지
      jonggilyoun6892

      Reviews 5

      Average Rating 4.2

      5

      100% enrolled

      Tôi sẽ sử dụng nó tốt trong tương lai khi cần thiết.

      • omas
        Instructor

        Vâng, tôi hy vọng nó sẽ giúp ích cho công việc của bạn ~ 👍👍

    • changhwan1song5369님의 프로필 이미지
      changhwan1song5369

      Reviews 1

      Average Rating 4.0

      4

      100% enrolled

      Nó rất hữu ích trong việc học tập.

      • omas
        Instructor

        Cảm ơn chúa~ ^^ Cảm ơn bạn đã đánh giá đáng khích lệ!

    • tkekhrseedcampus7579님의 프로필 이미지
      tkekhrseedcampus7579

      Reviews 3

      Average Rating 4.7

      5

      100% enrolled

      Cảm ơn

      • omas
        Instructor

        Cũng cảm ơn bạn~ ^^

    $26.40

    omas's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!