BPO Tutorials
BPO Tutorials
  • Видео 212
  • Просмотров 1 418 523
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...
Просмотров: 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

Комментарии

  • @Itsdanammm
    @Itsdanammm День назад

    Short and sweet. Worked perfectly.

  • @navisruphus5210
    @navisruphus5210 День назад

    So monthly interest 1% ah?

  • @Kristine-p4i
    @Kristine-p4i 2 дня назад

    Thank you for sharing this!

  • @kewinpatel8517
    @kewinpatel8517 6 дней назад

    Thank you very much

  • @pullagooralakshmi
    @pullagooralakshmi 7 дней назад

    Employers contribution is 3.65 percent ...but when we calculate it gonna be 80 per month so the amt is wrongly enteres in excel

  • @HomeroBaroni
    @HomeroBaroni 11 дней назад

    Amazing! Thanks!

  • @ridhwansaid4703
    @ridhwansaid4703 11 дней назад

    Sangat bermanfaat

  • @prashantthakur9749
    @prashantthakur9749 11 дней назад

    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 ?

  • @fatemazohra546
    @fatemazohra546 14 дней назад

    I didn’t found any template in description. can you provide me?

  • @tahirmahmood7433
    @tahirmahmood7433 14 дней назад

    What if someone starts at 8 am and ends at 8 am the next morning??? Its showing 0, how to get 24 hours duration?

  • @1Kevlar
    @1Kevlar 15 дней назад

    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?

  • @priyankaghosal8967
    @priyankaghosal8967 15 дней назад

    Can you pls give me the template to download?

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 15 дней назад

      You can download directly, once you click the link, file will open, click file, you get option to download

  • @PSneha-vq7tm
    @PSneha-vq7tm 16 дней назад

    Thank you ☺️

  • @highdreams2985
    @highdreams2985 21 день назад

    Thanks

  • @Rimpamodal9312
    @Rimpamodal9312 22 дня назад

    Your voice is soo low

  • @kvlakshminarayana5922
    @kvlakshminarayana5922 26 дней назад

    No sound

  • @mariemloiy9811
    @mariemloiy9811 28 дней назад

    That's the best and the easiest and the most accurate

  • @darrynpickstone4621
    @darrynpickstone4621 28 дней назад

    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

  • @mremerpus1
    @mremerpus1 29 дней назад

    organize

  • @ADHYA839
    @ADHYA839 29 дней назад

    Bro I don’t understand what kind of interest does mutual fund provide? Without nav it’s look not possible for calculation

  • @chetankapil6917
    @chetankapil6917 29 дней назад

    Not working

  • @sherifossman
    @sherifossman Месяц назад

    What Bell curve allowed means?

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 Месяц назад

      Allowed means as per HR policy, grades allowed for each grade based on the company policy

  • @ShailabalaPradhan-x6s
    @ShailabalaPradhan-x6s Месяц назад

    It's great..

  • @saikatkar1459
    @saikatkar1459 Месяц назад

    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.

  • @swapnanerella9257
    @swapnanerella9257 Месяц назад

    What is the 15

  • @Anon_vapist
    @Anon_vapist Месяц назад

    Bro can we get template of this excel

  • @bullcartle7901
    @bullcartle7901 Месяц назад

    How to create this table please help

  • @AjayGupta-li2hr
    @AjayGupta-li2hr Месяц назад

    Nice buddy

  • @AdithyaSrivathsa2025
    @AdithyaSrivathsa2025 Месяц назад

    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.

  • @PrabhatElectoVision
    @PrabhatElectoVision Месяц назад

    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

  • @bipinsingh875
    @bipinsingh875 Месяц назад

    Thanks for helping us

  • @aglgaming1919
    @aglgaming1919 Месяц назад

    Thanks bro

  • @vipulbansal5895
    @vipulbansal5895 Месяц назад

    plesase give access

  • @zaheerali2660
    @zaheerali2660 Месяц назад

    Perfect ❤

  • @27oslec
    @27oslec Месяц назад

    Tnx! This is what i am looking for

  • @RDR-z4i
    @RDR-z4i Месяц назад

    When I downloaded the file, the macro button is not visible. I already enabled all the macro settings.

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 Месяц назад

      I just tried, it works for me, plz download to ur local drive and then reopen

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 Месяц назад

      Due to macro disable, it may be not working for u

    • @RDR-z4i
      @RDR-z4i Месяц назад

      @@uexcelinmsoffice4323 Okay let me try again. Thanks for responding!

  • @WaqasAli-nl7kz
    @WaqasAli-nl7kz 2 месяца назад

    Very nice

  • @SailajaSahu-e4u
    @SailajaSahu-e4u 2 месяца назад

    Wrong

  • @wilkinkansara5492
    @wilkinkansara5492 2 месяца назад

    This excel sheet not open properly pls resend

  • @bhavneshparikh8283
    @bhavneshparikh8283 2 месяца назад

    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

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 2 месяца назад

      It's a good requirement, we can do it, let me try to do it n publish

  • @barryberg2944
    @barryberg2944 2 месяца назад

    Just add a ' before it

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 2 месяца назад

      Can u plz explain further more, I am unable to understand

  • @ian.the.nobody
    @ian.the.nobody 2 месяца назад

    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

  • @mayurjain6486
    @mayurjain6486 2 месяца назад

    Thanks for great learning

  • @surajpatra8918
    @surajpatra8918 2 месяца назад

    it would have been helpful if you would have explained in numbers format instead of excel

  • @mohann664
    @mohann664 2 месяца назад

    Hi Sir, why my interest of 2023-2024 is not yet credited in my account? when I get that?

  • @rupeshbhagwatkar33
    @rupeshbhagwatkar33 2 месяца назад

    formula not working

  • @mathfobia
    @mathfobia 2 месяца назад

    Wrong file in description link. Some other excel sheet uploaded.

  • @CastroKali-c5x
    @CastroKali-c5x 2 месяца назад

    What if volume is not equally divisible by no of users How to allocate average no of volume to each

  • @DeepakfromWorldRef
    @DeepakfromWorldRef 3 месяца назад

    Best Video

  • @JanLorenzAcero
    @JanLorenzAcero 3 месяца назад

    Hi, can i get the formula for AO and AM. i have the same scenario/project to make. thanks a lot

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 3 месяца назад

      Hi, plz download the excel file and unhide columns from AL to AX. U can see formula, its little complex but not difficult