How to use Excel TAKE Function to easily Extract Data

Поделиться
HTML-код
  • Опубликовано: 30 июн 2024
  • How to use Excel TAKE Function to easily Extract Data
    Support this Channel- www.instamojo.com/@innozanttr...
    ===========VIDEO COURSE============================
    ✅ Mastering Excel Video Course
    www.innozant.com/courses/adv-...
    ✅ Mastering Power BI Video Course
    www.innozant.com/courses/powe...
    ✅ Mastering VBA Video Course
    www.innozant.com/courses/vba-...
    ✅ Mastering SQL Video Course
    www.innozant.com/courses/orac...
    Visit - innozant.com
    =====================================================
    ===========HYBRID CLASSES============================
    ✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
    ✅ Database Training(SQL , PL\SQL , Oracle Developer)
    ✅ Mastering Data Science
    Visit - innozant.com
    ====================================================
    Videos in a Sequence -Basic to Advanced EXCEL
    Basic Excel- • Basic Excel-The Learni...
    Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
    Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
    Excel What if Analysis- • Excel What if Analysis
    Excel Array and Sumproduct- • Excel Array & Sumprodu...
    Excel Lookup Functions- • Excel Lookup Functions...
    Excel Pivot Tables- • Excel Pivot Tables
    Excel Power Pivot- • Excel Power Pivot
    Excel Power Query- • Excel Power Query
    Excel Chart and Infographics- • Excel Chart and Infogr...
    Excel Dashboard & Reports- • Excel Dashboard & Reports
    Value add-ons Playlist
    ProQuest-Check Point- • Excel ProQuest-Check P...
    Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
    StudsTalk -The Journey begins- • StudsTalk-The Journey ...
    QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
    Excel Tips and Tricks- • Excel Tips & Tricks
    MIS Interview Cracker- • MIS Interview Cracker
    MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
    Excel Maharaj- • EXCEL MAHARAJ - For Ex...
    Microsoft Powerpoint- • Microsoft Powerpoint
    Microsoft Word- • Microsoft Word
    Office 365- • Office 365
    Google Sheets- • Google Sheets
    Microsoft Outlook- • Microsoft Outlook
    Power BI- • Power BI
    Excel VBA- • Excel VBA Macro
    TezXL Jata Shorts- • #shorts | जो TRIM के ब...
    Announcements- • Announcements
    Website - "www.innozant.com"
    Let's Connect:
    Instagram ► / innozantinfotech
    Facebook ► / innozantinfotech
    Telegram►t.me/innozantinfotech
    #innozant #exceltakefunction #excelfunctions

Комментарии • 46

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

    I love your videos sir

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 14 дней назад +2

    🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹
    सीखते रहो, सिखाते रहो l
    हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l

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

    Amazing beautiful useful ❤

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

    sir really helpful value added😃✌

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

    Very nice function

  • @Harish.Prasad.Semwal
    @Harish.Prasad.Semwal 11 дней назад

    You are great sir ❤
    You teach in a simple way

  • @pawankumar-kx1lx
    @pawankumar-kx1lx 14 дней назад

    Very nice❤

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

    Just killer

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

    Good luck

  • @anishrobert5056
    @anishrobert5056 12 дней назад

    I don't know Hindi but i understand everything, thank you sir for your effort.

  • @RahulRoy-po9ct
    @RahulRoy-po9ct 13 дней назад

    🙏SIR🙏

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

    Handy function

  • @arpanchakraborty1677
    @arpanchakraborty1677 12 дней назад

    Jha Sir SQL Video Course Please.

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

    the more I watch your videos the more I realise that you are so talentedin video making

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

      Thanks keep learning

  • @AnirbanChowdhury-f5s
    @AnirbanChowdhury-f5s 3 дня назад

    Nice tutorial, Which video editing software are you using? Is it Adobe Premier Pro?

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

    Google sheet mai kab aayega ye guruji 😊 meto kabka wait karra hu 😊

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

    Sir ji thanks for help us adding values in our life i hope i got the high paid job with the help of your channel ❤

    • @Innozant
      @Innozant  14 дней назад +1

      Keep learning

  • @ustadgraphic
    @ustadgraphic 12 дней назад

    Hello Sir Mere ek Sawal hai, main ne 1 sheet bnai hui hai jis main mainy her month k lihiaz sy apny customers ka kam aur un ka name likha hua hai aur name k coulums mukhtalif hain. ma chahta hoon k jab main invoice create keron to jahan py customer ka name inter karon Invoice py nechy invoice details main date, jo maine d hui ha already sub kam ko wo aa jay aur sath he us customer k kam ki detail aa jay, but name nechy na aay. please help me with.

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

    We need table or can we use that formula from simple data

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

    Sir Ageing kese bnate he excel me

  • @brajamohan4082
    @brajamohan4082 14 дней назад +2

    Who is watching this video and left after learning without hitting the Like symbol , they are just simply selfish.

    • @Innozant
      @Innozant  14 дней назад +1

      Thanks.Really means a lot to me..Keep learning

    • @anjanroy1132
      @anjanroy1132 4 дня назад

      Dear sir,
      I want to purchase your Advance Excel video course worth rs 2999.
      But I have a question
      How will I get this course?
      Will it be delivered in pendrive to my house or I can get this course through online
      Please reply

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

    How can we use this formula in office 2019?

  • @cricketbaaz6036
    @cricketbaaz6036 14 дней назад +1

    Sir proquest ka link jo aapne provide kiya tha open nhi ho rha hai please uska access de dijiye

    • @Innozant
      @Innozant  14 дней назад +1

      Video description me Jo direct link h use open kriye proquest folder hoga

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

      @@Innozant thankyou so much sir aap jo kr rhe ho koi bhi free me itna kuchh nhi krta kisi ke liye.

  • @spstatus7121
    @spstatus7121 14 дней назад +1

    Hello sir, Muje interview me bola tha 1 excel sheet me 8 lakh rows data he. Mere pas daily 10 excel sheet ati he jisme 7.8 lakh ka data he jo muje ek hi excel sheet me chahiye.. mene bola aaise nahi hoga unhone bola power query se hoga mene search kiya lekin mila nahi .. kaise kare isse

    • @SanjayShrivastva-cm3wn
      @SanjayShrivastva-cm3wn 10 дней назад +1

      Sir ki power query ki playlist list hai us mein ja ke Puri playlist dekho solution hai

  • @paramjeet975singh3
    @paramjeet975singh3 13 дней назад

    Sir apke institute mai ek bar mai power bi ki complete video buy kar skate hai ???

    • @Innozant
      @Innozant  13 дней назад

      Haan innozant website visit kriye wahan video course available hai buy kar sakte hain aap

    • @paramjeet975singh3
      @paramjeet975singh3 13 дней назад

      @@Innozant Sunday ko apke vaha visit karunga....open hota hai kya ??

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

    Only top and bottom me work karta hei but middle position me kyun Nehi sir

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

      Uske liye other functions hain..jald video aayenge

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

    Hello sir, Muje interview me bola tha 1 excel sheet me 8 lakh rows data he. Mere pas daily 10 excel sheet ati he jisme 7.8 lakh ka data he jo muje ek hi excel sheet me chahiye.. mene bola aaise nahi hoga unhone bola power query se hoga mene search kiya lekin mila nahi .. kaise kare isse

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

      Ho jayega Bhai Power query se aur power view se bhi ho jayega

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

      @@umbrellainfo4626 ek hi excel sheet me 40 lakh ka data kaise ayega

    • @Innozant
      @Innozant  14 дней назад +1

      Using power query...video dekhiye humare power query series