- Видео 212
- Просмотров 1 418 523
BPO Tutorials
Индия
Добавлен 5 авг 2021
How To Calculate Working Day in Excel Excluding Weekends and Holidays - Business Day In Excel
My Channel
ruclips.net/channel/UCJhxjPLTfxq0rQJj8Rd-73A
ruclips.net/video/SWbIIyHbcgo/видео.html
Calculate #Marks Percentage In Excel Short Video
ruclips.net/user/shortso_lEiOuWdGw
EMI Calculator For Car And Bike In Excel - EMI Calculation formula
ruclips.net/video/Bx7gmD5cJdc/видео.html
Calculate Attrition Percentage In Excel - Excel Short Video
ruclips.net/user/shortsUMvqKSsr5yI
#Short Excel Video - How to Calculate Sales Price After Discount in Excel
ruclips.net/user/shortsud6zRrcsScY
How to Create Email Address in Excel - Excel Short Video - Smart Trick In Excel
ruclips.net/user/shortsG07d8wh4akc
How to Calculate Percent Change - #Short - Find percentage difference between two numbers - In Excel
ru...
ruclips.net/channel/UCJhxjPLTfxq0rQJj8Rd-73A
ruclips.net/video/SWbIIyHbcgo/видео.html
Calculate #Marks Percentage In Excel Short Video
ruclips.net/user/shortso_lEiOuWdGw
EMI Calculator For Car And Bike In Excel - EMI Calculation formula
ruclips.net/video/Bx7gmD5cJdc/видео.html
Calculate Attrition Percentage In Excel - Excel Short Video
ruclips.net/user/shortsUMvqKSsr5yI
#Short Excel Video - How to Calculate Sales Price After Discount in Excel
ruclips.net/user/shortsud6zRrcsScY
How to Create Email Address in Excel - Excel Short Video - Smart Trick In Excel
ruclips.net/user/shortsG07d8wh4akc
How to Calculate Percent Change - #Short - Find percentage difference between two numbers - In Excel
ru...
Просмотров: 16
Видео
How to Insert Header and Footer in Excel
Просмотров 7919 часов назад
My Channel ruclips.net/channel/UCJhxjPLTfxq0rQJj8Rd-73A Excel Time & Motion study template - Calculate bench mark & productivity & set the targets ruclips.net/video/L4M9znOieeM/видео.html EMI - Housing/Home Loan - How to repay loan quickly/faster - repayment - Save interest amount ruclips.net/user/shortsVOI71KnvnME Excel short video - Calculate revised price - Percentage increase ruclips.net/us...
Don't Drag It In Excel - Instead Use This Tricks
Просмотров 5414 дней назад
My Channel ruclips.net/channel/UCJhxjPLTfxq0rQJj8Rd-73A Excel Time & Motion study template - Calculate bench mark & productivity & set the targets ruclips.net/video/L4M9znOieeM/видео.html EMI - Housing/Home Loan - How to repay loan quickly/faster - repayment - Save interest amount ruclips.net/user/shortsVOI71KnvnME Excel short video - Calculate revised price - Percentage increase ruclips.net/us...
3 Ways to Remove Commas From Text Value In Excel
Просмотров 9621 день назад
My Channel ruclips.net/channel/UCJhxjPLTfxq0rQJj8Rd-73A
Count Checked Checkboxes in Excel | Sum if Checkbox is Checked | Formula to Count Checked Checkboxes
Просмотров 8621 день назад
In this video, we explore an efficient way to manage payments using a checkbox payment tracker. We demonstrate how to keep track of payment status, record remarks, and calculate amounts in a simple, easy-to-use format. Whether you're managing payments for a small business, freelance work, or personal finances, this tutorial provides a quick and effective solution. Stay organized and streamline ...
How To Create Control Chart In Excel - BPO Tutorial -
Просмотров 4728 дней назад
My Channel ruclips.net/channel/UCJhxjPLTfxq0rQJj8Rd-73A Download template from the below link docs.google.com/spreadsheets/d/1pmWeHaeJiYAIdrYzOcEFFfuJl6mP9Lec/edit?usp=sharing&ouid=101158324406109745296&rtpof=true&sd=true Control charts are graphical plots used in production control to determine whether quality and manufacturing processes are being controlled under stable conditions Control cha...
Split Address Into Different Rows Using TextSplit Function In Excel
Просмотров 36Месяц назад
My Channel ruclips.net/channel/UCJhxjPLTfxq0rQJj8Rd-73A Excel Time & Motion study template - Calculate bench mark & productivity & set the targets ruclips.net/video/L4M9znOieeM/видео.html EMI - Housing/Home Loan - How to repay loan quickly/faster - repayment - Save interest amount ruclips.net/user/shortsVOI71KnvnME Excel short video - Calculate revised price - Percentage increase ruclips.net/us...
How to Calculate SIP Returns Using XIRR Formula in Excel | Time-Based SIP Return Calculation
Просмотров 126Месяц назад
Learn the right way to calculate your Systematic Investment Plan (SIP) returns using the XIRR formula in Excel! In this step-by-step tutorial, we’ll show you how to use the XIRR function to accurately account for the time factor in your SIP returns. Unlike traditional methods, XIRR provides a precise way to measure your investment growth based on irregular cash flows over time. Whether you're a...
How to Calculate Weighted Averages in Excel: Using SUMPRODUCT to Calculate Weighted Average
Просмотров 96Месяц назад
Learn how to calculate weighted averages in Excel using a real-world example. This guide walks you through calculating a standard average, and two methods of weighted average calculations based on course scores and their respective weights. Ideal for students, teachers, and professionals looking to enhance their Excel skills. Weighted average is one of the most commonly employed measures in sta...
How to Convert Time to Hours, Minutes, and Seconds In Excel - Convert Time to a Number
Просмотров 90Месяц назад
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
Просмотров 77Месяц назад
Extract Day, Month And Year From Date In Excel
Excel Recognizes Dates - Understanding Excel Date Equivalents: How Excel Recognizes Dates as Numbers
Просмотров 64Месяц назад
Excel Recognizes Dates - Understanding Excel Date Equivalents: How Excel Recognizes Dates as Numbers
How To Create An Action Item Log Template In Excel
Просмотров 133Месяц назад
How To Create An Action Item Log Template In Excel
Creating a Progress Bar Chart in Excel: Step-by-Step Tutorial
Просмотров 111Месяц назад
Creating a Progress Bar Chart in Excel: Step-by-Step Tutorial
Text Split Function to exclude all the special characters {"@",":","#","$","%","&","*","-"}
Просмотров 82Месяц назад
Text Split Function to exclude all the special characters {"@",":","#","$","%","&","*","-"}
Annualized Rate of Return Formula in Excel - Return on Investment?
Просмотров 71Месяц назад
Annualized Rate of Return Formula in Excel - Return on Investment?
Excel Column Autofit Width - Change the width of a column automatically in Excel
Просмотров 55Месяц назад
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
Просмотров 482 месяца назад
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)
Просмотров 642 месяца назад
Cost Of Poor Quality COPQ Template Free For Download - Understanding the Cost of Poor Quality (COPQ)
Australian Age Pension Income and Asset tests - 2024
Просмотров 1,2 тыс.2 месяца назад
Australian Age Pension Income and Asset tests - 2024
Make Multiple Dependent Dropdown Lists in Excel
Просмотров 642 месяца назад
Make Multiple Dependent Dropdown Lists in Excel
How to separate texts and numbers from one cell to two columns in excel
Просмотров 332 месяца назад
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
Просмотров 412 месяца назад
How To Remove First Character In Excel - Right & Len Function In Excel
Is One Vlookup enough to get three columns data - Advance Vlookup Formula
Просмотров 772 месяца назад
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
Просмотров 422 месяца назад
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
Просмотров 1442 месяца назад
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
Просмотров 4762 месяца назад
Landlord template -Track rental property in excel Rental Property Income & Expense Tracking Template
Use Subtotal Function Instead Of Sum Function In Excel
Просмотров 242 месяца назад
Use Subtotal Function Instead Of Sum Function In Excel
How to Create a Petty cash book in excel |How to Create a Petty Cash Account in Excel | Part 1
Просмотров 3222 месяца назад
How to Create a Petty cash book in excel |How to Create a Petty Cash Account in Excel | Part 1
Monthly Budget Excel Spreadsheet - Income, Fixed and Variable Expenses - Plan my household - Part 1
Просмотров 2212 месяца назад
Monthly Budget Excel Spreadsheet - Income, Fixed and Variable Expenses - Plan my household - Part 1
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
How do we calculate the required run rate in excel ? For example ; An agents current score is 80% with 20C and 5D and the target is 85%. So how can we find out the number of CSATs required to meet 85% target ? The answer is 9 but how do we calculate the same on excel ?
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?
ruclips.net/video/iAfgZo1Lhzg/видео.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
Thanks for helping us
You are welcome, I am glad that it is helpful for you
Thanks bro
You are welcome
plesase give access
Plz download the file
Perfect ❤
Thank you so much
Tnx! This is what i am looking for
Glad that it is helpful for you
When I downloaded the file, the macro button is not visible. I already enabled all the macro settings.
I just tried, it works for me, plz download to ur local drive and then reopen
Due to macro disable, it may be not working for u
@@uexcelinmsoffice4323 Okay let me try again. Thanks for responding!
Very nice
Thank you
Wrong
What's wrong in this calculation
This excel sheet not open properly pls resend
Plz mail me, I will send excel file
Can be possible client wise auto update loan amotozation table? Also if possible interest rate change so auto update automatic in excel Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest
It's a good requirement, we can do it, let me try to do it n publish
Just add a ' before it
Can u plz explain further more, I am unable to understand
Shouldn't the agents required AFTER shrinkage be calculated as: FTE / (1 - Shrinkage %) With your calculation of =FTE + (FTE x Shrinkage) = 19.88 agents But with =FTE / (1-Shrinkage %) = 20.33 agents I saw other tutorials wherein they used the second formula instead
Thanks for great learning
Glad that it was helpful for you
it would have been helpful if you would have explained in numbers format instead of excel
I will do it new video
Hi Sir, why my interest of 2023-2024 is not yet credited in my account? when I get that?
You can check with bank plz
formula not working
It should work, may be check the format
Wrong file in description link. Some other excel sheet uploaded.
What if volume is not equally divisible by no of users How to allocate average no of volume to each
If
Best Video
Thank you so much, really appreciate ur response
Hi, can i get the formula for AO and AM. i have the same scenario/project to make. thanks a lot
Hi, plz download the excel file and unhide columns from AL to AX. U can see formula, its little complex but not difficult