Wednesday, September 30, 2009

Microsoft Office 2007

Microsoft Office 2007 (officially called 2007 Microsoft Office System) is the most recent Windows version of the Microsoft Office System, Microsoft's productivity suite. Formerly known as Office 12 in the initial stages of its beta cycle, it was released to volume license customers on November 30, 2006[1] and made available to retail customers on January 30, 2007. These are, respectively, the same dates Windows Vista was released to volume licensing and retail customers. Office 2007 contains a number of new features, the most notable of which is the entirely new graphical user interface called the Fluent User Interface[2] (initially referred to as the Ribbon User Interface), replacing the menus and toolbars – which have been the cornerstone of Office since its inception – with a tabbed toolbar, known as the Ribbon. Office 2007 requires Windows XP with Service Pack 2 or higher, Windows Server 2003 with Service Pack 1 or higher, or Windows Vista.[3]
The 'Ribbon User Interface' is a task-oriented Graphical User Interface (GUI). It features a central menu button, widely known as the 'Office Button'. The Ribbon Interface stayed in Microsoft Office 2010.
Office 2007 also includes new applications and server-side tools. Chief among these is Groove, a collaboration and communication suite for smaller businesses, which was originally developed by Groove Networks before being acquired by Microsoft in 2005. Also included is Office SharePoint Server 2007, a major revision to the server platform for Office applications, which supports "Excel Services", a client-server architecture for supporting Excel workbooks that are shared in real time between multiple machines, and are also viewable and editable through a web page.
Microsoft FrontPage has been removed from the Office suite entirely. It has been replaced by Microsoft Office SharePoint Designer, which is aimed towards development of SharePoint portals. Its designer-oriented counterpart Microsoft Expression Web is targeted for general web development. However, neither application is included in any of the Office suites.
Speech recognition and handwriting recognition are now part of Windows Vista. Speech and ink components have been removed from Office 2007.[4][5] Handwriting and speech recognition work with Office 2007 only on Windows Vista or Windows XP Tablet PC Edition. However, XP users can use an earlier version of Office to use speech recognition.

Saturday, September 26, 2009

Excel Drop Down List

Excel is excellent and lets see how it helps you using this drop down list features !
If you don't want to risk an item being miss-typed in a cell, drop down lists are an ideal solution. So These lists display all of the available choices to the user so that they can click on their preference. Excel allows you to place two different types of drop down list on your worksheet - either a validation list or a form object.
A validation drop down list
These lists are contained within a cell on your worksheet and the drop down arrow (to the right of the cell) does not appear unless the cell is selected. To add a list to a worksheet place the cursor in the required cell and then selectData Validation Settings. In the dialog box select 'Allow: List' and ensure the 'In-cell dropdown' box is ticked. The source data refers to a range of cells containing the selection of options. If you use the mouse to point to a range of cells (e.g. H12:H15), they must normally be contained on the same worksheet. If however you have named the range of cells (e.g. '=ConsNames') containing your data, it can be anywhere in the workbook.
In the example (right) the list has been placed in cell B2. Having selected 'Mrs Plain' the formulae in the table (B3:D8) lookup values in a range of data and summarise it. The consultant name can be referred to by the cell name (B2). If you wish to know the position of the selected item within the original range of options (i.e. the four names), an additional formula is needed. In cell B9, the formula =MATCH(B2, H12:H15, 0) determines that Mrs Plain is the second item in the list.
Using a combo box or a list box
These are independent objects (or controls) that can be placed onto a worksheet and are not contained within a cell as such. The example (left) contains a combo box but your choice of object can depend on the amount of space on your worksheet and the number of options.
To obtain these controls you must open the Forms toolbar (View Toobars Forms). Then click on either of the list buttons and drag an outline for the object on your worksheet. To instruct the new control where to find it's source data, right click on it, then choose Format Controlfrom the short menu. On the 'Control' tab of the dialog box, enter the range of cells containing the list options. The 'Cell Link' refers to a cell where you wish the list box to place a numeric value representing selected item. In the example above cell B21 is linked and indicates that the third list item was selected. You cannot refer directly to the value in the list box, but the option number in your worksheet cell is automatically updated to reflect any change in the control object.
To determine the actual name of the selected item (i.e. Dr Tiswas), use a formula such as =OFFSET(H11, B21, 0) where H11 is the cell immediately above the options list and B21 contains the option value. (Click here for details about the OFFSET function).

Tuesday, September 1, 2009

Get Up To Speed With Microsoft Word 2007

Released in January 2007, Microsoft Word 2007 has undergone some drastic changes, most noticeable of which is the replacement of the old menu and toolbar system with the new ribbon. The ribbon is the focal point of a new user interface designed to make it even quicker and easier to perform professional document authoring tasks. Once you are familiar with using the ribbon in Word 2007, you will find the transition to all the other products in Office 2007 a doddle - the ribbon is common to them all. And so are new concepts like themes and content controls.

Whether you create newsletters, articles, annual reports or update a blog, Microsoft Word 2007 enables you to create, edit and share content in a variety of formats. Themes allow you to change the entire look of a document with just a few mouse clicks. Building blocks give you the opportunity to create reusable content, helping you to cut down time spent on the creation and cross referencing of key information like document title, subtitle etc. Pictures you have inserted into your document can be enhanced quickly and easily with Quick Styles (effects include drop shadows, reflections, borders and more).
Briefly, Word 2007 is laden with a plethora of other new features, such as:
* mini toolbars
* key tips (adapting keyboard shortcuts)
* themes
* content controls
* blog integration
and the list goes on!
You can use the tutorials on this site to get up to speed with Microsoft Word 2007.
post from