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 have so many Excel Worksheets & you want to combine their data. Then you can do it using with consolidate feature easily. Excel can automatically summarize or consolidate your data from multiple worksheets Read more…
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…