MS Excel Data TAB Part 4-Data Tools and Outline.

In this video you will learn about to data tools and outline group under data tab, where excel provide various of command that will help us to increase our efficiency.
Here you can explore more about Data Tools like...
1. Text to Column-Its provide facility to split single column text in to multiple columns.

2. Flash Fill-This tools will help to fill the data in same pattern that you have input data in above cells.

3. Remove Duplicate-It will remove duplicate value from a range of data.

4. Data Validation-It will provide to restrict invalid input of data in worksheet during data entry work.

5. Consolidate- Its just a tolls that provide facility to link or consolidate multiple data sheets in to one sheets or you can compile data from multiple sheet in to one sheet.

These all commands help us in our daily work.

For More Details watch this video till the end.

Previous Video of Data Tab
Data Tab Part1 -
Data Tab Part2 -
Data Tab Part3 -

#EXCEL,#DATA TOOLS,#DATA VALIDATION,#TEXT TO COLUMN,#SPLIT TEXT IN TO COLUMN,#REMOVE DUPLICATES,#FLASH FILL,#DATA CONSOLIDATION,#OUTLINE,#GROUP UNGROUP,