Data Tab

The Data tab in Excel 2007 ribbon consists of 6 groups:

Get External Data

Here you can import data into Excel from various external sources like Microsoft Access, Microsoft SQL Server, text files or the web.

Connections

Create and edit connections to external data sources that are stored in a workbook or in a connection file.

Sort and filter

Sort or filter data based on a specified criteria.

Data Tools

Here you have various data tools like removing duplicates, validation or data analysis.

Outline

Here you can group data based on a selection or you can create a subtotal in a given column based on values (keys) of another column.

Analysis

Provides various data analysis tools like random number generation, histogram or moving average.

Posts on Excel 2007 user interface:

1. Introduction
2. The Home tab
3. The Insert tab
4. The Page Layout tab
5. The Formulas tab
6. The Data Tab
7. The Review Tab
8. The View Tab
9. The Developer Tab

Applies to : Excel 2007

The layout of Excel 2007 user interface can be considered as a breakaway from the traditional menus of previous releases.
The user interface now consists mainly of Microsoft Office button ,the Ribbon and the tabs which are main components of the Ribbon.

Microsoft Office button

The office button consists of commands that used to be found under the File menu of previous Excel versions like Open, Save and Exit plus Excel Options.

The Ribbon

There are three basic components to the Ribbon:

1. Tabs: There are seven of them across the top. Each represents core tasks you do in Excel.
2. Groups: Each tab has groups that show related items together.
3. Commands: A command is a button, a box to enter information, or a menu.

I will try in this post, and hopefully more posts to come, to give an overview of some of those new tabs.

The Tabs.

1. The Home tab. Covers the most common task the people use in a regular basis like copy, paste and formatting.
2. The Insert tab. For inserting tables, charts, pictures, .. etc.
3. The Page Layout tab. For page setup and print formatting.
4. The Formulas tab. Formulas, defined names and calculations.
5. The Data tab. Connections, external data, sorting and filtering … etc.
6. The Review tab. Check spelling, comments and protection.
7. The View tab. Custom views, zooming, show and hide … etc.

Posts on Excel 2007 user interface:

1. Introduction
2. The Home tab
3. The Insert tab
4. The Page Layout tab
5. The Formulas tab
6. The Data Tab
7. The Review Tab
8. The View Tab
9. The Developer Tab

Applies to : Excel 2007

Insert Tab

The Insert tab in Excel 2007 user interface consists of 5 groups:

Tables

Allows you to:

1. Define a range of cells as a table for easy filtering and sorting.
2. Create a pivot table form your data.

More table or pivot table options will be shown when the table is created.

Illustrations

To insert picture, clip art, shapes or SmartArt (a more stylish flowchart-like shapes).

Charts

To insert different types of charts. More chart specific options will be shown when the chart is created.

Links

Allows you to insert a hyperlink to a place in the same workbook or an external one.

Text

To insert text box, header and footer, wordart, digital signature, object (embedded document like word or power point presentation) or a symbol.

Posts on Excel 2007 user interface:

1. Introduction
2. The Home tab
3. The Insert tab
4. The Page Layout tab
5. The Formulas tab
6. The Data Tab
7. The Review Tab
8. The View Tab
9. The Developer Tab

Applies to : Excel 2007

The Home tab

The home tab in Excel 2007 ribbon is divided into 7 groups, or sections, presented in a toolbar:

1. Clipboard : contains the main edit commands: Cut, Copy and Paste plus the Format painter. The Paste command can be expanded by clicking on the arrow below it to give a submenu which is basically a Paste Special options.

2. Font: Options for font type, size, color, border .. etc.

3. Alignment: Text vertical and horizontal alignment, indentation, text wrapping… etc.

4. Number: Number formatting e.g. Number, Date, accounting. Also decimals, comma style and percentage.

5. Styles: Allows you to specify Conditional formatting by defining formatting rules. You can also format a selected cell by selecting one of the built in formatting styles or you can define a range as a table, and give it one of the predefined styles, or further more you can define your own style.

6. Cells: Allows you to Insert, delete or format, not only cells but also whole columns, rows or sheets. Formatting also includes renaming, hiding or protecting.

7. Editing: Mainly for formulas, sorting, filtering, find and replace.

Note:

Click on the arrow below or next to each option to reveal more options.

Posts on Excel 2007 user interface:

1. Introduction
2. The Home tab
3. The Insert tab
4. The Page Layout tab
5. The Formulas tab
6. The Data Tab
7. The Review Tab
8. The View Tab
9. The Developer Tab

Applies to : Excel 2007