MData Finnovatics
MData Finnovatics
  • 87
  • 748 010
Excel project for data analyst | Real problems in excel #exceltips #dataanalytics #mdatafinnovatics
In this video, we are explaining one of our client's problems in Excel.
How to extract data from unstructured tables without using VBA.
✅ Formulas Used: INDEX, MATCH, and VLOOKUP
✅ This video is beneficial for everyone interested in learning advanced Excel.
For more information visit our website - mdatafinnovatics.com/
Download Excel File - docs.google.com/spreadsheets/d/1mWEcgBPqVTXhFebyf_xXo-Ya02XEuWCF/edit?usp=sharing&ouid=109431719619751616704&rtpof=true&sd=true
-----------------◀◀◀ TH-cam 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
-----------------------⬅◀◼Blogs◼▶➡-----------------------
mdatafinnovatics.com/blog/
How to get the List of All sheets with Hyperlink Automatically / How to create indexing in Excel - www.mdatafinnovatics.com/list-of-all-sheets/
----------------✉️✉️✉️Contact Us✉️✉️✉️---------------
EMAIL ADDRESS: support@mdatafinnovatics.com
#dropdownlist #exceldatavalidation #excelinhindi
มุมมอง: 835

วีดีโอ

Create a Dynamic Year-Month-Day Drop-Down List in Excel | Excel in Hindi
มุมมอง 1.9Kปีที่แล้ว
In this video, we are using multiple formulas to explain how to create a Dynamic Year-Month-Day Drop-Down List in Excel. ✅ Formulas Used: DAY, DATE, MATCH, OFFSET, EOMONTH ✅ This video is beneficial for everyone who is interested to learn advanced Excel. For more information visit our website - mdatafinnovatics.com/ Download Excel File - docs.google.com/spreadsheets/d/1SZfOGQVIeCMEIn-2XntTisa5c...
Client Real Project: How easily extract specific text from a cell in excel. FIND, MID & TRIM Formula
มุมมอง 1Kปีที่แล้ว
In this video, we are sharing one of our clients' real problems. Problem: How to extract specific text from a cell in excel? ✅ Formulas Used: FIND, MID, & TRIM ✅ This video is beneficial for everyone who is interested to learn advanced excel. For more information visit our website - mdatafinnovatics.com/ Download Excel File - docs.google.com/spreadsheets/d/1MtaA6AoQfA1cINvNtgfqPRwri7Rx0iCx/edit...
Unique way to Calculate age in excel from birthday in years, months, and days | DATEDIF Formula
มุมมอง 1.2Kปีที่แล้ว
In this video, today we are going to learn how to calculate the difference between 2 dates in terms of Years, Months, Weeks, & Days. ✅ We are using the excel hidden formula DATEDIF which you can use in all the Excel versions so far. ✅ DATEDIF formula help us to Calculates the number of days, months, or years between two dates. ✅ This video is beneficial for everyone who is interested to learn a...
"Excel Trick: How to Automatically Update Dropdowns - You WON'T Believe What Happens Next!"
มุมมอง 920ปีที่แล้ว
In this video, we are going to learn 3 important points related to Drop down list: ✅ How to update drop down list automatically ✅ How to update the drop-down list with unique values only ✅ How to update the drop-down list in alphabetical order. This video is beneficial for everyone who is interested to learn advanced excel. For more information visit our website - mdatafinnovatics.com/ Download...
Learn complete cell Referencing in Excel Hindi | How to freeze data | Advanced Excel YouTube Video
มุมมอง 1.8K2 ปีที่แล้ว
In this video, we will learn how to use Cell Referencing in Excel which means when to freeze the data or when to apply a dollar ($) sign to the data. 🔥🔥🔥🔥🔥 There are 3 types of cell referencing in excel: Absolute, Relative, and Mixed Referencing. Relative Referencing: It is the default referencing in excel where the formula is working dynamically. If the formula is copied from one cell and past...
VLOOKUP Formula with Multiple Criteria in Excel in Hindi | Vlookup multiple criteria #excelforindia
มุมมอง 16K2 ปีที่แล้ว
Learn how to use the Vlookup formula with multiple criteria. Most of us know, how to use the simple vlookup formula in excel. But we face challenges if we get duplicate values in the column or if multiple criteria come in the data. 🔥🔥🔥🔥 What you will learn in this video: ✔️ How to use the vlookup formula in excel ✔️ How to use the vlookup with multiple criteria ✔️ How to use the vlookup formula...
Excel pivot table grouping | Grouping fields in pivot table | Group data in excel
มุมมอง 2K2 ปีที่แล้ว
Learn how to create grouping on numbers in pivot tables. Most of us know, how to create pivot tables in excel. But very few of us know what is pivot table grouping and how to use grouping fields in pivot table. 🔥🔥🔥🔥 What you will learn in this video: ✔️ What is pivot table grouping ✔️ How to apply pivot table grouping ▼ DOWNLOAD EXCEL FILE - mdatafinnovatics.com/Latest-Advanced-Excel-TH-cam-Vid...
Advanced AUTO REFRESH PIVOT TABLE in #excel in #Hindi | Update Pivot Table Automatically
มุมมอง 2.5K2 ปีที่แล้ว
▶ Check CUSTOMIZED TOOLS in EXCEL/VBA | Power BI - mdatafinnovatics.com/portfolio/ ▼ DOWNLOAD EXCEL FILE - mdatafinnovatics.com/Latest-Advanced-Excel-TH-cam-Videos/ Refresh the pivot table automatically when data changes using the VBA one-line code. Most of us know, how to create pivot tables in excel. But very few of us know how automatically update the pivot tables when source data changes. I...
Set notification & reminder of expiry date in #excel | #ConditionalFormatting for Due & Expiry Date
มุมมอง 17K2 ปีที่แล้ว
Set notification & reminder of expiry date in #excel | #ConditionalFormatting for Due & Expiry Date
Target Line in charts | How to make a line graph in excel | Excel Target Line | Bar chart in excel
มุมมอง 1.3K2 ปีที่แล้ว
Target Line in charts | How to make a line graph in excel | Excel Target Line | Bar chart in excel
Conditional formatting in excel | Excel cell borders | Dynamic borders excel | Auto border in excel
มุมมอง 6K2 ปีที่แล้ว
Conditional formatting in excel | Excel cell borders | Dynamic borders excel | Auto border in excel
Excel pivot table auto refresh | Advanced pivot tables | Update pivot table source vba
มุมมอง 2.9K2 ปีที่แล้ว
Excel pivot table auto refresh | Advanced pivot tables | Update pivot table source vba
Link/Combine and consolidate data of two (multiple)spreadsheets in excel | Advanced linking of files
มุมมอง 2.8K2 ปีที่แล้ว
Link/Combine and consolidate data of two (multiple)spreadsheets in excel | Advanced linking of files
Restrict copy and paste in excel | protect cells from editing | Excel password protection | Hindi
มุมมอง 3.6K2 ปีที่แล้ว
Restrict copy and paste in excel | protect cells from editing | Excel password protection | Hindi
Use Dynamic Scroll Bars in Excel without VBA | Scroll bar in excel | Excel form controls
มุมมอง 3.8K2 ปีที่แล้ว
Use Dynamic Scroll Bars in Excel without VBA | Scroll bar in excel | Excel form controls
User form combo box | How to use Combo box in Excel without VBA | Excel filter function
มุมมอง 34K2 ปีที่แล้ว
User form combo box | How to use Combo box in Excel without VBA | Excel filter function
How to delete blank rows in excel | how to remove blank rows in excel | Data Cleaning in Excel
มุมมอง 3.8K2 ปีที่แล้ว
How to delete blank rows in excel | how to remove blank rows in excel | Data Cleaning in Excel
Sumproduct Formula in multiple conditions (from basic to advanced) | sumproduct in hindi
มุมมอง 42K2 ปีที่แล้ว
Sumproduct Formula in multiple conditions (from basic to advanced) | sumproduct in hindi
Data analyst interview | Excel Interview Questions and answers || Excel test for job interview Hindi
มุมมอง 44K2 ปีที่แล้ว
Data analyst interview | Excel Interview Questions and answers || Excel test for job interview Hindi
Vlookup and if function together | VLOOKUP with if function in Hindi | If function excel
มุมมอง 2.4K2 ปีที่แล้ว
Vlookup and if function together | VLOOKUP with if function in Hindi | If function excel
Excel filter function | Filter formula in excel || Dynamic filters | Advanced filter or criteria
มุมมอง 2K2 ปีที่แล้ว
Excel filter function | Filter formula in excel || Dynamic filters | Advanced filter or criteria
Xlookup can only replace multiple formulas in excel | xlookup vs vlookup | Xlookup hindi - Part 2
มุมมอง 2.2K2 ปีที่แล้ว
Xlookup can only replace multiple formulas in excel | xlookup vs vlookup | Xlookup hindi - Part 2
Excel xlookup | Xlookup hindi | Xlookup vs Vlookup in Excel | Xlookup function in hindi - Part 1
มุมมอง 8842 ปีที่แล้ว
Excel xlookup | Xlookup hindi | Xlookup vs Vlookup in Excel | Xlookup function in hindi - Part 1
Stop use to enter any wrong information in excel | Custom Data validation | Data validation
มุมมอง 1.3K2 ปีที่แล้ว
Stop use to enter any wrong information in excel | Custom Data validation | Data validation
How to extract numbers from text in excel | Extract number formula excel | Extract number from cell
มุมมอง 30K2 ปีที่แล้ว
How to extract numbers from text in excel | Extract number formula excel | Extract number from cell
Extract data from multiple sheets in a single sheet in excel in #Hindi | #Indirect with sum formula
มุมมอง 6K2 ปีที่แล้ว
Extract data from multiple sheets in a single sheet in excel in #Hindi | #Indirect with sum formula
Offset Function in Excel | Excel Offset Function | Excel Offset range #CreatingForIndia
มุมมอง 1.2K3 ปีที่แล้ว
Offset Function in Excel | Excel Offset Function | Excel Offset range #CreatingForIndia
How to create Advanced drop-down list | Drop Down List in Excel | Advanced Data Validation in Excel
มุมมอง 1.6K3 ปีที่แล้ว
How to create Advanced drop-down list | Drop Down List in Excel | Advanced Data Validation in Excel
Complete tutorial on Data Validation with formulas in excel in Hindi | Advanced DATA VALIDATION
มุมมอง 1.1K3 ปีที่แล้ว
Complete tutorial on Data Validation with formulas in excel in Hindi | Advanced DATA VALIDATION

ความคิดเห็น

  • @parikshitjoshi1883
    @parikshitjoshi1883 3 วันที่ผ่านมา

    Which Farmula Ans- 771369420 Sheet A7 is 771 & Sheet B7 is 369420 = Sheet C7 is 771369420 is ans

  • @sumankumar7215
    @sumankumar7215 4 วันที่ผ่านมา

    Mere bas me hota to akele my 5Lac like deta sir🎉

  • @PramodMishra7398
    @PramodMishra7398 5 วันที่ผ่านมา

    its very useful video...... the way of teaching is excellent OWSOM THANKYU VERY MUCH

  • @Bhootpisach956
    @Bhootpisach956 5 วันที่ผ่านมา

    6:23, how is salary in Index 2? It should be in 4 right?

  • @SS-nr4uu
    @SS-nr4uu 10 วันที่ผ่านมา

    Hi brother hope you are well Kindly tell me following:- In one cell contains "5" in which 2 are being decreased and 1 is being included. I want in next cell that 5 shows like"5+--" Pl tell me formula Thanks

  • @creativeideas5267
    @creativeideas5267 12 วันที่ผ่านมา

    You added only week holidays if I want show regional holidays also then how to add means need total working days count should not included the regional holidays too

  • @nandinihiremath6851
    @nandinihiremath6851 16 วันที่ผ่านมา

    Good examples and great Video

  • @FarhanAslam-b1p
    @FarhanAslam-b1p 18 วันที่ผ่านมา

    Thank you very much for Very helpful tutorial

  • @NareshKumar-dv8er
    @NareshKumar-dv8er 19 วันที่ผ่านมา

    Finally, Indirect samjh me aa gaya.❤ THANK YOU SO MUCH 🙏

  • @reels230
    @reels230 29 วันที่ผ่านมา

    great video

  • @bijoychandraroy5614
    @bijoychandraroy5614 หลายเดือนก่อน

    Wow very helpfull in this video,,, Thanks a lot of Brother

  • @NiyatiSingh-uw9os
    @NiyatiSingh-uw9os หลายเดือนก่อน

    there is no servicel line column in the given sheet

  • @Animesh_Goyal
    @Animesh_Goyal หลายเดือนก่อน

    Best explanation on Indirect

  • @munnarajbhar8214
    @munnarajbhar8214 หลายเดือนก่อน

    Sir bank statement me number aur bhi aate hai toh usko kaise split kare

  • @aznibas
    @aznibas หลายเดือนก่อน

    The video is very useful because it opens the user's eyes to resolving a problem in many different ways. Thanks.

  • @bhuwanc8
    @bhuwanc8 หลายเดือนก่อน

    Very helpful.

  • @Smaniruddin70
    @Smaniruddin70 หลายเดือนก่อน

    Bahut acha laga,

  • @shree1164
    @shree1164 หลายเดือนก่อน

    hi how do I now transfer this table to word including the scroll bar??

  • @VyankateshManjrekar
    @VyankateshManjrekar หลายเดือนก่อน

    sahi hei bro

  • @rahulnotiyal5728
    @rahulnotiyal5728 หลายเดือนก่อน

    V lookup formula

  • @rahulnotiyal5728
    @rahulnotiyal5728 หลายเดือนก่อน

    Sir Or vedio banao plz basic se advance excel ki

  • @akashdeepdhiman6775
    @akashdeepdhiman6775 หลายเดือนก่อน

    =INDIRECT(SUBSTITUTE(F2," ","_")) For Creating Drop-down list based on states because Uttar Pradesh has a space in its name..thanks for the video sir and for useful content

  • @nitish709011
    @nitish709011 หลายเดือนก่อน

    Hello @MDataFinnovatics :- If tab names are by Month and year names, how to write an Indirect function ? I tried but its giving #REF error.

  • @AdibaChaudhry-v4k
    @AdibaChaudhry-v4k หลายเดือนก่อน

    telephone Bill calculat k liy kon sa formula use ho ga

  • @NatureIloveU
    @NatureIloveU 2 หลายเดือนก่อน

    I am learning excel for data analytics and ur videos are really very very helpful

    • @AnilKumar-ln1qq
      @AnilKumar-ln1qq หลายเดือนก่อน

      Hey i am anil, Are you working in Data analytics ?

  • @shaba9100
    @shaba9100 2 หลายเดือนก่อน

    Bhai need video on pull data from biometric machine and will update in excel for huge manpower like 2000 employees

  • @chandrammaurya7443
    @chandrammaurya7443 2 หลายเดือนก่อน

    app etna fast explain kerte ho kuch samjh nahi aaya

  • @buildyourself009
    @buildyourself009 2 หลายเดือนก่อน

    First time, and your teaching technique and skills are superb...thanks a lot for the learning.

  • @JustinSohail
    @JustinSohail 2 หลายเดือนก่อน

    I want to track employees who are often taking leaves on Friday and Saturday. Can anyone help me out...

  • @CommerceCoachingRanchi
    @CommerceCoachingRanchi 2 หลายเดือนก่อน

    really very help full can you please tell me how to replace number from all statement via formula if any thanks in advance

  • @omprakashsingh7330
    @omprakashsingh7330 2 หลายเดือนก่อน

    Choose par banao sir..

  • @omprakashsingh7330
    @omprakashsingh7330 2 หลายเดือนก่อน

    Sir... And aur or me jab if ka use karte hai to sirf Yes or No ko validate karne k liye use karte hai kya...??????

  • @faakiduniya25113
    @faakiduniya25113 2 หลายเดือนก่อน

    its very useful video...... the way of teaching is excellent. ❤❤

  • @habibrehman-kv8ti
    @habibrehman-kv8ti 2 หลายเดือนก่อน

    how we can color the row by if formula

  • @sohankhatri1033
    @sohankhatri1033 3 หลายเดือนก่อน

    SLICER bhi to hota h ?

  • @ishasheraz2620
    @ishasheraz2620 3 หลายเดือนก่อน

    Tysm sir

  • @FirstLast-l4m
    @FirstLast-l4m 3 หลายเดือนก่อน

    कुछ ज़्यादा ही advance हो गया था !!

  • @khaled6100
    @khaled6100 3 หลายเดือนก่อน

    I will kiss you so hard

  • @anshulgoel4692
    @anshulgoel4692 3 หลายเดือนก่อน

    Very nice

  • @PanaceaCloud
    @PanaceaCloud 3 หลายเดือนก่อน

    it is not working, either share right solution or do not post such video to waste our time

  • @mdfazar2091
    @mdfazar2091 3 หลายเดือนก่อน

    Excellent sir God bless you bhaijaan 🎉

  • @parimalauutade6586
    @parimalauutade6586 3 หลายเดือนก่อน

    USEFUL SIR ,but the sheet not accessible,we cant download it for practice

    • @musaddiqali7864
      @musaddiqali7864 2 หลายเดือนก่อน

      Yes, same for me. For some reason, it was in very bad form.

  • @PrabhakarSingh-sz1vb
    @PrabhakarSingh-sz1vb 3 หลายเดือนก่อน

    sir practice file open nhi ho rahi hai

  • @rohitbhise6583
    @rohitbhise6583 3 หลายเดือนก่อน

    sir please add timestamp

  • @anikdas4439
    @anikdas4439 3 หลายเดือนก่อน

    Thanks

  • @PrabhakarSingh-sz1vb
    @PrabhakarSingh-sz1vb 3 หลายเดือนก่อน

    Amazing sir

  • @riddhishaw1481
    @riddhishaw1481 3 หลายเดือนก่อน

    अगर इसे easy process में बताए तो कमजोर छात्रों को मदद मिलेंगी

  • @prashantkumar-rf9bi
    @prashantkumar-rf9bi 3 หลายเดือนก่อน

    nice information sir

  • @avinashmajhi2510
    @avinashmajhi2510 3 หลายเดือนก่อน

    Mai aap ke video mai accidentally aa gaya. Mai sumproduct formula ke liye video search kar raha tha mujhe kuch confusion tha regarding (-- )or ( * ) in dono mai se kiska use kab or kyu karte hai. Aab sayad iska answer mil gaya hai mai aab practice kar ke dekhun ga. Aap agar in dono par (--) or (*) details se video banaye ge to mere jaise bahut se student ka doubt clear hoga . Mere jaise bahut se student hai jinhe ( --) or (* ) is me confusion rehta hai.