|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-automating-hr-payroll-reports-with-power-query/
课程评论：没有评论
课程名称：Excel：使用Power Query自动化人力资源薪资报告 课程概述：您是否在加班，花费过多时间在非增值任务上准备报告？您正在寻找一个实践性强、逐步指导的课程来帮助您自动化人力资源薪资报告吗？或者您是否希望简化、自动化并掌控人员成本的预算和预测流程？您已经找到了合适的课程！《微软Excel：使用Power Query自动化人力资源薪资报告》是一门专为商业和人力资源专业人士（如薪酬与福利专员、薪资专业人员、人力资源专员、会计师、财务分析师、客户经理、学生等）定制的在线课程，旨在自动化耗时的薪资报告流程。该课程基于一个案例研究，解决了在准备每月薪资报告、预算和预测过程中遇到的各种实际问题。它提供了使用数据透视表和Power Query的一些简明方法和技巧来自动化薪资报告。一旦掌握了自动化概念，您可以轻松复用并应用于其他类型的报告。 课程完成后，您将能够： - 使用微软Excel和Power Query自动化薪资报告的准备； - 学习商业和人力资源专业人士所需的Power Query和数据透视表技能； - 节省来自非增值常规任务的时间，将节省下来的时间用于更有价值的分析任务； - 以及时且高度准确的报告给您的上司留下深刻印象。 教学方法： - 视频：19个视频，设计用于解释概念，并提供逐步的实施说明，帮助学员使用微软Excel和Power Query自动化薪资报告。 - 可下载的Excel文件：每节课中使用的数据、练习文件和解决方案。 - 小测验：用于复习和确认对每个学习模块的理解。 课程包含5个模块，共19节课，视频时长4.5小时。您可以下载工作文件以进行实践，并且每个模块结束时会有小测验以评估您对所学内容的理解。 课程模块概述： - 模块1：学习如何管理杂乱的原始数据和映射表，使用Power Query上传和清理数据。 - 模块2：创建薪资计算器，并管理计算薪资的规则，通过简单的公式自动化薪资报告。 - 模块3：自动化创建薪资分析，轻松生成动态薪资报告。 - 模块4：为财务部门自动化创建薪资报告，并嵌入未来月份数据以减少维护。 - 模块5：创建和管理人员成本的预算和预测练习，将前4个模块的概念应用于预算和预测流程。 该课程以简单易懂的方式展示了简化和自动化薪资及人员成本（实际和预算/预测数据）过程的逐步方法。因此，不要再花费过多时间在重复且无价值的任务上。您可以轻松地在Excel中创建自己的薪资报告。现在就采取行动，获取能够让您在竞争中脱颖而出的技能！立即点击“购买”按钮，开启改变！
Are you working overtime, spending too much time on non value adding tasks to prepare reports? You are looking for a hands-on, step by step course to help you automate your HR Payroll reporting? Or are you looking for a course to simplify, automate and be in control of the budget and forecast process for Personnel Cost? You've found it here! Microsoft Excel: Automating HR Payroll Reports with Power Query is a custom-made online course for Business and Human Resources Professionals i.e. Compensation & Benefits Specialists, Payroll Professionals, Human Resources Professionals, Accountants, Finance Analysts, Accounts Executives, students, etc to automate the time consuming payroll reporting process. The course is based on a Case Study developed to address various practical issues encounter during the preparation of monthly payroll reports, budget and forecast exercises. It offers clear and simple ways to automate payroll reports using Pivot Tables and various tips and tricks in Power Query. Once you have grasp the automation concept, you can easily replicate and apply it to other type of reporting as well.After completing this course, you will be able to:use Microsoft Excel and Power Query to automate the preparation of payroll reporting;learn Power Query and Pivot Tables skill required by Business and HR Professionals;save time from non value adding routine tasks and channel the time saved to perform more value adding analysis tasks;impress your bosses with timely and highly accurate reportsTeaching methodology:Video: 19 videos designed to explain the concept with practical step by step instructions to implement the automation of payroll reports using Microsoft Excel and Power QueryDownloadable Excel files: data, practice files and solutions used in each lecture Quizzes: To revise and confirm your understanding of each module learned The course has 5 Modules divided into 19 Lessons with 4.5 hours of video time. You can download the working files to practice along. There will be quizzes at the end of each module to assess your understanding of the lessons learned.The overview of the course is as follows: Module 1The objective of Module 1 is to learn how to manage messy raw data and mapping tables. You will learn how to upload and cleanse data on staff listing and transform it into a database friendly format for ease of automation. You will learn how to perform these tasks using Power Query.Lecture 1: IntroductionLecture 2: Load & Transform Data: Staff ListLecture 3: Managing Mapping Tables - Part 1Lecture 4: Managing Mapping Tables - Part 2Module 2In this module, you will create a Payroll Calculator and manage the rules to calculate payroll. You will learn how to easily automate the payroll reports with various formulas in just a few clicks of the buttons. Lecture 5: Merge Query: "Rules" To Payroll CalculatorLecture 6: Calculate Payroll Using Simple FormulaLecture 7: Calculate Payroll Using Conditional Formula - Part 1Lecture 8: Calculate Payroll Using Conditional Formula - Part 2Lecture 9: Calculate Payroll Using Conditional Formula - Part 3Lecture 10: Calculate Payroll Using Conditional Formula - {art 4Module 3The objective of Module 3 is to automate the creation of Payroll Analysis. You will learn how to easily automate the create a dynamic payroll reports with just a few simple clicks. Lecture 11: Creating Payroll AnalysisModule 4The objective of Module 4 is to automate the creation of Payroll Reports for Finance Department. You will learn how to easily automate the create a dynamic payroll reports with just a few simple. In this Module, you will also learn how to embed future months data into the Payroll Calculator which requires minimal maintenance. You will see how easily it is to load new dataset into the model and appreciate thee time saved from automation.Lecture 12: Creating Payroll Reports for Finance DepartmentLecture 13: Update and Consolidate Monthly Payroll DataModule 5Module 5 is about creating and managing the budget and forecast exercises for Personnel Costs. You will learn how to apply the concepts in Model 1 to 4 to budget and forecast processes.Lecture 14: Budget & Forecast Exercises - Personnel Cost - Part 1Lecture 15: Budget & Forecast Exercises - Personnel Cost - Part 2Lecture 16: Budget & Forecast Exercises - Personnel Cost - Part 3Lecture 17: Budget & Forecast Exercises - Personnel Cost - Part 4Lecture 18: Personnel Cost Analysis Using Pivot Tables - Part 1Lecture 19: Personnel Cost Analysis Using Pivot Tables - Part 2This course demonstrates the step-by-step process to simply and automate your payroll and personnel costs for both actuals and budget / forecast data in an easy-to-understand approach. So, stop spending too much time doing repetitive and non-value tasks anymore. You can easily create your own payroll in excel.Take actions now to acquire skills that will elevates you from your competitors! Click the "Buy Now" button now to make change happens!
