Extract data from multiple sheets in a single sheet in excel in

Поделиться
HTML-код
  • Опубликовано: 31 янв 2022
  • indirect function in excel with multiple conditions at basic, intermediate, and advanced levels. 🔥🔥🔥🔥🔥
    Extract values from multiple sheets into a single sheet WITHOUT using VBA in excel in HINDI.
    The indirect function in excel is one of the advanced excel formulas which is commonly asked in interviews nowadays.
    What you will learn in this video:
    ✔️ What is Indirect Formula in excel in Hindi
    ✔️How to use Indirect with sum function or sum with indirect formula in excel
    ✔️ How to extract values from multiple sheets in a single sheet
    ✔️How to use Indirect function in excel to extract data from multiple sheets in a single sheet
    ✔️ How to create a dynamic drop-down list in excel in Hindi
    RELATED VIDEO
    ▶Dynamic drop-down list - • Excel drop down list |...
    ▼ DOWNLOAD EXCEL FILE - mdatafinnovatics.com/Latest-A...
    #mdatafinnovatics #indirectfunctioninexccel #excelinhindi
    MData Finnovatics is creating advanced excel Hindi videos to help students, job seekers, professionals, teachers, entrepreneurs, and local business owners learn how to use Advanced Excel. With the help of advanced excel formulas and functions, excel has the ability to customize and automate your daily tasks. Advanced Excel is the only software that every industry or sector uses to keep track of their data. Excel is a powerful tool that can help you save time and earn more money. From Basic to Advanced, you will learn many formulas and functions on this Excel channel, including the IF formula, Vlookup formula, Hlookup formula, Match, Index, Xlookup formula, Filter formula & function, data validation, and conditional formatting. We will make every effort to keep you informed about the advanced uses of excel in Hindi.
    ----------------◀◀◀ RUclips Playlist ▶▶▶------------
    ADVANCED EXCEL LATEST VIDEOS - bit.ly/3tRuOJ5
    EXCEL FORMULAS & FUNCTIONS - bit.ly/33lp6UZ
    USE MULTIPLE FORMULAS TOGETHER - bit.ly/350p0Cy
    EXCEL SHORTS | EXCEL TIPS & TRICKS - bit.ly/3nx2ojd
    EXCEL TOOLS - bit.ly/350Dp1z
    ----------------▪▪◾◼◼Social Media ◼◼◾▪▪------------
    WEBSITE LINK - www.mdatafinnovatics.com/
    RUclips CHANNEL - ruclips.net/user/mdatafinnovat...
    FACEBOOK PAGE - / mdatafinnovaticsofficial
    TWITTER PAGE - / mfinnovatics
    INSTAGRAM PAGE - / mdatafinnovatics
    COMPANY LINKEDIN PAGE - / mdatafinnovatics
    QUORA - www.quora.com/profile/Pradeep...
    ----------------------⬅◀◼Blogs◼▶➡----------------------
    How to get the List of All sheets with Hyperlink Automatically / How to create indexing in Excel - www.mdatafinnovatics.com/list...
    ---------------✉️✉️✉️Contact Us✉️✉️✉️--------------
    EMAIL ADDRESS: support@mdatafinnovatics.com
    ✔️ excel indirect
    ✔️ indirect formula in excel
    ✔️ indirect function excel
    ✔️ indirect tutorial
    ✔️ excel indirect function tutorial in Hindi
    ✔️ indirect excel formula
    ✔️ sum with indirect
    ✔️ indirect another tab
    ✔️ excel indirect formula
    ✔️ indirect with sum
    ✔️ indirect in excel
    ✔️ indirect formula
    ✔️ excel function indirect
    ✔️ Excel Indirect Function
    ✔️ how to use the indirect function in excel
    ✔️ indirect excel function
    ✔️ indirect another sheet
    ✔️ indirect function
    ✔️ indirect excel
    ✔️ indirect address
    ✔️ indirect function excel multiple sheets
    ✔️ Data Validation

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

  • @MDataFinnovatics
    @MDataFinnovatics  2 года назад +1

    Call us at +91-9354674901 for
    Advanced Excel LIVE Training,
    Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍

  • @usamahqamar6148
    @usamahqamar6148 18 дней назад

    Very helpful thanks

  • @Matawfik
    @Matawfik Год назад +1

    Indian speaking but excellent demonstration. Thanks a ton.
    Big like and subscribe for attaching the working file. 👍👍

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

      Thanks, Tawfik for liking the video and also for the subscription!

  • @cutoworld7425
    @cutoworld7425 2 года назад +1

    Very very knowledgeable video sir. Thanks for enhancing our knowledge

    • @MDataFinnovatics
      @MDataFinnovatics  2 года назад

      Thank you Cuto World. Don't forget to like and share the video!

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

    Very nice sir ji 👍

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 2 года назад +1

    amazing job. please make video how to lookup case sensitive ....., with vlookup

    • @MDataFinnovatics
      @MDataFinnovatics  2 года назад

      Thanks Mohammad. You can use Upper, Lower, and Proper for a specific case sensitive. But we will try to create a video on case sensitive with VLOOKUP. Don't forget to like and share the video!

    • @ubaidillahmuhammad20
      @ubaidillahmuhammad20 2 года назад +1

      prpper, lower n upper don't work..

    • @MDataFinnovatics
      @MDataFinnovatics  2 года назад

      Please share your scenario so that we can provide you some solution!

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

    Hi Sir plz share the ans of last question which you had given to us for homework

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

    I hope u understood my doubt ...if not plz let me know!!!!

  • @user-nn6yu6zf2t
    @user-nn6yu6zf2t 3 месяца назад

    =INDIRECT(A1)
    this gives refrence error