Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education

Followers

Data Toolbar Tab in Excel 2013


Customize Tab DATA in Excel 2013

On the ribbon in Excel 2013, there is a toolbar Data. This toolbar is used for working with external data connections to the data, sorting data in Excel 2013 It contains some basic commonly used commands in working with the Get External Data, Connections, etc.

Data toolbar in Excel 2013 and the visual appearance

This toolbar consists of several groups of commands that contain command again, possibly within the respective groups. I will try to show the commands that contain certain groups in the toolbar Data.

The commands in the toolbar DATA

Data toolbar contains the following groups of commands: Get External Data, Connections, Sort & Filter, Data Tools, Outline.

  1. Get External Data group command contains the following commands to work in Excel 2013:
    1. From Access
    2. From Web
    3. From Text
    4. From Other Sources
    5. Existing Connections
  2. Connections group command contains the following commands to work in Excel 2013:
    1. Refresh
      1. Refresh All
      2. Refresh
      3. Refresh Status
      4. Cancel Refresh
    2. Connections
    3. Properties
    4. Edit Links
  3. Sort & Filter group command contains the following commands to work in Excel 2013:
    1. Sort Ascending
    2. Sort Descending
    3. Sort
    4. Filter
    5. Clear
    6. Reapply
    7. Advanced
  4. Data Tools group command contains the following commands to work in Excel 2013:
    1. Text to Columns
    2. Flash Fill
    3. Remove Duplicates
    4. Data Validation
      1. Data Validation
      2. Circle Invalid Data
      3. Clear Data Validation
      4. Clear Validation Circles
    5. Consolidate
    6. What-if-Analysis
      1. Scenario Manager
      2. Goal Seek
      3. Data Table
    7. Relationships
  5. Outline group command contains the following commands to work in Excel 2013:
    1. Group
      1. Group
      2. Auto Outline
    2. Ungroup
      1. Ungroup
      2. Clear Outline
    3. Subtotal
    4. Show Detail
    5. Hide Detail
    6. Group and Outline Settings

Data customizing toolbars in Excel 2013