Navigation

Previous
Next
Homepage
FAQ
What's new
Sitemap

Topics

Excel 2010
Office button
Home
Insert
Page Layout
Formulas
Data
Review
View
Developer

Excercises
Autosum
Chart - Insert a second axis
Create a half-moon chart
Create a demographics chart
Conditionnal formatting
Data table
Pivot table
Scenario Manager
Solver

Tutorials

Word
Excel 2003
Excel 2007
PowerPoint
Access

Others

Demonstration files
Texte en français

Word 2010 Tutorials

Contact

By e-mail
Join our Newsletter

Share this page

Excel 2007/2010 - The Introduction

Introduction
The Office button/File tab (2010)
The Quick Access Toolbar
The Ribbon
The tabs
The contextual tabs
The groups
The commands
Dialog box launcher
The info-bulle
Mini-toolbar
Keyboard shortcuts
Live preview
The galeries
Help!

The Office button (Excel 2007)
The File Tab (Excel 2010)
The Home tab
The Insert tab
The Page layout tab
The formulas tab
The Data tab
The Review tab
The View tab
The charts

The exercices (advanced content)

Introduction

Microsoft has completely changed menu structure for Word, Excel, PowerPoint and Access with Office 2007. All commands are now structured in a menu that Microsoft calls the "Ribbon". The commands are grouped under tabs and groups of commands. The tabs represent the stages of creating a document: File, Home, Insert, Page Setup, Formulas, Data, Review, View, Developer (if enabled). With Excel 2010, the Microsoft button has been replaced with a File tab. Most of the File commands from the previous versions of Excel are under this tab including Excel's options.You can place above or below the Ribbon a quick access toolbar where you can place the commands you use most. You can customize this toolbar to your choice. The Office 2007 also improves the visibility of hotkeys that you can use instead of the mouse. You can use the keys to gain access to all the commands in the Ribbon instead of using the mouse. Start by pressing the Alt key.

1) Microsoft button

This button gives you access to most commands that were formerly under the File menu options in addition to the application.

2) Quick Access Toolbar

You can place you most often used command buttons in this bar.

3) The title bar

Allows you to manage the application window. It shows the name of the application and of the file.

4) The Ribbon

You will find all the commands under this menu structure.

5) The tabs

The tabs group commands according to the steps you need to complete your documents.

6) Hotkeys

You can use a combinaition of keys to activate commands. Start by pressing the Alt key to activate Hotkeys and reach the command you need.

7) Commands groups

The commands are grouped according to the type of action que you want achieve. Plusieurs ont also of options supplémentaires en appuyant for the boîte to dialogue dans the coin inférieur droit du regroupement.

8) Command buttons

Press the boutons to activate the commands of your choice.

9) Indicateur to position

Show the position of the active cell. Can also serve to give a name to a cell or a group of cells. It can also be used to move the cursor to one of the named cells from the list.

10) The formula bar

Allows you to see and edit the cell contents, and that this content is text, numbers or formulas.

11) The active cell

Allows you to select a cell or a cell block, and then change its content, presentation, move, delete or several other possibilities.

12) The Autofill handle

Allows you to copy the contents of a cell, a formula or a series of numbers or titles.

13) The columns and rows headers

Identifies the position of cells relative to the intersection with the column letter (A to XFD) and the number of rows (1 to 1 048 576).

14) The worksheet tabs

The tabs are used to identify each workshhet inside the workbook. Excel allows you to perform calculations in length, width and also in "depth". It's possible to create a block of cells from multiple worksheets. For example, the formula to add the values from the A1 cells from Sheet1 Sheet5 would be: = sum(Sheet1:Sheet5!A1). As another example, adding the A1 cells from the current worksheet with the B4 cell from worksheet Sheet2 would be: =A1+Sheet2!B4. You can vary according to your needs.

15) The worksheet tabs movers

Since a workbook can have multiple worksheets, it is impossible to show all tabs at once. This bar so can display spreadsheets that are not visible at any given time.

16) The status bar

Allows you to see at the bottom of the screen options that are enabled.

17) The horizontal and vertical sliders

Allows you to move horizontally and vertically on a worksheet. Each sheet consists of 16 384 columns (A to XFD) and 1,048,576 rows.

18) The split screen cursors

Allow the display to cut in half horizontally and / or vertically. This allows comparison of the values that are remote. For example, this allows to compare one month's values with those of the previous year.

19) The columns

Each worksheet contains 16,384 columns named A to XFD.

20) The rows

Each worksheet contains of rows numérotées to 1 to 1 048 576.

21) The pointer

Allows you to select a cell, a cell block, object, or activate the menu options or toolbar buttons.

22) View Modes

Excel offers three display modes: normal, page layout, preview page breaks.

23) Zoom

You can zoom the worksheet to see more details or a larger preview of your template.

24) Contextual menu

Menu with the most popular options matching when you press the right mouse button.

25) Mini toolbar

Mini menu with the options have the most popular appears along with the context menu.

The Office button

The new menu in Excel 2007 includes the Microsoft Office button that combines the options that were previously under the File and Options menu.

The quick access toolbar

The toolbar places the commands you use most often above or below the Ribbon. It provides you with a quick access to the commands you use most often. The previous versions of Excel allowed you to create these unique toolbars. But this option was not often used. The bar to add the commands you use most often.

To add or customize a command to the Quick Access Toolbar.

Press the down arrow located at the end of the Quick Access Toolbar.

You can instantly select from a list of frequently used commands. You can also decide to put the Quick Access Toolbar above or above the ribbon. The bar is more easily visible above but closer to your document below.

Select the More commands... option

From the Excel Options window, under Customize option, you can choose the commands you wish to add to the Quick Access Toolbar and the order of presentation on the bar.

Select the command of your choice of the list of commands and press the Add >> button.
Press OK.

The Ribbon

Office 2007 comes with a new menu structure that takes into account the steps of creating a document. Each stage has its own tab found that groups all the commands related. It takes some time for those accustomed to the latest versions of Office to make the transition to the menu of the new version. But those who have already passed through dissent they would not go back. To help the transition, Microsoft developed Excel files with the location of commands in Excel 2003 and they are found in Excel 2007. You can find more information in the help that is explained at the bottom of this page or on the page Where is the command .

The tabs

It was under these tabs you will find the commands you will use. There are groups of similar commands and options in the dialog box launcher .

The contextual tabs

Microsoft Excel 2007 uses tabs to manage orders used by the program. However, we need additional tabs for managing the elements that can be inserted into folders such as images, diagrams, graphs and many other objects.

For example, it takes three additional tabs to manage all the options on the graphics: Design, Layout, and Format. Other items you can insert one or more will require additional tabs.

The groupings

This new menu contains commands like. Note that each grouping has its name (the font in this case) and there is a dialog box launcher in the lower right corner of the group.

The commands

These are the commands you use to create your model. It may be to insert a function or a formula, a graph, change the presentation or can print one of several other options available.

The dialog box launcher

Even with the restructuring of the menus, there is not enough screen space to cover all the commands and options available in the application. That's why it is the dialog box launcher is used to access the less frequently used commands.

The baloon help

You may need help navigating through the new menus. Excel 2007 offers the option of the tooltip. A tooltip with a short description of the command, will appear one second after you put the pointer over the item you require additional information.

Mini toolbar

In the previous versions of Excel, a popup menu appears whenever you press the right mouse button. Excel 2007 offers additional mini-toolbar to assist the presentation of your model.

Keyboard shortcut

Here is an option that was rarely used before but has been greatly improved with this version of Excel. For a long time, you could use shortcuts on the keyboard to execute commands. But it wasn't obvious since we had to press the ALT key followed by the underlined letter from the desired command. But an underlined letter in a word is difficult to read. But it is much easier with Office 2007 since the letters to choose from are now in boxes that appear below the comamndes.

Après un peu de pratique, vous allez choisir les commandes sans même y penser! After a little practice, you will choose the orders without even thinking! C'est l'option la plus sous-estimé d'Office 2007! This is the option most underestimated of Office 2007! You're going to like them after a few uses and will not want to use the mouse to select a command.

Live preview

One of the pratical inovations in Office 2007 is the Live Preview. You can see the result before choosing the command. This saves considerable time while working on the presentation of the document.

The galeries

Another advantage of Office 2007 is to offer galleries of options to preview before you choose. You can also fly over the choice of the gallery and see the effect on your document with the snapshot.

Help

Press the F1 key.

Select the option.

Select the option Référence: Emplacement of commands d'Excel 2003 dans Excel 2007.

Make sure your computer is connected to the Internet.
Click on the link Classeur to mappage du ribbon d'Excel.

Press the Open button.

Press the Yes button.

Excel 2007 will open with a workbook with all the options.

There is a tab for each menu item. So you can easily find the location of a command if you knew where it was located before. Otherwise, you can always do a search in the workbook to regain control.