Microsoft Office Development and Consultancy
|Excel > Ribbon > Tabs - Data||< Previous | Next >|
This tab provides commands previously found on the Edit menu and Tools menu.
Get External Data
From Access - Imports data from an Access database and displays the "Select Data Source" dialog box.
From Web - Displays the "New Web Query" dialog box.
From Text - Displays the "Import Text File" dialog box.
From Other Sources - Drop-Down. Lets you import data from a variety of other places as well. The drop-down includes the following commands: SQL Server, Analysis Services, XML Data Import, Data Connection Wizard, Microsoft Query.
Existing Connections - Displays the Existing Connections dialog box.
Refresh All - (Ctrl + Alt + F5). Button with Drop-Down. The button updates all the information in the active workbook coming in from external sources. The drop down includes the commands: Refresh, Refresh Status, Cancel Refresh and Connection Properties.
Connections - Displays the "Workbook Connections" dialog box. Data connections are links to data sources outside of this workbook.
Properties - This is only enabled when you select a cell that has been populated using an external connection.
Edit Links - Displays the "Edit Links" dialog box.
Sort & Filter
Sort A to Z - Sorts data alphabetically from A-Z and numerically from the lowest number to the highest.
Sort Z to A - Sorts data alphabetically from Z-A and numerically from the highest number to the lowest.
Sort - Displays the "Sort" dialog box.
Filter - Toggles filtering on the current selection. In Excel 2003 this was called AutoFilter.
Clear - Clears the filter and sort for the current selection.
Reapply - (Ctrl + Alt + L). Reapplies the filter and sort to the current selection.
Advanced - Displays the "Advanced Filter" dialog box.
Text to Columns - Displays the "Convert Text to Columns Wizard" dialog box.
Remove Duplicates - Displays the "Remove Duplicates" dialog box.
Data Validation - Button with Drop-Down. The button displays the "Data Validation" dialog box. The drop-down includes the commands: Circle Invalid Data and Clear Validation Circles.
Consolidate - Displays the "Consolidate" dialog box.
What-If Analysis - Drop-Down. The drop-down contains the commands: Scenario Manager, Goal Seek and Data Table.
Group - Button with Drop-Down. The button lets you group a selection of rows and columns. The drop-down also contains the commands: Group and Auto Outline. The Auto Outline command creates an automatic outline from the current region.
Ungroup - Button with Drop-Down. The button lets you remove the outlines from the current rows and columns. The drop-down contains the commands: Ungroup and Clear Outline. The Clear Outline command clears all the levels of outline.
Subtotal - Automatically insert subtotals for the selected rows.
Show Detail - Expand a collapsed group of cells.
Hide Detail - Collapse a group of cells.
Data Analysis - This is only displayed if you have the Analysis-ToolPak add-in loaded.
|© Better Solutions Limited 06-Dec-2013||< Previous | Top | Next >|