Word 2007: Getting Used to the Ribbon

The Ribbon is almost certainly the most used aspect of the Microsoft Word interface. It has the vast majority of the commands that the programme has to offer. The commands are arranged in a series of Tabs. To activate any Tab, click on its name. The commands shown in each Tab are related in some way. For example, the commands in the Home Tab are those which are most frequently used in Microsoft Word: commands such as Cut, Copy and Paste and commands for changing the paragraph and character attributes of your text.

As well as the regular Ribbon Tabs, Microsoft Word 2007 also contains context sensitive Tabs. These are Tabs which only appear in a certain context, for example, when you insert a text box. Having drawn the text box, a special tab appears for formatting text boxes. However, when you click outside the text box to deselected it, the context Tab disappears.

The Insert Tab contains commands for adding elements to your page such as tables, pictures, headers and footers.

The References Tab contains controls for adding references to longer documents such as tables of contents and indexes.

The Mailings Tab contains controls for creating mail merge documents. This involves the combination of a data document, which normally contain a list of recipients, with a main document, which is normally a letter, to produce a series of personalised mail merge documents which can then be sent out to each recipient.

The Insert Tab contains commands for adding elements to your page such as tables, pictures, headers and footers.

The View Tab contains controls for displaying the document in various ways. There are also controls for zooming in and out.

Finally, we have the Developer Tab. This contains controls for creating and editing macros and Visual Basic applications.

As well as the regular Ribbon Tabs, Microsoft Word 2007 also contains context sensitive Tabs. These are Tabs which only appear in a certain context, for example, when you insert a text box. Having drawn the text box, a special tab appears for formatting text boxes. However, when you click outside the text box to deselected it, the context Tab disappears.

The Mailings Tab contains controls for creating mail merge documents. This involves the combination of a data document, which normally contain a list of recipients, with a main document, which is normally a letter, to produce a series of personalised mail merge documents which can then be sent out to each recipient.

Another example of a context sensitive Tab is the one which appears when you insert a text box. Having drawn the text box, a special tab appears for formatting text boxes. Once again, when you click outside this to deselected it, the context Tab disappears.

The writer of this article is a developer and trainer with a UK IT training company offering Microsoft Word 2007 Classes, as well as Word VBA training in London and throughout the UK.

Finding Effective Training On Microsoft Excel 2007

Upgrading to Excel 2007 may be something of a shock to you and your staff. The initial reaction of most people is: “where is everything?” Bearing this in mind, you may well find that a training course on Excel 2007 is a good investment. The training should first of all get you past the initial state of confusion caused by the fact that 2007 looks so different from previous versions. Then it should give you some guidance on the new features in Excel 2007 such as the enhancements to charting and graphics, functions and conditional formatting.

One of the first things you should look for in having training on Excel 2007 is a full explanation of how the new interface works. You should be shown the new way of working and learn useful tips and shortcuts which will enable you to become at least as productive in Excel 2007 as you were in 2003.

In addition to this, however, you will want to learn the new features that Excel 2007 has to offer: the stuff that either wasn’t available in previous versions or which has undergone considerable enhancement.

The Excel 2007 worksheet is much bigger than its 2003 counterpart; about a thousand times bigger in fact. Your Excel 2007 training should show you how you can exploit this huge area when designing your spreadsheets. Some decent navigation tips would also be helpful.

Your training should also include demonstrations and explanations of pivot tables, a feature which has been revamped and improved in Excel 2007. If you or your colleagues have not used pivot tables to any great extent before, the training should begin by reviewing basic pivot table concepts before moving on to look at what Excel 2007 has to offer.

Charts have been given a big overhaul in version 2007. So be sure your training includes coverage of the special effects available in Excel 2007 charting and graphics. Your training course should cover such features as the format, design and layout ribbons and how to use SmartArt graphics and shapes. If charting is particularly important in your organisation, then make sure your training covers things like trendlines, scatter charts and pivot charts.

Your Excel 2007 training course should also cover conditional formatting. This is a feature that has been much enhanced in Excel 2007 and your training should show you how to exploit the new features available. Make sure you will come away from the training knowing all about Data Bars and Color Scale.

The ability to enter formulas and functions into the cells of an Excel spreadsheet is the key feature that has made the program so essential to so many organisations. Excel 2007 has added several new features relating to functions and several new functions. You should insist that any training course you book on Excel 2007 demonstrates these new features and functions such as IfError, SumIfs and AverageIf.

Excel 2007 Navigation Techniques

Each Excel document is referred to as a workbook and each workbook can contain up to 255 worksheets. To activate a particular worksheet, click on one of the tabs displayed at the bottom of your screen.

To the left of the tabs will find four navigation buttons. These are useful where you have a workbook that either contains lots of worksheets or has worksheets with very long names. The very first one makes the name of the first worksheet visible; the very last one makes the name of the last worksheet visible. The left pointing arrow makes the name of the previous worksheet visible and of course the right pointing arrow makes the name of the next worksheet visible. These icons don’t actually activate a worksheet; they simply make its name tab visible. To activate a sheet, you still have to click on that particular tab.

Worksheets can also be activated from the keyboard. To activate the next worksheet to the right, hold down the Control key and press Page Down. This moves you forward through your worksheets are naturally holding the Control key and pressing Page Up moves you back to the left.

Once you’ve navigated to a particular worksheet, you will need to go to a particular cell or a particular section of that worksheet. Naturally, you can use the scrollbars to make different parts of the worksheet visible. You can also move around the worksheet using the arrows on your keyboard: down, right, up and left.

Excel also allows you to use keyboard shortcuts for moving to the edges of a given body of data. To get to the right-most cell of the current range, hold down Control and press the right arrow and of course to get to the bottom cell, hold down Control and press the down arrow.

It is also possible to do exactly the same thing with the mouse. Position the cursor on one of the edges of the selection rectangle (that bold highlight which is displayed around the currently active cell) and then you simply double-click. Double-clicking on the right hand edge of the selection rectangle takes you to the extreme right of the current range. Double-clicking on the bottom edge jumps to the bottom of the range, and so forth.

There are two final navigation key combinations which should be mentioned: Control-Home and Control-End. Hold down the Control key and press the End key to move to the bottom right of the current range. Hold down Control and press Home to move to the top left of the current range.

As well as navigating through the worksheets, all users of Excel make frequent use of the Ribbon. Excel offers a series of useful keyboard shortcuts when working with the Ribbon.

To access the ribbon keyboard shortcuts simply press the Alt key once on your keyboard. A series of badges are then displayed which represent the letters or numbers that you should type to activate that part of the Ribbon. For example, “W” is the shortcut for accessing the View Tab.

When you press “W” and the View Tab becomes active, another series of badges is displayed on each of the commands within the View Tab. For example, the “Arrange All” command has “A” as its keyboard shortcut, so simply typing “A” is equivalent to clicking the Arrange All button.

Once you have typed a letter to execute a command, the Ribbon loses focus and the shortcut letters and numbers disappear. To access Ribbon commands via the keyboard again, just press the Alt Key and the badges will reappear. This means that you never have to worry about learning keyboard shortcuts. All you have to remember is to press the Alt key on your keyboard and Excel will prompt you from then on.