ULearnOffice.com

Navigation

Previous
Next
Homepage
FAQ
What's new
Sitemap

Topics

Excel 2007/2010/2013
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
Conditional formatting
Data table
Pivot table
Scenario Manager
Solver

Tutorials

Word
Excel 2003
Excel 2007/2010/2013
PowerPoint
Access

Others

Demonstration files
Texte en français

Contact

By e-mail
Join our Newsletter


Excel 2010 - Introduction

On this page

Introduction
The File tab
The Quick Access Toolbar
The Ribbon
The tabs
The contextual tabs
The groups
The commands
Dialog box launcher
The ScreenTip
Mini-toolbar
Keyboard shortcuts
Live preview
The galleries
Help!

On the next pages

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 tab

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 groups of commands that are under tabs. The tabs represent the each stage 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 on this bar.

3) The title bar

Allows you to manage the window application. It shows the name of the application and of 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 most group of commands.

8) Command buttons

Press the buttons 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"; from the other worksheets. 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 worksheets, 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 horizontally 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 horizontally 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 beside those from the previous year.

19) The columns

Each worksheet contains 16 384 columns named from 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 toolbar.

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. Another great addition is the Excel is using the entire screen to view and access all the possible options. Microsoft calls it the "Backstage". In a way, you can see "Behind the scenes" of your workbook. That added space greatly improves how you access files and folders, create new documents from models, and view and change the print preview.

View most recent documents and folders

A great new option lets you see the previous Excel documents you worked on but also the most recent folders. It makes it easier to get back to work on the documents you use most often.

Excel 2010 - File tab - Recent

New print option

Excel 2010 - File tab - Print

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. But it came back with, in some way, with Office 2010.

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 More commands...

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 >> button.
*Use the UP and DOWN arrows to move the command higher or lower on the list.
*Press the OK button.

The Ribbon

Office 2007 changed the command structure for the menu. Each tab represents 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 with this new menu structure, it 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 Dialog box launcher located at the bottom right of most command 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 needed 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 of commands

The group of command regroups similar commands. It makes it easier to find the commands you need. Notice that each group has its own name (Fonts in this case) and that there is a Dialog box launcher Dialog box launcher at the bottom right of most groups.

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 dialog box with all the commands and options for the group.

The ScreenTip

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

Mini Toolbar

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

Keyboard shortcuts

Here is one option that was rarely used before but was nicely improved in Office 2007. The keyboard shortcuts have been available in 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 how 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 more useful. You can kkep your hands on the keyboard and access any comand you need. 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 galleries

Another advantage of Office 2007 is to offer galleries with a vast list of possibilities to chosse from. You can place the cursor over each possibility 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