Back to Browse

Excel project for data analyst | Real problems in excel #exceltips #dataanalytics #mdatafinnovatics

1.3K views
Jan 9, 2024
14:35

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 - https://mdatafinnovatics.com/ Download Excel File - https://docs.google.com/spreadsheets/d/1mWEcgBPqVTXhFebyf_xXo-Ya02XEuWCF/edit?usp=sharing&ouid=109431719619751616704&rtpof=true&sd=true -----------------◀◀◀ YouTube Playlist ▶▶▶------------- ADVANCED EXCEL LATEST VIDEOS - https://bit.ly/3tRuOJ5 EXCEL FORMULAS & FUNCTIONS - https://bit.ly/33lp6UZ USE MULTIPLE FORMULAS TOGETHER - https://bit.ly/350p0Cy EXCEL SHORTS | EXCEL TIPS & TRICKS - https://bit.ly/3nx2ojd EXCEL TOOLS - https://bit.ly/350Dp1z -----------------------⬅◀◼Blogs◼▶➡----------------------- https://mdatafinnovatics.com/blog/ How to get the List of All sheets with Hyperlink Automatically / How to create indexing in Excel - https://www.mdatafinnovatics.com/list-of-all-sheets/ ----------------✉️✉️✉️Contact Us✉️✉️✉️--------------- EMAIL ADDRESS: [email protected] #dropdownlist #exceldatavalidation #excelinhindi

Download

1 formats

Video Formats

360pmp424.2 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Excel project for data analyst | Real problems in excel #exceltips #dataanalytics #mdatafinnovatics | NatokHD