HR Knowledge Corner

Gateway to HR Processes,Practices and Concepts.

Menu

Skip to content
  • Home
  • About
  • Articles
    • Diversity and Inclusion
    • Employee Deposit Linked Scheme (EDLI)
    • Features of a Group Mediclaim Policy
    • Gallup Survey
    • KRA and KPI
    • Maternity Act
    • Statutory Bonus
    • Total Rewards System
    • Provident Fund
  • Dashboards
    • Dynamic Employee Count.
    • Joinee & Resignee – Select By Year
    • Product Rating Chart (Five Star Rating)
    • Sales Data – From a particular month to a particular month.
  • Excel Macros
    • Examples
    • Excel Macros Series 1: Extract Active Employee Data & conditionally format extracted records
    • Excel Macros Series 2: Calculate the total paid days from the attendance roster for a particular month
    • Excel Macros Series 3: Create Pivot Charts to get employee count across locations via department.
  • HR Processes
    • Absenteeism
    • Attendance and Leave Management
    • Joining and Onboarding
    • Manpower Planning
    • Set up an HR Department
    • Personal File
    • Exit Process
  • Compensation
    • Cost to Company
    • Profits in lieu of salary
    • Develop a Compensation Strategy
    • Basic Salary & DA
    • Allowances
    • House Rent Allowance
    • Leave Travel Allowance
  • Perquisites
    • Company Leased Accommodation
    • Hotel Accommodation
    • Motor Car
  • Job Evaluation
  • Salary Processing
  • Exit Benefits
    • Gratuity
    • Leave Encashment
    • Pension
    • Retrenchment Compensation
    • Superannuation
    • Voluntary Retirement Scheme
  • Contact us

Examples

1.Extract Active Employee Data & conditionally format extracted records

http://www.hrknowledgecorner.com/excel-macros-extract-active-employee-data-conditionally-format-extracted-records/

2.Excel Macros Series 2: Calculate the total paid days from the attendance roster for a particular month

http://www.hrknowledgecorner.com/excel-macros-series-2-calculate-total-paid-days-attendance-roster-particular-month/

Recent Posts

  • Employee Attrition September 2, 2021
  • Attrition % with a Scroll Bar August 29, 2021
  • Attrition % in a Line Chart August 29, 2021
  • Waterfall Chart – Employee Head Count. August 27, 2021
  • Employee Tenure in a Sorted Bar Chart August 27, 2021
  • Population Chart ( Age Distribution and Gender Count) August 25, 2021
  • Infographics using Male Female Icons August 25, 2021
  • Attrition % in a Bullet Chart August 25, 2021
  • Attrition – Using Gauge Chart August 15, 2021
  • Introduction – Variance Analysis August 9, 2021
  • Column Donut Chart August 8, 2021
  • Butterfly / Tornado Chart August 8, 2021
  • Employee Quarter Wise Headcount Using Option Charts August 6, 2021
  • Chart within Chart August 6, 2021
  • Actual Vs Budget Chart October 17, 2018

HR Knowledge Corner

  • About
  • Articles
    • Diversity and Inclusion
    • Employee Deposit Linked Scheme (EDLI)
    • Features of a Group Mediclaim Policy
    • Gallup Survey
    • KRA and KPI
    • Maternity Act
    • Statutory Bonus
    • Total Rewards System
    • Provident Fund
  • Dashboards
    • Dynamic Employee Count.
    • Joinee & Resignee – Select By Year
    • Product Rating Chart (Five Star Rating)
    • Sales Data – From a particular month to a particular month.
  • Excel Macros
    • Examples
    • Excel Macros Series 1: Extract Active Employee Data & conditionally format extracted records
    • Excel Macros Series 2: Calculate the total paid days from the attendance roster for a particular month
    • Excel Macros Series 3: Create Pivot Charts to get employee count across locations via department.
  • Home
  • HR Processes
    • Absenteeism
    • Attendance and Leave Management
    • Joining and Onboarding
    • Manpower Planning
    • Set up an HR Department
    • Personal File
    • Exit Process
  • Compensation
    • Cost to Company
    • Profits in lieu of salary
    • Develop a Compensation Strategy
    • Basic Salary & DA
    • Allowances
    • House Rent Allowance
    • Leave Travel Allowance
  • Perquisites
    • Company Leased Accommodation
    • Hotel Accommodation
    • Motor Car
  • Job Evaluation
  • Salary Processing
  • Exit Benefits
    • Gratuity
    • Leave Encashment
    • Pension
    • Retrenchment Compensation
    • Superannuation
    • Voluntary Retirement Scheme
  • Contact us

Archives

  • September 2021
  • August 2021
  • October 2018
Proudly powered by WordPress | Theme: Bouquet by WordPress.com.
error: Content is protected !!