MS Office 2007

1. New Screen Layout

Excel 2007 Screenshot with major changes.

As in other members of the MS Office 2007 suite, the new interface is designed with visualization in mind. What is previously hidden in menus is laid out on the top of your screen in the form of icons together with the icon name organized into tabs. The major new elements in the screen of Excel 2007 are the following:

a. Microsoft Office Button

Most of the commands in the File menu of Excel 2003 are found here. The same is true with Word 2007, Powerpoint 2007 and other members of the Office 2007 suite in relation to Office 2003 suite. The Microsoft Office button is found in the uppermost left of the screen of Excel 2007 and other Office 2007 applications.

b. Quick Access Toolbar

Beside the Microsoft Office Button. This toolbar includes the Save, Undo and Redo buttons by default. Customizable by clicking the drop down arrow on its right selecting the commands you want to add or remove.

c. The Ribbon

Replaced the menus and toolbars of Excel 2003 and helps you quickly complete certain task. The Ribbon is very small and is an arrow pointing right downward. The ribbon is located under each Group of commands. Groups are organized under Tabs.

d. Resizable/Expandable Formula Bar

Expands when you type long formulas thus preventing formulas from expanding over data in the worksheet.

e. Sliding Zoom bar

Located in the lower most right of the screen and can be used to adjust the view of your screen.

2. Supports more Rows and Columns

Excel 2007 is now capable of providing users with 1 million rows and 16 thousand columns per worksheet.  It is now more capable of providing increased database usage capabilities by supporting 1 million rows for each worksheet.

3. Function Auto Complete

A list of functions is provided to the user that corresponds to the initially typed characters.  Information regarding the highlighted function is also provided.  Auto Complete is similar to what is found in VBA of each Office applications wherein a list of programming functions is shown to the user that corresponds to the initially typed characters.

Excel 2007 Demo: Create a formula with Function AutoComplete

4. More powerful Sorting Function

Excel 2007’s sorting function is increased up to 64 levels from the previous 3 levels.  Data can also be sorted  by color.

5. Shared Charting

Charts from Excel can be copied into Word or Powerpoint.  Excel source data can be changed and such change will be automatically reflected in your Word or Powerpoint presentation if the other applications are also open.  If the Word or Powerpoint is not open, the Chart can be refreshed to reflect the source data by right clicking on the Chart and clicking “Edit Data”.