MData Finnovatics

10.5K subscribers

87 videos

Welcome to the official YouTube channel of "MData Finnovatics." MData Finnovatics is to help Small Entrepreneurs, Working Professionals, Chartered Accountant...

Latest Videos

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

Create a Dynamic Year-Month-Day Drop-Down List in Excel Excel in Hindi

Client Real Project How easily extract specific text from a cell in excel. FIND, MID & TRIM Formula

Unique way to Calculate age in excel from birthday in years, months, and days DATEDIF Formula

Excel Trick How to Automatically Update Dropdowns - You WON'T Believe What Happens Next!

Learn complete cell Referencing in Excel Hindi How to freeze data Advanced Excel YouTube Video

VLOOKUP Formula with Multiple Criteria in Excel in Hindi Vlookup multiple criteria #excelforindia

Excel pivot table grouping Grouping fields in pivot table Group data in excel

Advanced AUTO REFRESH PIVOT TABLE in #excel in #Hindi Update Pivot Table Automatically

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

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

LinkCombine 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

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

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

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

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

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

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

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

Complete tutorial on Data Validation with formulas in excel in Hindi Advanced DATA VALIDATION