Please read this as an article at indzara.com/2021/09/hr-kpi-avg-employee-tenure/ Please let me know any HR KPI you would like me to do a video on. Thanks & Best wishes.
Hi, thanks for this video. I'm working in Google sheets and struggling to select my data...I'm lost when selecting data range, select control/T to create a table. Google sheets differs and I could really use your help pls
You are welcome. Some features in Excel are not available in Google Sheets and vice versa. Google sheet does not have tables, hence CTRL+T will not work. You will have to do direct cell reference or create a named range reference. We just uploaded a video for how to create it in Google sheets. Please take a look and let us know your feedback. ua-cam.com/video/RsdRc_j61u8/v-deo.html Thanks & Best wishes.
Initially in the video we are getting the number of month between the start and end date as shown in the video at timestamp 4:23. For days, you directly subtract the end date with the start date and add it with 1 to consider the end date (End date - Start date + 1). Best wishes.
Please read this as an article at indzara.com/2021/09/hr-kpi-avg-employee-tenure/
Please let me know any HR KPI you would like me to do a video on. Thanks & Best wishes.
Thanks So much for this! Worked perfectly! Finance guy got to be a hero to HR department!
You are welcome. Thank you for sharing your valuable feedback.
Best wishes.
Thank u for explaining it in a simple way.. watched almost 6 to 7 videos and ur explanations was In a very simple manner
You are welcome and thank you for sharing your valuable feedback.
Best wishes.
Great explanation! Thank you!
Thank you for sharing your valuable feedback. You are welcome.
Best wishes.
Very helpful and well explained. Thanks
Thank you for sharing your valuable feedback.
Best wishes.
PERFECT. Thank you!
You are welcome.
Best wishes.
Well explained, thank you for this Sir!
Thank you for sharing your valuable feedback and you are welcome.
Best wishes.
Very concise explanation.
Thank you for sharing your valuable feedback.
Best wishes.
Hi, thanks for this video. I'm working in Google sheets and struggling to select my data...I'm lost when selecting data range, select control/T to create a table. Google sheets differs and I could really use your help pls
You are welcome.
Some features in Excel are not available in Google Sheets and vice versa. Google sheet does not have tables, hence CTRL+T will not work. You will have to do direct cell reference or create a named range reference.
We just uploaded a video for how to create it in Google sheets. Please take a look and let us know your feedback. ua-cam.com/video/RsdRc_j61u8/v-deo.html
Thanks & Best wishes.
Please advice how to calculate in case of Months & Days
Initially in the video we are getting the number of month between the start and end date as shown in the video at timestamp 4:23. For days, you directly subtract the end date with the start date and add it with 1 to consider the end date (End date - Start date + 1).
Best wishes.
@@indzara Thank You Sir For Precious Time and Valuable advice
can we do it with simple average formula ,in case of all employees are active
Thank you for watching our video.
Yes, if you have only the active employees, you can use average formula straight forward.
Best wishes.
@@indzara Thank You Thank you Thank You So Much Sir