ULearnOffice.com

Navigation

Previous
Next
Homepage
FAQ
What's new
Sitemap

Topics

Excel 2010
File tab
Home tab
Insert tab
Page Layout tab
Formulas tab
Data tab
Review tab
View tab
Developer tab

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 2010 - Introduction

Introduction
The Office button
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 File tab
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 it's menu structure of 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 and 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 the 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.

The table below explains the elements found on the screen.

1) File tab

This tab gives you access to most commands that were previously found under the File menu and Excel's general options.

2) Quick Access Toolbar

You can place your 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 the file.

4) The Ribbon

You will find access to all the commands under this menu structure.

5) The tabs

The tab contains groups of commands that are used to on a document.

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 that you need to achieve. Many of them also have additional options by pressing the dialogue box launcher located at the bottom right corner of a group of commands.

8) Command buttons

Press the boutons to activate the commands of your choice.

9) Location indicator

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

10) The formula bar

Allows you to view and change the content of the cells; whether the content is text, a value or a formula.

11) The active cell

Allows you to select one cell, or a group of cells and change its content,presentation. You can also move it, erase it and many other possibilities.

12) The fill handle

Allows you to copy the content a cell, a range of cells, a formula or a data series onto other cells.

13) The columns and rows headers

Identifies the position of cell according to the intersection of the letter of the column (A to XFD) and the value in the row (1 to 1 048 576)

14) The worksheet tabs

Excel allows you to have many worksheets in the same workbook. The tabs at the bottom of the screen are used to identify each worksheet. Excel allows you to make calculation with many cells beside each other but also in depth. You can select a range of cells that come from many worksheets. For example, this formula adds values from cells A1 of the worksheet Sheet1 toSheet5: =sum(Sheet1:Sheet5!A1). Or add the cell A1 from the current worksheet with the cell B4 from the Sheet2 worksheet =A1+SHEET2!B4. You can adjust the formula according to your needs.

15) The worksheet tabs movers

Since a workbook can easily have over a hundred worksheet, it makes it impossible to view all the worksheet tabs at the same time. This bar allows you change the list of worksheets available.

16) The status bar

Allows you to view at the bottom of the screen the options that are activated.

17) The horizontal and vertical sliders

Allows you to move horizontaly and verticaly in the active worksheet. Each worksheet is composed of 16 384 columns and to 1 048 576 rows.

18) The split screen cursors

Allows you to "cut" the screen in two horizontaly and/or verticaly. This allows you to compare values that are located far from each other. For example, you can compare the values of the month with those from the previous years.

19) The columns

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

20) The rows

Each worksheet contains rows numbered from 1 to 1 048 576.

21) The pointer

Allows you to select a cell, a range of cells, an objects. Also use to activate the options of the menu or the buttons of the tool bar.

22) View Modes

Excel offers three view modes : Normal, Page layout and Page break preview.

23) Zoom

You can zoom in a part of the worksheet to view in detail or zoom out to have grand view of your model.

24) Contextual menu

It appears when you right click on the mouse button. This menu contains the most often used options.

25) Mini toolbar

Mini menu with the most often used presentation options for the selected item.

The File tab

The new Microsoft Office 2010 Ribbon changes the Microsoft Office button for a File tab. Some user initially believed that it was just a decoration! All the previous commands that were under the Office button are now under the File tab. Some options where improved.

The quick access toolbar

The quick access toolbar allows you to add the commands that you use the most often. They are always close so that you can use them at any time. The versions previous to Office 2007 allowed you to create your own toolbars. That option was removed in Office 2007.

How to add or to personalize the quick access toolbar ...

*Press the arrow pointing downward located at the end of the quick access toolbar.

You can immediately select among the list of the most often used commands. You can also decide to place the quick access toolbar above or below the ribbon. The bar is more easily visible above but closer to your document when it's below the Ribbon.

*Select the More commands... option

From Excel's options window, under the Personalize option, you can choose the commands that you wish to add to the quick access toolbar and select the placement order on the bar.

*Select the command of your choice from the list of commands and press the Add >> bouton.
*Press the arrows pointing above or below to move the command higher or lower in the list.
*Press the OK button.

The Ribbon

Office 2007 changed the command structure for the menu. it now takes into consideration the steps used to create a document. Each step has its own tab that regroups all the commands related to it.

The tabs

Under each tab, you will find the commands for this option. Similar commands are grouped together. But even this new menu structure cannot show all the available options; only the most commonly used ones. To access all the options, you need to press the dialog box launcher button located at he bottom right of each group.

The contextual tabs

Microsoft Excel uses tabs to manage the commands available in this program. However, contextual tabs are needed to manage the objects that you insert in your documents such as pictures, diagrams, charts , etc...

For example, three contextual tabs are need to manage all the tools available for a chart. These contextual tabs are named Design, Layout and Format. Other objects that you can insert may require many contextual tabs.

The groups

This command structure regroups similar commands. It makes it easier to find the commands you are searching for. Notice that each group has its own name (fonts in this case) and that there is a Dialog box launcher at the bottom right of each group.

The commands

These are instructions that you need to create your model. They can be used to insert a function, a formula, a chart, change your model's appearence or to print. Other options are also available.

The Dialog box launcher

Even in this new command structure, there isn't enough space on the screen to show all the possible commands and options. The Dialog box launcher opens a new window with all the commands and options for the group.

The info-buble

You may need help to navigate through all the menu's options. Excel 2007 offers an option called the info-buble. It gives short description of the command when the pointer hovers over the command button.

Mini Toolbar

In the previous versions of Excel, a contextual menu appeared every time that you pressed the right mouse button. From Excel 2007 on, an additionnal mini toolbar appears at the same time. It gives you quick access to change your documents' presentation.

Keyboard shortcuts

Here is one option that was rarely used before but was nicely improved in Office 2007. The keyboard shortcut have been used in many previous versions of Office. But it was hard to notice which keys should be used and at what time. You may have noticed them before but didn't know comment to use them. Most commands in the menus had a letter that was underlined. That was the keyboard shortcut. In Office 2007, when you press the Alt key. The shortcuts are more obvious and therefore useful. You won't have to move your right hand from the keyboard has often when you start using shortcuts.

With a bit of practice, you will be choosing commands without even thinking about it! This option is really under estimated and should be used more often!

Live Preview

Office 2007 added a wonderfull option called Live Preview. You can see what impact a command will have on your document even before you apply it. This saves a lot of time in trial and error. You may even be temped to try even more possibilities before deciding what to apply.

The galeries

Another advantage of Office 2007 is to offer galeries with a vast list of possibilities to chosse from. You can place the cursor over each possibilities and see the impact it would have on your document because of the live preview.

Help!

Microsoft Office does provide the user help just by pressing the F1 key. With Office 2010, it will look up the help file from the Internet. The advantage of this is that you always have access to the most recent support documentation.

 

 

 

You like what you read? Share it with your friends.





This site is hosted by 1&1.com