VSTACK formula in Excel
If we want to vertically stack array into one array or one column below another...
Excel
Filter Formula in Excel
In excel filter formula is used to filter a range or an array based on...
Power Query
Power Query is tool in Excel and Power Bi that is used to transform data.With...
INDEX & 2th MATCH in Excel
INDEX in Excel In Excel, the INDEX function is used to retrieve a value from...
Hour,Minute & Second Formula in Excel
To extract Hours ,Minutes and seconds from given time these formulas are used.
How to Write more Than 15 digits in Excel
When we type number greater than 15 digits in excel it will convert digit after 15th number to zeros
Freeze Panes in Excel
It will freeze row or column when we scroll down excel sheet below or right top row or left column…
LEN formula in Excel
To check length of the word or to check how many letters or character in cell we can use len…
Remove duplicates in Excel
Sometimes data contains duplicate entries in a column. We can check it by selecting column click on Home->conditional formatting->highlight cell…
How to Merge Excel files using Access
Merging of excel file is common task one can merge excel files manually by copying one files content to other.…