Learn how to simplified HR Reports

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

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 Excel
  • Be better able to handle text data
  • Maximize the benefits of filters
  • Be more confident in creating Excel reports
  • Know how to use validation to ensure database integrity
  • Be able to make fast decision with the use of the logical function
  • Learn how to extract relevant data with LOOKUP functions
  • Ensure they obtain data consistency with functions
  • Analyzing Data with Statistical and Math Functions
  • Work with Date Functions
  • Know how to explore various possibilities with “What IF analysis"?
  • Merging Data from Multiple Worksheets
  • Know how to analyzing data with pivot table
  • Identify the differences between custom formatting vs. conditional formatting
  • Gain confidence and learn valuable tips

Who this course is for:

  • Anyone who wants to learn how to simplify HR reports
  • Human Resource department

Course content

13 sections • 29 lectures • 3h 52m total length
  • Create more convenient reports Curated for the Udemy Business collection Requirements You should be able to use Microsoft Excel Description 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 Excel Be better able to handle text data Maximize the benefits of filters Be more confident in creating Excel reports Know how to use validation to ensure database integrity Be able to make fast decision with the use of the logical function Learn how to extract relevant data with LOOKUP functions Ensure they obtain data consistency with functions Analyzing Data with Statistical and Math Functions Work with Date Functions Know how to explore various possibilities with “What IF analysis"? Merging Data from Multiple Worksheets Know how to analyzing data with pivot table Identify the differences between custom formatting vs. conditional formatting Gain confidence and learn valuable tips Who this course is for: Anyone who wants to learn how to simplify HR reports Human Resource department Show more Show less Course content 13 sections • 29 lectures • 3h 52m total length Expand all sections Formula Guidelines 1 lecture • 24min Formula Guidelines Preview 23:34 Eliminate Unwanted Data 3 lectures • 18min Working With Table 05:13 Working With Filter 08:49 Remove Duplicates 04:26 Extract Relevant Data With LOOKUP Functions 3 lectures • 24min LookUP Function 06:39 Match Function 10:36 Index Function 07:12 Making Fast Decision With Logical Function 2 lectures • 14min IF Function 09:23 IF Error 05:05 Ensuring Data Consistency With Function 1 lecture • 6min Ensuring Data Consistency With Function 06:11 Using Validation To Ensure Database Integrity 1 lecture • 12min Using Validation To Ensure Database Integrity 12:23 Analyzing Data With Statistical And Math Functions 5 lectures • 34min Analyzing Data With Statistical And Math Functions 07:14 Average VS AverageA 04:49 Count IF VS Count IFS 07:40 AverageIF VS AverageIFS 06:57 SUMIF VS SUMIFS 07:18 Working With Data Functions 3 lectures • 11min Date Function Part1 - Date Calculation 02:13 Date Function Part2 - Use Date Function 03:37 Date Function Part3 - Calculate A Period Of Time Between Two Dates 05:18 Exploring Various Possibilities With What IF Analysis 4 lectures • 33min What Is IF Analysis - Scenarios 08:44 What Is IF Analysis - Data Table 08:40 What Is IF Analysis - Goal Seek 03:34 What Is IF Analysis - Solver 12:16 Merging Data From Multiple Worksheets 2 lectures • 11min Data Consolidate By Position 05:07 Data Consolidate By Category 06:05 3 more sections Instructor Info Trek Office Specialist Trainer 4.4 Instructor Rating 706 Reviews 6,001 Students 6 Courses Established since 1996 with a proven track record and has now grown to become one of the premier providers in the learning gateway. We provide corporate technology training solutions to businesses of both small to large from programmers to developers to project managers. Although enterprise customers are among our biggest pool, we also extend our services to individual professionals and enthusiasts who look to better themselves with technology skill sets of their choice. Our thirst for knowledge drives us to seek out and embrace new technologies and certifications, as we truly understand the importance of doing so. As technologies advance it, it leads to the emergence of new innovations which serve to enhance our lives and create opportunities for all. We seek to empower individuals with the expertise to be at the forefront of innovation. For we believe that expertise stems from the fortification of experience with education. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678138b04efbe614',m:'97a3e2f92b37fa6db6ccea95357812622464b30e-1627843505-1800-AVTQSROy9i59y6XBGGnbMIVcThiwkWfRdPGOn+5cmWNAfojax6OEpit1H4+rGjo3T6iiCsaW2rutHvljcOfXZlHfNc/sT5PHYYG5Px0Gdo8iEtzdFOABYRkqVlGWtD4wzwd5TkLW4+6o65T5TB7ob+6YNjWPnVXoSWvGiRaxOkRzvvOuzfkqUhH9h646TYKpww==',s:[0x71619b8232,0x21ba06422d],}})();