MS OFFICE Excel Data Menu

 

DATA MENU

get EXTERNAL DATA

From access->import data from a Microsoft access database

From web->import data from a web page

From text->import data from a text file

From other source->import data from other data source

Existing connection->connect to an external data source by selecting from a list of commonly used source

connection

Refresh all(ctrl+alt+f5)->update all the information in the workbook that is coming from data source

Connecting->display all connection in the workbook

Properties->specify how cell connected to a data source will update, what content from the source will be displayed, how to changes in the number of rows or column in the data source will be handled in the workbook

Edit link->view all of the other files spreadsheet to linked so that you can update or remove it

Sort&Filter->you can sort the selected data in ascending or descending order or  you can temporarily filter out specific values

data tools

P

R

V

E

E

N

Text to column->separate the content of one excel cell in to separate column EX:Praveen

Remove duplicates->you can delete repeated values in the column

Data validation

Data validation ->prevent invalid data from the being entire the cell

Circle invalid data-> it can be circle invalid data to the workbook views

Clear validation circles -> it can be circle and clear invalid data to the workbook views

Consolidate->combine values from multiple ranges in to one range

What-if-analysis

Scenario manager->scenario manager allows you to create and save different group of values or scenarios and switch between them

Goal seek->goal seek will find the right input when you know the result you want

Data table-> data table allows you to see the result of many different possible inputs at the same time

OUt LINE

Group ->Tie a range of cell together so that can be collapsed or expanded

Ungroup->ungroup a range of cell that were previously grouped

Subtotal->total several rows of related data together by automatically inserting subtotals and totals for the selected cells

Show detail->Expand a collapse group of cells

Hide detail-> collapse group of cells