How to calculate Shrinkage and Attrition rate Formula in Excel Hindi

TeachToEach video on how to calculate shrinkage and attrition rate formula in excel Hindi. This trick explains shrinkage and attrition formula in hindi with syntax.

With the help of this video you learn how to calculate shrinkage rate and calculate attrition rate.

How to calculate Shrinkage rate in Call center (BPO)

Formula for Planned Leave = (Planned Leave/ Total Number of Agent)*100

Formula for Unplanned Leave = (Unplanned Leave/ Total Number of Agent)*100

Then add both the shrinkage percentage.

How to calculate Attrition rate in Call center (BPO)

Formula = Total number of Resigned of the month/ (Number of agent at starting + End of the month)/2)*100

It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down.

On youtube, only just few videos are available on this topic of
shrinkage and attrition formula in bpo.

Thanks for watching. It is humble request to you please subscribe my Channel www.youtube.com/teachtoeach

Some popular videos-:

1) Count odd or Even Numbers in Excel Hindi - youtube.com/watch?v=2uobmwaq9BI

2) Countif Formula in Excel Hindi - youtube.com/watch?v=luCGoHvUCg4

3) Count Specific Character Number Space in Excel Hindi - youtube.com/watch?v=wqKQBWJIaDI

4) Offset Match Formula in Excel Hindi - youtube.com/watch?v=FwuZ7OeC3SY

5) Highlight Entire Row and Column in Excel Hindi - youtube.com/watch?v=dJv9V7ZUaUM

6) Double Vlookup in Excel Hindi - youtube.com/watch?v=12KuchYnJPw

7) Index and Match formula in excel hindi - youtube.com/watch?v=BC5ezdIO9wI

8) Split first middle and last name by using formula in excel hindi - youtube.com/watch?v=FJS8yKgnCkM

9) Use of hlookup with match formula in excel in hindi - youtube.com/watch?v=NPq1MEWqRms

10) Create Dependent Drop Down List in Excel Hindi - youtube.com/watch?v=Z1mb1qG75e8

11) How to make a picture lookup in excel - youtube.com/watch?v=y84-JXdJSUQ

12) How to make speedometer in excel hindi - youtube.com/watch?v=5SMFHox1BJo

13) Excel datedif formula in hindi - youtube.com/watch?v=QsFSnOBuKmM

14) Excel countifs formula in hindi - youtube.com/watch?v=43O6-r4raWQ

15) How to use sumproduct formula in excel - youtube.com/watch?v=Ut6myeS5akU

16) Relative Absolute and Mixed Cell Referencing in Excel - youtube.com/watch?v=R3GEbagnbp4

17) Excel Logical Functions IF AND OR NESTED IF in Hindi - youtube.com/watch?v=Us1wr2QrrlM

18) Reverse Lookup Formula Vlookup with Choose Function in Excel - youtube.com/watch?v=n8rcnbOrFYY

19) 2D-Two Dimensional Lookup Formula Vlookup with Match in Excel - youtube.com/watch?v=Rl20i2YoEjI

20) How to consolidate multiple worksheets into Pivot Table - youtube.com/watch?v=OGa6EKTFb5s

21) How to use Vlookup formula in Excel 2013 Hindi By TeachToEach - youtube.com/watch?v=g_mdM26krgA

22) Mail Merge in Word - youtube.com/watch?v=1xuTbaHSYRQ