This Video Show Tab Data in store tool relate manage data on worksheet
and workbook. It has a lot of tool to work on it
Tab Data in store tool relate manage data on worksheet and workbook. It has a lot of
tool to work on it
1 Group Get External data collect tool that link or import data from another Application
- From Access link to MS-Access import data put on worksheet
- From Web Link to Web to import data to put on worksheet (Note In this tool make sure your PC is connect to internet)
- From Text Link to Text file to import data put on worksheet
- From other source Link to another source so Ms-SQL Server, My SQL, XML…
- Existing Connection link to common source
2 Group Get & Transform for connect to another data source
- New Query for link to other data source or file and import data so Ms-SQL server, Ms-Access, online source
- Show Query for view query on workbook
- From Table use for create a new query linked to the selected excel table
- Recent Sources the source have used for connect to data source
3 Group Connectitons For connect to data source
- Refresh All Get the latest all data by refreshing all the sources on the workbook
- Connections display all data connection for workbook
- Properties specify how cells connect to a data source will updated, what contents from the source will be displayed, and how changes in the number of rows or column in the data source will be handles of the workbook
- Edit Link view all of the other files this spreadsheet is linked to so that you can update or remove the links
4 Group Short & Filter for prepare data by order
- Sort make data to order
- Filter for select to data by cells
- Clear for clear sort & filter that current rage data
- Reapply
- Advanced for filter complex criteria
5 Data tools collect tools that relate to use form manage data
- Text to Column for slit a single column of text in to multi column
- Flash Fill for Automatically fill in value to other column
- Remove Duplicates for delete duplicate row from work sheet
- Data Validation for improve the accuracy or pick from list of rules to limit the type of data that can be enter in a cell
- Consolidate for summary data from separate rage
- Relationships to create or edit data relationships between tables to relate data from difference table on the same report
- Manage Data Model to add and prepare data or continue working on data already in this workbook
6 Forecast have two tools for use
- What-If Analysis to try out various value for the formula in the sheet using scenario manager and it have three tools to use
- Scenario Manager to create difference group of value or scenario and switch between them
- Goal Seek to find the right input for the value you want
- Data Table to see the results of multiple input at the same time
- Forecast Sheet to create a new worksheet to predict data trads
7 Outline is collect tools for summary data to analysis it have 5 tools for use
- Group to create the group row or column or automatically create an outline
- Ungroup to ungroup row or column
- Subtotal to quick calculate rows of relate data by inserting subtotals and total
- Show Detail to expands a collapsed group of cells
- Hide Detail to collapsed group of cells
