
Basics of using M365 Copilot, the AI assistant for my work
omas
Artificial intelligence is no longer an option, but a necessity. Learn to understand and utilize M365 Copilot, the smart AI assistant for your work.
입문
RPA, MS-Office, AI
Are you using Excel to apply for and manage vacation/annual leave? 🤔 Stop asking your manager about your annual leave every time! Create a vacation application and management system for your company through this lecture.
38 learners

Power Automate Web (Cloud) / Approvals
Developing a vacation and annual leave application/management system
Business Process Automation
SharePoint + List + Power Automate + Power Apps
Convenient for both managers and users
Developing a vacation management system and annual leave application app!
Apply for annual leave/vacation by email, and the person in charge organizes it in Excel.
When you return from your annual leave/vacation, deduct the number of days you went back in Excel and subtract them.
Employees keep asking me how many vacation days I have left... 😭
If there is a system, it is not a big deal, but if there is not and the person in charge manages it using Excel or manually, it is not only inconvenient for the user, but also requires the person in charge to spend a lot of time.
It is ambiguous to develop a system like this, so the lecture was designed to help managers spend time on repetitive tasks by creating a system with SharePoint and List, connecting it to Teams for convenient use, and automating it with Power Automate to reduce repetitive tasks and allow managers to focus on important tasks.
If you do not have a vacation/annual leave application system and need to apply by email or payment!
If the person in charge is organizing annual leave/vacation in Excel!
If you're wondering if there's a system for requesting annual leave/vacation!
If you need approval but it is difficult to build a system!
"If there was a system, it wouldn't be a big deal... It's a repetitive task that anyone can do...
🎯 Follow along as we create, configure, and automate together.
1️⃣ An annual leave/vacation request management system is created and the process is automated.
2️⃣ The mobile app for applying for annual leave/vacation is now available and can be used immediately.
3️⃣ You can automatically process approval/rejection and manage the results in an organized manner.
[Get Started]
Team Approvals
Understanding the system production flow
[SharePoint Site, List]
Creating a vacation request/management site
Creating an Employee Information Table
Creating an annual leave information table
Create an annual leave application/management list
Modifying the application form with PowerApps
[Power Automate Automation]
Understanding the Approvals Flow
Automated Step 1 Approval
Automated two-step approval process
Automation of annual leave deduction
[Power Apps Mobile App]
Creating a Mobile App for Annual Leave Applications - (1) Automating from Lists
Creating a Mobile App for Annual Leave Applications - (2) Creating a Mobile App in Power Apps
Verify and test your mobile app
[Sharing and Utilization]
Using the List App
Sharing and Teams Connection
Q. Do I need to buy any tools to take the course?
No, if you already have a Microsoft 365 Business Standard license or higher, you can use that.
If you are not subscribed, you can sign up for a one-month free trial and proceed for free before subscribing.
Q. Do I need any IT development or programming knowledge to take this course?
No! Even if you're not a developer or a specialist, you can easily follow the lectures. Anyone can do it in no time, even without any programming knowledge.
🌀 Notes before taking the course
Who is this course right for?
Anyone who manages vacation and annual leave with Excel
People who do not have a vacation or annual leave system within the company
Anyone who wants to automate their work
Anyone who wants to learn Power Automate Cloud
Anyone who wants to get ideas for automating their work
2,513
Learners
276
Reviews
164
Answers
4.5
Rating
45
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급 (서울문화예술대학교)
All
18 lectures ∙ (2hr 35min)
Course Materials:
All
2 reviews
$42.90
Check out other courses by the instructor!
Explore other courses in the same field!