BPO Tutorials
BPO Tutorials
  • 219
  • 1 500 135
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
Переглядів: 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

КОМЕНТАРІ

  • @akyjaiawal6504
    @akyjaiawal6504 День тому

    Thank you 🙏

  • @akyjaiawal6504
    @akyjaiawal6504 День тому

    Very useful in short time.

  • @kuttymani1424
    @kuttymani1424 3 дні тому

    Sir please tell me ot hours in this type of format

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 3 дні тому

      Can you plz refer this video ua-cam.com/video/iAfgZo1Lhzg/v-deo.html

  • @nagarjuna524
    @nagarjuna524 4 дні тому

    Very good excel. Please provide same sheet for 20/30 Years.

  • @xhahzaibawan8670
    @xhahzaibawan8670 5 днів тому

    Sir discreption mai rakh laiti sheet ko

  • @somnathdas1606
    @somnathdas1606 6 днів тому

    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?

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 6 днів тому

      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

  • @ami-re2lq
    @ami-re2lq 8 днів тому

    Calculator ka formula bta bhai

  • @ivanv-n3152
    @ivanv-n3152 9 днів тому

    Great Video!! What does it mean Brkg? Thanks

  • @premasubramanian1486
    @premasubramanian1486 10 днів тому

    Excellent sheet and clearly explained.Thank you🙏

  • @thedreamers4892
    @thedreamers4892 10 днів тому

    Pura Gratuity amt one time payment hoga ???

  • @thedreamers4892
    @thedreamers4892 10 днів тому

    Pura Gratuity amt one time payment hoga ???

  • @LoAPaul
    @LoAPaul 11 днів тому

    Thank you for making it so easy and fast.

  • @pranalighorpade4756
    @pranalighorpade4756 11 днів тому

    it is showing the same # value

  • @Avyukt-AN
    @Avyukt-AN 12 днів тому

    Thank you.

  • @KManishGowda
    @KManishGowda 14 днів тому

    chit fund is regulated under chit fund act 1982 get facts right dude have you ever hear about registered chit funds

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 14 днів тому

      Hello Sir, you are right but we are taking here about unorganized Chit funds

  • @avinashdegloorkar2581
    @avinashdegloorkar2581 15 днів тому

    Thank you so much. you have covered very important topic.

  • @tiffanymazzola1745
    @tiffanymazzola1745 16 днів тому

    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.

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 15 днів тому

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

  • @krns_gaming8291
    @krns_gaming8291 17 днів тому

    HOW TO CONVERT ROUND UP 142.5 TO 143

  • @Miangul_Syedofficial
    @Miangul_Syedofficial 19 днів тому

    Write 1/11 😂

  • @sidhantmaurya8744
    @sidhantmaurya8744 20 днів тому

    thanks but while removing full numbers raw (unwanted), entire mask create raw is showing as REF. kindly confirm.

  • @HimalayaMallBhavnagar
    @HimalayaMallBhavnagar 20 днів тому

    PASSWORD

  • @Itsdanammm
    @Itsdanammm 23 дні тому

    Short and sweet. Worked perfectly.

  • @navisruphus5210
    @navisruphus5210 23 дні тому

    So monthly interest 1% ah?

  • @Kristine-p4i
    @Kristine-p4i 24 дні тому

    Thank you for sharing this!

  • @kewinpatel8517
    @kewinpatel8517 28 днів тому

    Thank you very much

  • @pullagooralakshmi
    @pullagooralakshmi 29 днів тому

    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 Місяць тому

    Amazing! Thanks!

  • @ridhwansaid4703
    @ridhwansaid4703 Місяць тому

    Sangat bermanfaat

  • @fatemazohra546
    @fatemazohra546 Місяць тому

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

  • @tahirmahmood7433
    @tahirmahmood7433 Місяць тому

    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 Місяць тому

    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 Місяць тому

    Can you pls give me the template to download?

    • @uexcelinmsoffice4323
      @uexcelinmsoffice4323 Місяць тому

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

  • @PSneha-vq7tm
    @PSneha-vq7tm Місяць тому

    Thank you ☺️

  • @highdreams2985
    @highdreams2985 Місяць тому

    Thanks

  • @Rimpamodal9312
    @Rimpamodal9312 Місяць тому

    Your voice is soo low

  • @kvlakshminarayana5922
    @kvlakshminarayana5922 Місяць тому

    No sound

  • @mariemloiy9811
    @mariemloiy9811 Місяць тому

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

  • @darrynpickstone4621
    @darrynpickstone4621 Місяць тому

    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 Місяць тому

    organize

  • @ADHYA839
    @ADHYA839 Місяць тому

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

  • @chetankapil6917
    @chetankapil6917 Місяць тому

    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 2 місяці тому

    Nice buddy

  • @AdithyaSrivathsa2025
    @AdithyaSrivathsa2025 2 місяці тому

    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 2 місяці тому

    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