|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-how-to-simplified-hr-reports-like-a-pro/
课程评论：没有评论
课程名称：学习如何简化人力资源报告 课程概述：本课程旨在帮助人力资源人员简化处理各种数据的任务，包括招聘、薪酬、员工福利、劳动力规划和发展项目等。特别适用于需要进行薪资调整和奖金计算的HR工作。学员将接触到在奖金、薪资和增额提案的集体协议谈判中进行“假设”分析的技能。通过本课程，学员将掌握高效管理人力资源数据的技巧与方法，以便给管理层留下深刻印象。学员需要具备基本的微软Windows知识和以下先决条件： - 能够在任务应用程序之间切换 - 能够“创建”、“保存”、“打开”和“打印”电子表格 - 能够使用“撤销”或“重做”功能 - 能够打印带有页眉和页脚的电子表格 - 能够创建简单公式（加法、减法、乘法和除法） - 能够创建基本函数（求和、平均值、计数、最大值和最小值） 完成本课程后，学员将： - 更好地理解Excel中的函数运作 - 能够更有效地处理文本数据 - 最大化使用筛选功能的优势 - 对创建Excel报告更加自信 - 了解如何使用验证以确保数据库的完整性 - 利用逻辑函数做出快速决策 - 学会使用查找函数提取相关数据 - 确保数据一致性 - 使用统计和数学函数分析数据 - 熟悉日期函数 - 探索各种“假设分析”的可能性 - 合并来自多个工作表的数据 - 使用数据透视表进行分析 - 了解自定义格式与条件格式之间的差异 - 增强自信，学习实用技巧 通过本课程，学员将掌握人力资源报告的简化和数据分析技巧，提高工作效率与决策能力。
This program aims to simplify the task of human resource personnel who deal with various types of data, ranging from recruitment, compensation, employee benefit, workforce planning and development programs. It is particularly useful in HR workloads where the HR practitioner needs to perform calculation for salary adjustments and bonus. They will be exposed to "what if" analysis when it comes to a collective agreement on negotiation for bonus, salary and increment proposals for management. Impress your management with the right techniques and skills on how to manage HR data efficiently and to perform the right analysis.Basic Microsoft Windows knowledge is essential with the following pre-requisites: Able to switch between task applications Able to "Create", "Save", "Open" and "Print" spreadsheet Able to use "Undo" or "Redo" function Able to print a spreadsheet with headers and footers added Able to create simple formulas (additional, subtraction, multiplication and division) Able to create simple functions (Sum, Average, Count, Max & Min) Upon completion of this program, participants will: Have a better comprehension on how functions work in ExcelBe better able to handle text dataMaximize the benefits of filtersBe more confident in creating Excel reportsKnow how to use validation to ensure database integrityBe able to make fast decision with the use of the logical functionLearn how to extract relevant data with LOOKUP functionsEnsure they obtain data consistency with functionsAnalyzing Data with Statistical and Math FunctionsWork with Date FunctionsKnow how to explore various possibilities with âWhat IF analysis"?Merging Data from Multiple WorksheetsKnow how to analyzing data with pivot tableIdentify the differences between custom formatting vs. conditional formattingGain confidence and learn valuable tips
