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 your excel cell is not scrolling, that means Scroll Lock is on. In this video, you will learn to remove/unlock/disable/turn off scroll lock in excel. So watch this video till the end for the Read more…
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…