Sometimes we have large amounts of data in Excel and we need to Filter data by related words or text. In MS-Excel we used to “Sort & Filter data” option at a basic level like Sort A to Z or Sort Z to A. But “Sort & Filter data” option have some advance filter options that we don’t know.
In this video, you will learn to use advance text filter in Excel 2007, 2010, 2013, 2016, 2019 & so on (contains text).
Flash Fill is one of the best tools of MS-Excel. It automatically fills your data when it senses a pattern. You just need to enter a sample text, you want as output. Flash Fill will Read more…
If you are usually work in MS-Excel and don’t know about VLOOKUP formula then you should know about it, which is one of the most important functions of Excel to find data in a table Read more…
If you have such type of MS-Excel file which data have so many Unwanted/ blank/extra space before and after text. That is also called leading, trailing and non-breaking spaces. Then in this video, you will Read more…