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).
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…
Sometimes we have an Excel Sheet, which has a large number of mobile contacts. And we want to save them on android mobile. If we will save them manually, then this task is very time-consuming. Read more…