Learn how to simplified HR Reports

2 Likes Comment

Simplified HR Reports with 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 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 is the target audience?
  • Anyone who wants to learn how to simplify HR reports
  • Human Resource department

Info Tutorials/Courses

  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
  • [Size: 651.7 MB]

Download Tutorials/Courses

Download Link Google Drive Download Link Google Drive 2

 Download Link OneDrive Download Mirror Links

Password : freetuts.download

About the Author: Ho Thi Phuong Thao

I am Ho Thi Phuong Thao, 26 years old. Graduated from Van Hien University with excellent grades. With 4 years of experience in teaching English and many other subjects. I am an English teacher of American English Center in Vietnam. By loving the teacher and sharing the knowledge widely with everyone, I establish the freetuts.download website to help people download completely free courses in all areas of their lives. I hope to receive the donation from readers. Once again sincerely thank you

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

error: Content is protected !!