Data Tab in MS Excel 2007

Prem Kumar

                                                                              Data Tab 


Get External Data Group

From Access 

This option is used to import MS Access tables to Excel sheets.

From Web  

This option is used to import table from online browser to Excel sheet.

From Text 

This option is used to import a text file like Notepad to an Excel sheet.

From Other Sources 

Use this option from other sources like XML, SQL etc. Is used to import from Excel sheet. 

Existing Connections

By clicking on this option, we can see the name of the file that was added to our sheet.

Connections Group

Refresh All 

When a file is imported into a sheet. And if changed in the imported file. The sheet is refreshed to show it in the sheet.

Connections 

In this option, we are shown the names of the imported files. By clicking with the mouse on the name shown, we reach that data directly in the sheet.

Properties 

With the help of this option, we can check the property from the sheet for the imported file.

Sort & Filter Group

Sort

We can select any column of the table created in the sheet and place it in increasing or decreasing order.

 Filter 

With the help of this option we can filter and record any record in the table.

Clear 

This option is used to normalize the filtered record back.

Advanced

Using this option, we can filter the special data and see it. For example, record of data starting from common character.

Data Tools Group

Text to column

With the help of this option we can divide the text of a column into different columns.

Remove Duplicates

With the help of this option we can remove duplicate entries from the table.

Data Validation

With the help of this option we can set the data validation on the active cell, in which the data can be filled only according to the condition set in the cell.

Consolidate

With the help of this option, we can show the data of two different sheets simultaneously in one sheet.

What if Analysis

Scenario Manager

With the help of this option, after saving more than one record in a range in the sheet, they can be shown interchangeably.

Goal Seek

This option is used for direct adjusting (more or less) the value of SUM.

Data Table

Data tables are used to analyze the changes seen in your final result when certain variables are changed from your function or formula.

Outline Group

Group

This option is used to group more than one column and row selected.

Ungroup 

This option is used to remove multiple columns and rows grouped from the group.

Subtotal

This option is used to retrieve data of the same category as Subtotal.

Comments

Post a Comment

Popular posts from this blog

Formulas Tab in MS Excel 2007

Prem Kumar
Image
  Formulas Tab Function Library Group Insert Functions  With the help of this option, we can edit the function (formula) of the current cell and insert the new function in the new cell. Apart from this, you can take offline help    related to the function.                Auto Sum With the help of this option, you can automatically add a range in the sheet in which the number data is written.                Recently Used            In this option, functions are found which have been used recently.                Financial            Financial options are available in this option. Like - PMT, PV, FV etc.                Logical            Logical functions are available in this option...
Read more

Office Button in MS Excel 2007

Prem Kumar
Image
  The same options are available in the MS Excel 2007 office button, which are found in the MS Word and MS PowerPoint 2007 office buttons. New - Ctrl+O :-  This option is used to add a new workbook file. Open - Ctrl+O :-  This option is used to open a workbook file that we saved earlier. Save - Ctrl+S :-  By this option we can save the current data in the current worksheet or workbook file. Save As - F12 :-  This option is used to save a new separate workbook file. Print :-  It has the following three options - Ctrl+P :-  It is used to print the worksheet, using this option you can select the printer, set the page range and you can also set how many copies to print. Quick Print :-  This option is used to print directly on the print settings set last. Print Preview - Ctrl+F2 :-  Using this option, we can see what the matter we are printing will look like when it is printed. Encrypt Document (Prepare) :-  With this option we put a password...
Read more

Home Tab in MS Excel 2007

Prem Kumar
Image
The main options are kept in the Home Tab of MS Excel 2007 which are more needed. Clipboard Group Cut (Ctrl+X) This option is used to cut selected content and save it in the clipboard. Copy (Copy+C) This option is used to copy selected content and save it to the clipboard. Paste (Ctrl+V) This option is used to access cut or copied content in the new range in the same sheet.  Format Painter  Through this option, we can copy the format on any cell and apply it on the new cell. Font Group Font  This option is used to change the font of the active cell. Font Size  This option is used to change the font size of the active cell. Increase Font Size  This option is used to increase the size of the font. Decrease Font Size    This option is used to reduce the font size. Bold (Ctrl+B) It is used to make the text of the active cell appear thick or dark.  Italic (Ctrl+I) It is used to make the text of the active cell appear italic. Underline (Ctrl+U) It is us...
Read more