by Crispo Mwangi | Aug 26, 2022 | ADVANCED EXCEL, HR
On Linkedin, after sharing my article on 7 Ways to Calculate Income tax, I got a question on how to calculate income tax in Pakistan. Below are their tax brackets USING SUMPRODUCT Step 1: Summarise the above brackets to a table like below Step 2: Use the below formula...
by Crispo Mwangi | Aug 16, 2022 | HR, INTERMEDIATE EXCEL
Benjamin Franklin once said, “in this world, nothing can be said to be certain, except death and taxes”. There is nothing else as certain as these two, (except Failure), yet there are many who are not prepared for them. The question is, given below Tax...
by Joan Tonui | Jun 25, 2022 | HR
What is Employee Turnover? Simply put, employee turnover, or employee turnover rate, is the measurement of the number of employees who leave an organization during a specified time period, typically one year. While an organization usually measures the total number of...
by Joan Tonui | May 22, 2022 | HR
The Human Resources field is witnessing the rise in the use of HR analytics. The power of HR analytics is enabling practitioners to ditch their “gut feeling” for any decision to make — which was the trend earlier — and take more informed and data-backed decisions for...
by Joan Tonui | Nov 13, 2021 | HR
In our everyday life as Human Resources professionals, we encounter large volumes of data that would normally require us to extract some information from. This article highlights some of the basic excel functions that are aimed at making this process simpler and...
Recent Comments