Data Tab in Microsoft Excel
In Data Tab Microsoft Excel is use for inserting files from another program, and for Sort and Filter and validation and can do some more important tasks under it.
Get External Data
There are many options under this. With the help of which you can fetch data from some other place. And you can also change it.
From Access: – You May insert a file created in Microsoft Access. Program by this option in Excel sheet.
From Web: – Through this option you insert the file of Internet or Web into Excel sheet.
#From Text: – Via this option, insert a text file into an Excel sheet.
#-From Other Sources: – Any file create by this option in any program can be insert into Excel sheet.
Existing Connection: – Through this option you can insert any Existing file into Excel sheet.
Connection: – With this option, you can see the link of all other source files you have inserted here.
Properties: – With this option, you can see in which cell the external data is inserted, you can see the properties of all the data.
Edit Links: – With this you can edit the link of other file.
Sort & Filter
Sort: – Use this option to fetch any data in order. Like in the company shop school etc. of their employees or buyers who prepare the book “Register”. In that name, date, salary etc. can be done in a sequence with the help of this option. On clicking this option, its dialog box will appear. In which the following methods have been adopt to use the present option.
Method – First of all enter the following table in your sheet of records.
After this, select the name from the drop down list of Sort by Ok in the short dialog box. All the names will be in one order. And if you want to have all the same names in the same order according to the month, then by doing so, select Ok from the drop down list of then by month from the Sort dialog box. All the names will be sort by month.
Filter: – With the help of this option, you can sort any row as per your wish from the records made. There are three options under this.
1- Clear: – With the help of this, you can easily sort any row from the records as you wish. To do this, first select any cell from your record. And click on this option.
2- Reapply: – With the help of this option, all records can be reapply.
Note – This option will be start when you have to sort some of the records. It is just like all options.
3- Advance: – With the help of this option, you can also sort any record from the records prepared as per your wish. The specialty of this option is that with the help of this option, you can sort the record and also make a copy of it.
Text to Columns: – With the help of this option, text write over more than one cell can be divide into different columns.
Remove Duplicates: – With the help of this option, you can delete the duplicate row in the sheet.
Data Validation: – With the help of this option, you can write the fixed number in any selected range. That is, the selected range will not accept anything else. Just like we want to accept more than 500 and not less than 3000 in the selected range, then use this option for this. As shown in the following dialog box.
Consolidate: – With the help of this option, we use to copy the data written in another file or open sheet to another location.
What If Analysis: – With this option you can analyze the data. There are 3 options under this.
Scenarios Manager: – With the help of this option, you can set any number or word according to your wish by any name in one or more cells. So that whenever you want to see the set number or word, you can see it by clicking on the show button.
The advantage of this is that we have to write something similar. Which we don’t want to reveal. Or do we want this. That if this calculation is erase from the page, then it can be viewed whenever you want.
Goal Seek: – After adding this option, which is the answer. You can increase this number as much as you want. If you add 40 + 70 + 49 then the answer is 200. Now you want this answer to be 200 which is 300. So to do this, you will have to increase the number arising in one of those numbers (40 + 70 + 90). So that you want as much as total. May it be complete.
Method- First of all add those numbers to get it and select the number obtained and click on Goal Seek option. A dialog box named goal seek will appear in front of you.
Set cell: – Give the range of numbers obtained in this box. Like – B4
To Value: – Write down the number in this box to do as little as possible. Like – 300
By Change cell: – Give a range of one of the numbers added to this box like 40,70,90 – like B1 then do ok. After that a dialog box will appear, in which the number 200 will be changed from 300 as soon as clicking on ok.
Data Table: – With the help of this option, the result of the formula use in the selected column or row can be obtaine as a table.
Group & Auto Outline: – With the help of this option, you can create a group of selected columns or rows. So that whenever you want to hide this column or row, you can hide it. If you want to show more then you can show it.
UnGroup & Clear Outline: – With the help of this option, you can ungroup any selected column or row.
Subtotal: – With the help of this option, all the totals are extract.
Method- Firstly prepare a record according to this map. After that select the entire record and click on the Subtotal option. A dialog box named Sub Total will appear.
Show Detail: – With this option you can hide the data in the sheet.
Hide Detail: – With this option you can show the data hidden in the sheet. Data Tab Microsoft Excel.