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 want your Excel data more accurate then you can create a Drop-Down List in Excel. (Using Data Validation). In this video, you will learn to make two types of drop-down lists in excel, Read more…
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…