- 219
- 1 500 135
BPO Tutorials
India
Приєднався 5 сер 2021
Excel Vlookup Tutorial - Everything You Need To Know
Download the file from the below mentioned link
docs.google.com/spreadsheets/d/1HJCoE57cH8NEiz8a326ydNvPASmp2RyD/edit?usp=sharing&ouid=101158324406109745296&rtpof=true&sd=true
My Channel
ua-cam.com/channels/JhxjPLTfxq0rQJj8Rd-73A.html
docs.google.com/spreadsheets/d/1HJCoE57cH8NEiz8a326ydNvPASmp2RyD/edit?usp=sharing&ouid=101158324406109745296&rtpof=true&sd=true
My Channel
ua-cam.com/channels/JhxjPLTfxq0rQJj8Rd-73A.html
Переглядів: 149
Відео
Difference Between Percentage and Percentile (with Examples)
Переглядів 6619 годин тому
My Channel ua-cam.com/channels/JhxjPLTfxq0rQJj8Rd-73A.html What is the Difference Between Percentage and Percentile? Percentage and percentile are two different concepts because percentage shows the individual score out of 100 while percentile shows a comparison. Percentage tells us the value in terms of 100, and percentile is a relative quantity that shows us a comparison of the given value wi...
Master Stock Buy & Sell Tracking in Excel - Excel for Investors: Track Your Stock Buys & Sells
Переглядів 36114 днів тому
My Channel ua-cam.com/channels/JhxjPLTfxq0rQJj8Rd-73A.html Looking for an easy way to track your stock buys and sells? In this video, we guide you through a simple Excel tutorial to efficiently manage and maintain your stock trading data. This tool will help you monitor profits, losses, and market trends with ease. Perfect for both beginners and experienced traders who want a custom solution fo...
How To Calculate Working Day in Excel Excluding Weekends and Holidays - Business Day In Excel
Переглядів 9421 день тому
My Channel ua-cam.com/channels/JhxjPLTfxq0rQJj8Rd-73A.html ua-cam.com/video/SWbIIyHbcgo/v-deo.html Calculate #Marks Percentage In Excel Short Video ua-cam.com/users/shortso_lEiOuWdGw EMI Calculator For Car And Bike In Excel - EMI Calculation formula ua-cam.com/video/Bx7gmD5cJdc/v-deo.html Calculate Attrition Percentage In Excel - Excel Short Video ua-cam.com/users/shortsUMvqKSsr5yI #Short Excel...
How to Insert Header and Footer in Excel
Переглядів 107Місяць тому
My Channel ua-cam.com/channels/JhxjPLTfxq0rQJj8Rd-73A.html Excel Time & Motion study template - Calculate bench mark & productivity & set the targets ua-cam.com/video/L4M9znOieeM/v-deo.html EMI - Housing/Home Loan - How to repay loan quickly/faster - repayment - Save interest amount ua-cam.com/users/shortsVOI71KnvnME Excel short video - Calculate revised price - Percentage increase ua-cam.com/u...
Don't Drag It In Excel - Instead Use This Tricks
Переглядів 68Місяць тому
My Channel ua-cam.com/channels/JhxjPLTfxq0rQJj8Rd-73A.html Excel Time & Motion study template - Calculate bench mark & productivity & set the targets ua-cam.com/video/L4M9znOieeM/v-deo.html EMI - Housing/Home Loan - How to repay loan quickly/faster - repayment - Save interest amount ua-cam.com/users/shortsVOI71KnvnME Excel short video - Calculate revised price - Percentage increase ua-cam.com/u...
3 Ways to Remove Commas From Text Value In Excel
Переглядів 104Місяць тому
My Channel ua-cam.com/channels/JhxjPLTfxq0rQJj8Rd-73A.html
Count Checked Checkboxes in Excel | Sum if Checkbox is Checked | Formula to Count Checked Checkboxes
Переглядів 97Місяць тому
Count Checked Checkboxes in Excel | Sum if Checkbox is Checked | Formula to Count Checked Checkboxes
How To Create Control Chart In Excel - BPO Tutorial -
Переглядів 67Місяць тому
How To Create Control Chart In Excel - BPO Tutorial -
Split Address Into Different Rows Using TextSplit Function In Excel
Переглядів 39Місяць тому
Split Address Into Different Rows Using TextSplit Function In Excel
How to Calculate SIP Returns Using XIRR Formula in Excel | Time-Based SIP Return Calculation
Переглядів 227Місяць тому
How to Calculate SIP Returns Using XIRR Formula in Excel | Time-Based SIP Return Calculation
How to Calculate Weighted Averages in Excel: Using SUMPRODUCT to Calculate Weighted Average
Переглядів 1262 місяці тому
How to Calculate Weighted Averages in Excel: Using SUMPRODUCT to Calculate Weighted Average
How to Convert Time to Hours, Minutes, and Seconds In Excel - Convert Time to a Number
Переглядів 1112 місяці тому
How to Convert Time to Hours, Minutes, and Seconds In Excel - Convert Time to a Number
Extract Day, Month And Year From Date In Excel
Переглядів 912 місяці тому
Extract Day, Month And Year From Date In Excel
Excel Recognizes Dates - Understanding Excel Date Equivalents: How Excel Recognizes Dates as Numbers
Переглядів 672 місяці тому
Excel Recognizes Dates - Understanding Excel Date Equivalents: How Excel Recognizes Dates as Numbers
How To Create An Action Item Log Template In Excel
Переглядів 1682 місяці тому
How To Create An Action Item Log Template In Excel
Creating a Progress Bar Chart in Excel: Step-by-Step Tutorial
Переглядів 1372 місяці тому
Creating a Progress Bar Chart in Excel: Step-by-Step Tutorial
Text Split Function to exclude all the special characters {"@",":","#","$","%","&","*","-"}
Переглядів 872 місяці тому
Text Split Function to exclude all the special characters {"@",":","#","$","%","&","*","-"}
Annualized Rate of Return Formula in Excel - Return on Investment?
Переглядів 812 місяці тому
Annualized Rate of Return Formula in Excel - Return on Investment?
Excel Column Autofit Width - Change the width of a column automatically in Excel
Переглядів 622 місяці тому
Excel Column Autofit Width - Change the width of a column automatically in Excel
How to Calculate Your GPA Using Excel: Easy Step-by-Step Guide
Переглядів 722 місяці тому
How to Calculate Your GPA Using Excel: Easy Step-by-Step Guide
Cost Of Poor Quality COPQ Template Free For Download - Understanding the Cost of Poor Quality (COPQ)
Переглядів 762 місяці тому
Cost Of Poor Quality COPQ Template Free For Download - Understanding the Cost of Poor Quality (COPQ)
Australian Age Pension Income and Asset tests - 2024
Переглядів 2 тис.2 місяці тому
Australian Age Pension Income and Asset tests - 2024
Make Multiple Dependent Dropdown Lists in Excel
Переглядів 712 місяці тому
Make Multiple Dependent Dropdown Lists in Excel
How to separate texts and numbers from one cell to two columns in excel
Переглядів 363 місяці тому
How to separate texts and numbers from one cell to two columns in excel
How To Remove First Character In Excel - Right & Len Function In Excel
Переглядів 443 місяці тому
How To Remove First Character In Excel - Right & Len Function In Excel
Is One Vlookup enough to get three columns data - Advance Vlookup Formula
Переглядів 833 місяці тому
Is One Vlookup enough to get three columns data - Advance Vlookup Formula
How to Remove Middle Name from Full Name in Excel | Easy Excel Tutorial
Переглядів 493 місяці тому
How to Remove Middle Name from Full Name in Excel | Easy Excel Tutorial
How to Count Cells by Color in Microsoft Excel - Count Colored Cells
Переглядів 1583 місяці тому
How to Count Cells by Color in Microsoft Excel - Count Colored Cells
Landlord template -Track rental property in excel Rental Property Income & Expense Tracking Template
Переглядів 5773 місяці тому
Landlord template -Track rental property in excel Rental Property Income & Expense Tracking Template
Thank you 🙏
You’re welcome 😊
Very useful in short time.
I am glad that it was helpful for you
Sir please tell me ot hours in this type of format
Can you plz refer this video ua-cam.com/video/iAfgZo1Lhzg/v-deo.html
Very good excel. Please provide same sheet for 20/30 Years.
Sir, you just need to extend the formula
Sir discreption mai rakh laiti sheet ko
Thank you, however wanted to know why we pulled Total Time Required(In Seconds) When at the last we divide calls per agent from volume only?
Since AHT in seconds, entire calculation is performed in second, if AHT was in minutes, calculation would have been in minutes. Then average volume per FT is calculated by dividing total time available against AHT. Later, divided by volume against calls per agent to know FTE's requirement
Calculator ka formula bta bhai
You can download the file and chech the file
Great Video!! What does it mean Brkg? Thanks
Brkg means brokerage, thank you
Excellent sheet and clearly explained.Thank you🙏
Glad that it was helpful for you
Pura Gratuity amt one time payment hoga ???
Yes if employee leave the organization
@@uexcelinmsoffice4323 ty
Pura Gratuity amt one time payment hoga ???
Yes
Thank you for making it so easy and fast.
You are welcome
it is showing the same # value
Plz chech formula again, it should work
Thank you.
You are welcome
chit fund is regulated under chit fund act 1982 get facts right dude have you ever hear about registered chit funds
Hello Sir, you are right but we are taking here about unorganized Chit funds
Thank you so much. you have covered very important topic.
I am glad that it was helpful for yiu
How do I get the template download??? This is fabulous. I was looking for something easy our managers could just put in minimal information to produce bell curve.
You can directly, once you click the link, file will open, click file, you get option to download
HOW TO CONVERT ROUND UP 142.5 TO 143
You can use round function in excel to convert
Write 1/11 😂
thanks but while removing full numbers raw (unwanted), entire mask create raw is showing as REF. kindly confirm.
PASSWORD
Short and sweet. Worked perfectly.
So monthly interest 1% ah?
Thank you for sharing this!
You are welcome
Thank you very much
You are welcome
Employers contribution is 3.65 percent ...but when we calculate it gonna be 80 per month so the amt is wrongly enteres in excel
Amazing! Thanks!
Thank you Sir for your appreciation
Sangat bermanfaat
Glad that it was helpful for you
I didn’t found any template in description. can you provide me?
What if someone starts at 8 am and ends at 8 am the next morning??? Its showing 0, how to get 24 hours duration?
Your formula is not correct. if you were to do the math manually, you would see the total hours worked is 8.5 hours and NOT 8:30 hours. I have no idea to change the format to h:mm in excel. When I do, it does not work, however if I only have one formula, such as =(b2-b1)*24 will work, however when I add the secondary portion of the off for lunch will not work?
ua-cam.com/video/iAfgZo1Lhzg/v-deo.html
Plz refer this video, this is in more detail
Can you pls give me the template to download?
You can download directly, once you click the link, file will open, click file, you get option to download
Thank you ☺️
You are welcome
Thanks
You are welcome
Your voice is soo low
No sound
That's the best and the easiest and the most accurate
Thank you so much
Hi, im 61 years of age australian born and living off my super and bank savings at moment over in Philippines since 2022 as i couldnt afford to live in australia etc. My question is do i need to be living back in australia to get the pension, what i have read is that i need to be back in australia for 2 years prior to receiving the age pension, or is it 2 years after the age of 67 years ? so i dont loose the pension when i move back overseas ?? Any help or ideas please . thanks When does the yearly cycle start from which Month > so i can organise my return around the date .thanks
organize
Bro I don’t understand what kind of interest does mutual fund provide? Without nav it’s look not possible for calculation
Not working
What Bell curve allowed means?
Allowed means as per HR policy, grades allowed for each grade based on the company policy
It's great..
Glad that it was helpful
Jatin shah and his 3 partners in Skill India are just trying to fool people ONLINE with their below-par workshops. Its sheer ONLINE fraud beware.
What is the 15
15 represent half of the salary
Bro can we get template of this excel
How to create this table please help
Nice buddy
Glad you liked it
I will explain it in simple terms. We need to calculate the cost of the manual process and the cost of automation. Then, subtract the cost of automation from the cost of the manual process. There should be a POSITIVE remainder. If so, it's a good candidate for automation. This remainder is called the ROI. We need to calculate it over 5 years for better clarity on how much we will save in that period.
Thanks for sharing
Note : 1. Applicable for employees who earnings >=21000 per month 2. ESI Employees Contribution Rate: 0.75% 3. ESI Employer’s Contribution Rate: 3.25% Total ESI Contribution = Employer’s Contribution + Employees Contribution Sl # Employee Gross Salary ESI Eligible Employee Contribution(0.75%) Employer Contribution(3.25%) Total Contribution Towards ESI (P.M) 1 Employee 1 ₹ 10,000.00 Not Eligible ₹ 0.00 FALSE ₹ 0.00 2 Employee 2 ₹ 13,000.00 Not Eligible ₹ 0.00 FALSE ₹ 0.00 3 Employee 3 ₹ 16,000.00 Not Eligible ₹ 0.00 FALSE ₹ 0.00 4 Employee 4 ₹ 19,000.00 Not Eligible ₹ 0.00 FALSE ₹ 0.00 5 Employee 5 ₹ 25,000.00 Eligible ₹ 187.50 ₹ 812.50 ₹ 1,000.00 6 Employee 6 ₹ 30,000.00 Eligible ₹ 225.00 ₹ 975.00 ₹ 1,200.00 7 Employee 7 ₹ 40,000.00 Eligible ₹ 300.00 ₹ 1,300.00 ₹ 1,600.00