You can also use the shortcut key ALT + H +S + F 3.Ĝlicking on any drop-down menu will provide you with options for sorting or filtering.ĝrop-down menus will appear next to each cell heading.Under the Editing group, press the Sort and Filtering button and select the Filter button.To apply filters to your data follow these simple steps It helps you to narrow down your large data and you can view only the information that is relevant to you. With the help of filter function you can subgroup your data as you want. FilterĪpplying filters to your data can bring in a lot of ease and convenience. You can also use the shortcut key ALT + H + S 2.Under the Editing group, press the Sort and Filtering button and select the order you want your data to be sorted.Select a single cell in the column containing the data you want to sort.To sort your data follow these simple steps You can sort it in ascending order, descending order, alphabetical order etc. When you are working on a large amount of data, there may be cases where you want to group certain type of data and want to sort it in some way and doing it manually will definitely age you by some years, instead use the sort function and group the data in few seconds. We know you are working on large amount of data regularly and therefore bring to you some basic but very important excel functions that will help you in your daily work.
Are you a data analyst or looking for a career as a data analyst? Well then, today’s article is dedicated to you.
0 kommentar(er)
