Ready XL
Ready XL
  • Видео 4
  • Просмотров 228 094
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
Просмотров: 406

Видео

If Functions with Multiple Conditions in Excel
Просмотров 7165 лет назад
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
Просмотров 226 тыс.5 лет назад
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
Просмотров 5105 лет назад
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

Комментарии

  • @shreekrishnasitaula2739
    @shreekrishnasitaula2739 5 дней назад

    much appreciated. Helpful

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

    Thank you so much❤

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

    your control shift enter actually help me a ton. thanks alot bro.

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

    why i can not download this videos ?

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

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

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

    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 2 месяца назад

    Lv you sir

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

    D:D -- Dutch waffen <<< DoD

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

    /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 5 месяцев назад

    Thank you, mate. From Sri lanka.

  • @matthewdefee171
    @matthewdefee171 5 месяцев назад

    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 5 месяцев назад

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

  • @doshannringo
    @doshannringo 6 месяцев назад

    Thank you!

  • @laukittom9789
    @laukittom9789 6 месяцев назад

    Best video

  • @SpreadHappinessonly
    @SpreadHappinessonly 7 месяцев назад

    Thanks a lot

  • @tnpanda27
    @tnpanda27 7 месяцев назад

    Thank you sir

  • @ndbvlogs5501
    @ndbvlogs5501 8 месяцев назад

    thank you !

  • @emank930
    @emank930 8 месяцев назад

    Does this formula work in Google Sheets?

    • @readyxl8768
      @readyxl8768 8 месяцев назад

      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 8 месяцев назад

      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 8 месяцев назад

    jes man - what a simple but great explanation

  • @RajuKutala
    @RajuKutala 9 месяцев назад

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

  • @Always_ponder
    @Always_ponder 9 месяцев назад

    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 9 месяцев назад

    Thank you! Very useful!

  • @astmrana
    @astmrana 10 месяцев назад

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

  • @jesseparsons1508
    @jesseparsons1508 11 месяцев назад

    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

    • @readyxl8768
      @readyxl8768 10 месяцев назад

      Glad it was helpful!

  • @patrickmathias2591
    @patrickmathias2591 11 месяцев назад

    Thanks sir. Feel I LEARNT something good 🎉

  • @hatrang4917
    @hatrang4917 11 месяцев назад

    great video, helped me a lot

  • @zaidamir3002
    @zaidamir3002 Год назад

    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 Год назад

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

  • @vedsoni2040
    @vedsoni2040 Год назад

    thank u so much buddy

  • @chiragjain9545
    @chiragjain9545 Год назад

    Thank you so much

  • @H3lom
    @H3lom Год назад

    Brilliant

  • @sajomathew3213
    @sajomathew3213 Год назад

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

  • @erwerwewerwer4575
    @erwerwewerwer4575 Год назад

    Brilliant! new subscriber

  • @fazudli
    @fazudli Год назад

    you saved my day.. thanks

  • @exceltech6012
    @exceltech6012 Год назад

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

  • @angelacheung6834
    @angelacheung6834 Год назад

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

  • @VaibhavDhale-j4j
    @VaibhavDhale-j4j Год назад

    very helpful video thanks

  • @stonercfc
    @stonercfc Год назад

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

  • @rohscx
    @rohscx Год назад

    Thanks. Worked well for me.

  • @sumanuhiremathsuma9229
    @sumanuhiremathsuma9229 Год назад

    Ann idea how we can implement this in VBA macro

  • @jonathanpangu3717
    @jonathanpangu3717 Год назад

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

  • @critical_analysis
    @critical_analysis Год назад

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

  • @sanjaygoyal5486
    @sanjaygoyal5486 Год назад

    thanks for the video! it helped me a lot

  • @theguynexttoyou
    @theguynexttoyou Год назад

    Was looking for something without concat

  • @tormentedbuilder1355
    @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 Год назад

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

  • @rinturay1572
    @rinturay1572 Год назад

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

  • @kfirvanunu5877
    @kfirvanunu5877 Год назад

    GREAT THANK YOU

  • @Narindersingh-ns7uv
    @Narindersingh-ns7uv Год назад

    THANK YOU SOO MUCH

  • @VP-yp8ip
    @VP-yp8ip Год назад

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

  • @dkmathur100
    @dkmathur100 Год назад

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