New Posts
Home / Computer 4 Beginners / Learning Data Management Excel Features.

Learning Data Management Excel Features.

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.

Data-Management-Excel

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.

Sorting data.

Sorting data

Home Tab.

 Sorting data 2

Sorting data 3

 Sorting data

 Sorting data 5

Or.

Data Tab.

Data Tab sort

 Sorting data 5

Inserting subtotals in a sorted list.

We might want to insert subtotals. Every time is changed department. Which is located on Data Tab:

 Inserting subtotals in a sorted list

Data Tab.

 Inserting subtotals in a sorted list 2

Inserting subtotals in a sorted list 3

 Inserting subtotals in a sorted list 4

Using filters.

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.

 Using filters

Home Tab.

Using filters 2

 Using filters 3

 Using filters 3

 Using filters 4

Or.

Data Tab.

Using filters 5

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.

  1. 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.

Data Tab.

 Splitting data into multiple columns

 Splitting data into multiple columns 2

 Splitting data into multiple columns 3

 Splitting data into multiple columns 4

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.

 Splitting and combining columnar data with Flash Fill

Splitting and combining columnar data with Flash Fill 2

Data.

 Splitting and combining columnar data with Flash Fill 4

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.

 Removing duplicate records

Data.

 Removing duplicate records 2

 Removing duplicate records 3

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.

  1. select a range.

 Using validation tools

Data Tab.

Using validation tools 2

 Using validation tools 3

Any case wrong enters the number.

Using validation tools 4

You can also set the input message.

Using validation tools 5

 Using validation tools 6

To show Error Alert Message.

 Using validation tools 7

Using validation tools 8

Clear the Validation.

  1. Select the range.

 Using validation tools

Data Tab.

Using validation tools 2

 Using validation tools 9

Now everything is clear .

 

 

About imran

My Name Mohammad Ramzan Bhutto. Live in District Jacobabad, Sindh, Pakistan. I have started blogging on Information Technology, my selected areas are Online Business, Digital Marketing, Make Money Online.

Check Also

Microsoft Excel Data Analysis Tools

Microsoft Excel Data Analysis Tools

Learning Microsoft Excel Data Analysis Tools. This article illustrates the Microsoft Excel Data Analysis Tools. …