Learning Data Management Excel Features.
In this lesson, we will learn Data Management Excel Features, where I have discussed following topics.
- Sorting data.
- Inserting subtotals in a sorted list.
- Using filters.
- Splitting data into multiple columns.
- Splitting and combining columnar data with Flash Fill.
- Removing duplicate records.
- Using validation tools.
Probably the most common tool is used in data management excel features that are called sorting. Sorting is most of the time most people means re-arranging the order of these rows and if we sort we want all the information a single person example in the list there is a name we can keep up and down this row to its appropriate place based either on rows and columns.
Inserting subtotals in a sorted list.
We might want to insert subtotals. Every time is changed department. Which is located on Data Tab:
It is work list of data, there is time certainly. The feature is called know as filters which is used applying filters on the data.
Remove filter option on Data/Text.
For removing filter click again on the filter.
Splitting data into multiple columns.
When you work with the list, two common problems you face mostly.
- Who prepare this list rally thinking too much as the name entered in column A, later we want to sort out this list by the last name.
Splitting and combining columnar data with Flash Fill.
This new tool has been introduced in 2013 which is called Flash Fill and many times going to be fast and better through does not have a much flexibility to the extra column.
Removing duplicate records.
If you Work with the list of data particular list has been created by different people and also you get data from different sources you sometimes get the problem duplicate records.
Using validation tools.
Excel data validation feature is different than other data management excel features in that is mostly about data before goes into sheet not after.
- select a range.
Any case wrong enters the number.
You can also set the input message.
To show Error Alert Message.
Clear the Validation.
- Select the range.
Now everything is clear .