Module 1: Constructing a HR framework with Excel Tables
Getting your Data Entry Right! Ensure data entry is easier by using Excel Tables. The dynamics of Excel table will enable user to fill and update formulas automatically. This will allow user to structure, view and present data systematically.
Module 2: Formatting your Data Systematically
Learn to construct a standardize format in your HR Application. Apply the flexibility and the dynamics in
entering date format, numerical format, placing of decimals and other formatting features.
Module 3: Data Validation in HR
Understand the way how Data Validation is applied in various HR scenarios and how a HR Practitioner can applying interactive dropdown list, set criterion, limits and rules on what data a user can enter in Excel table.
Module 4: Analysing Data
Manage, organize and summarize data based on your criteria with the Sort and Subtotal features. You may filter and set criterion to extract data that you intend to analyse using the Auto Filter and Advanced Filter features.
Module 5: Functions and Formulas in HR
Extend the use of critical formulas in enhancing work efficiency by understanding Excel Relative Reference, Absolute Reference, Name Range, Sum, Average, Max, Min, Count, SumIf, CountIf, If, And, Or, VLookup and the date functions in managing HR tasks.
Module 6: Creating Visual Presentation with Charts
Learn the basics of charts and determine which charts are relevant in different scenarios. Apply the skills in modifying, adjusting chart and the layouts for an impressive presentation.
Module 7: Summarizing HR Data with PivotTable
Gathering and reporting data is often an important function within organizations, particularly for HR. PivotTable makes HR tasks far more meaningful and easy in managing volumes of data: salary, compensation, bonuses, head-counts and etc. An interactive PivotTable will enable you to analyse data and produce reports on a regular basis. You will also learn to build PivotChart to visually represent PivotTable data.
Module 8: Confidentiality and Data Protection in HR Management
Data Security and confidentiality are the most issues in HR. Learn to safeguard data and information by setting different levels of security measures available in Excel.