Ready XL
Ready XL
  • 4
  • 216 669
How to Create Excel Graphs (In 9 Minutes)
Learn how to create, edit, and customize graphs in Microsoft Excel all in under 9 minutes. Below is a link to the sample file from the video:
readyxl.teachable.com/p/microsoft-excel-course
#msexcel #excel
zhlédnutí: 390

Video

If Functions with Multiple Conditions in Excel
zhlédnutí 652Před 5 lety
This video goes over how to use the IF function in Microsoft Excel when dealing with multiple conditions by using the AND and OR Functions. Below are sample files from this video: readyxl.teachable.com/p/microsoft-excel-course #msexcel #excel
Index Match with Multiple Criteria
zhlédnutí 215KPřed 5 lety
This video explains how to perform a lookup for a value based on multiple criteria. A normal vlookup or index match will not work since you only provide one criteria for these types of lookups. Instead, we have to use an array. Below is the link to the file that I use in this video: readyxl.teachable.com/p/microsoft-excel-course #msexcel #excel
Extracting Text from a Cell in Excel
zhlédnutí 491Před 5 lety
This video shows you how to extract a smaller substring of text from a larger string of text in a cell, by using the Left(), Right(), Mid(), Find(), and Len() functions. Below is a link to the sample file from the video: readyxl.teachable.com/p/microsoft-excel-course #msexcel #excel

Komentáře

  • @yonasmisganaw6023
    @yonasmisganaw6023 Před 2 dny

    why i can not download this videos ?

  • @rahulsaini2190
    @rahulsaini2190 Před 3 dny

    You have solved my problem after 5 years😢😢😅 thankyou

  • @khairulamri2609
    @khairulamri2609 Před 11 dny

    I feel like I already follow every step in your video, but the result is #VALUE!. Still figuring things out, thank you for the video though.

  • @user-yx7ci2jd4w
    @user-yx7ci2jd4w Před 21 dnem

    Lv you sir

  • @paulhetherington3854
    @paulhetherington3854 Před 22 dny

    D:D -- Dutch waffen <<< DoD

  • @paulhetherington3854
    @paulhetherington3854 Před 22 dny

    /var aarfield abv vfr < dub char thrm mrk < td(2''x AM()FM UI') Tu auch II fz O chrk/ /spchal rflchtz tub < mtxub aarcholmn < ba mrk dub char tels zlx u AM()FM/ /4''x vk'' orb flsh lk floch buoy arun < hlv fos mrchtz < int=cjx djz avpxjn dmx/ /krch ech bchal < fr vhkalx skub at bchal < td abv < Tu var II filtr/

  • @nadeeraperera3620
    @nadeeraperera3620 Před 3 měsíci

    Thank you, mate. From Sri lanka.

  • @matthewdefee171
    @matthewdefee171 Před 3 měsíci

    Really good video! This is the 5th or 6th video I've watched on this function and (embarrassingly?) this is the first one that explains the process in a clear and relatable manner. Not to mention that you took the time to explain an even simpler alternative - nice touch. I appreciate your time and effort 🍻

  • @solutionwithenjoy6601
    @solutionwithenjoy6601 Před 3 měsíci

    thank u man, u have solved my problem love u bro

  • @doshannringo
    @doshannringo Před 3 měsíci

    Thank you!

  • @laukittom9789
    @laukittom9789 Před 4 měsíci

    Best video

  • @SpreadHappinessonly
    @SpreadHappinessonly Před 5 měsíci

    Thanks a lot

  • @tnpanda27
    @tnpanda27 Před 5 měsíci

    Thank you sir

  • @ndbvlogs5501
    @ndbvlogs5501 Před 6 měsíci

    thank you !

  • @emank930
    @emank930 Před 6 měsíci

    Does this formula work in Google Sheets?

    • @readyxl8768
      @readyxl8768 Před 6 měsíci

      I don't think the array functionality will work on Google Sheets. But the method where you concatenate the string should work on Google Sheets

    • @emank930
      @emank930 Před 6 měsíci

      Yep, you're right. Concatenate worked but didn't array the column unfortunately. :-( Would you be able to suggest a substitute for an index match with multiple conditions with the array functionality for Gsheets - (Doesn't need to be index match as long as it performs the function of finding a value from another tab based on multiple conditions).

  • @yanduarte2858
    @yanduarte2858 Před 6 měsíci

    jes man - what a simple but great explanation

  • @user-fg3bv9zr1l
    @user-fg3bv9zr1l Před 6 měsíci

    Nice. Have been looking for this since a while. Thanks a lot

  • @Always_ponder
    @Always_ponder Před 7 měsíci

    easily the best explained video on this topic. I’ve watched numerous videos on this but none came close to simplifying it as this one does - superb and thanks very much

  • @nicolaconte3887
    @nicolaconte3887 Před 7 měsíci

    Thank you! Very useful!

  • @astmrana
    @astmrana Před 8 měsíci

    Amazing! I learned this first time . Very Much Appreciated!

  • @jesseparsons1508
    @jesseparsons1508 Před 8 měsíci

    Wow, totally awesome!! Been trying to figure out how to compare 2 columns of differnet city locations for calculating delivery charges. Was trying to do it with if,and functions but was getting confusing. This is the way to go!! Thanks

  • @patrickmathias2591
    @patrickmathias2591 Před 8 měsíci

    Thanks sir. Feel I LEARNT something good 🎉

  • @hatrang4917
    @hatrang4917 Před 9 měsíci

    great video, helped me a lot

  • @zaidamir3002
    @zaidamir3002 Před 10 měsíci

    I need to solve this issue, example: if "I-Phone 9 16GB" is again available in ROW with different Qty/Cost, so how can I get the Qty/Cost of both "I-phone 9 16GB" ? pls help

  • @zaidamir3002
    @zaidamir3002 Před 10 měsíci

    Thank you for sharing this multiple criteria trick, it solves my problem, Great Thanks a lot. Bravo

  • @vedsoni2040
    @vedsoni2040 Před 11 měsíci

    thank u so much buddy

  • @chiragjain9545
    @chiragjain9545 Před 11 měsíci

    Thank you so much

  • @H3lom
    @H3lom Před rokem

    Brilliant

  • @sajomathew3213
    @sajomathew3213 Před rokem

    What if you don't have an exact match, how can we manage then?

  • @erwerwewerwer4575
    @erwerwewerwer4575 Před rokem

    Brilliant! new subscriber

  • @fazudli
    @fazudli Před rokem

    you saved my day.. thanks

  • @exceltech6012
    @exceltech6012 Před rokem

    I have already watched so many videos but this is very different approach . Really very nice thank u

  • @angelacheung6834
    @angelacheung6834 Před rokem

    I was almost giving up on learning about index match function and stumbled upon this video! Thank you so much :)

  • @user-rr5yv3kb6t
    @user-rr5yv3kb6t Před rokem

    very helpful video thanks

  • @stonercfc
    @stonercfc Před rokem

    How do I get this to work if there are multiple values to return in a drop-down?

  • @rohscx
    @rohscx Před rokem

    Thanks. Worked well for me.

  • @iniestaxavi3826
    @iniestaxavi3826 Před rokem

    I've seen so many tutorials, even from the most famous Excel youtubers, this is the best one. You explain it in a way a kid would understand and don't just assume we have knowledge already.

  • @sumanuhiremathsuma9229

    Ann idea how we can implement this in VBA macro

  • @jonathanpangu3717
    @jonathanpangu3717 Před rokem

    Is it possible to achieve the same result with a table instead a set of data?

  • @critical_analysis
    @critical_analysis Před rokem

    Amazing video, thanks for this tip. I used this tip to solve one issue I was facing. Thank you.

  • @sanjaygoyal5486
    @sanjaygoyal5486 Před rokem

    thanks for the video! it helped me a lot

  • @theguynexttoyou
    @theguynexttoyou Před rokem

    Was looking for something without concat

  • @tormentedbuilder1355

    I've tried different index match methods from other videos to solve my problem trying to match records containing a username with multiple dates with another sheet's corresponding values attached. This is the most effective in that specific problem - thank you

    • @hhinsurance5089
      @hhinsurance5089 Před rokem

      How? ive been trying to get this to work with dates with no success

  • @rinturay1572
    @rinturay1572 Před rokem

    Thanks, bro I got to learn a lot as a beginner

  • @kfirvanunu5877
    @kfirvanunu5877 Před rokem

    GREAT THANK YOU

  • @Narindersingh-ns7uv

    THANK YOU SOO MUCH

  • @VP-yp8ip
    @VP-yp8ip Před rokem

    I really appreciate this. That helped me so much by avoiding enter data manually.

  • @dkmathur100
    @dkmathur100 Před rokem

    Bro thanks so much, made my work alot easier 🙏🙏🙏

  • @RA-rh5lb
    @RA-rh5lb Před rokem

    My learning of Index match for the multiple criteria which I learned only because of your video and I am humbly obliged to you..

  • @RA-rh5lb
    @RA-rh5lb Před rokem

    Wow I have been trying my best to learn from the different videos and this one is best i have come across for the Index match for multiple criteria . Thank you very much. Mostly i will memorize this tips because couldnt understand the basic logic on why did you use concatenate..