Email: Johh Hookham Tel: 020 8549 8797

Latest Feature: File Compatibility

Feature image

Excel 2003 and Excel 2007 (Compatibility Issues)

Most companies and organisations use two versions of MS Excel; one is part of MS Office 2003 and the other is part of MS Office 2007, the latest release from Microsoft.

Often they also use two versions of the MS Windows operating system; Windows XP and Windows Vista. New machines tend to be supplied with Vista. MS Office 2003 will work with both operating systems. Office 2007 normally uses Vista, not because there are problems with XP per se, but laptops running XP tend to be older and already have Office 2003 installed.

However if you create a document using Office 2007 (the latest version of the MS Office suite) it may present problems for someone with Office 2003; they may not be able to open the document. This problem is common across many organisations.

Microsoft has recognised this as being a major issue for many of their customers; their solution is to supply a file format conversion / formatting plug-in for Office 2003. After the plug-in has been applied Office 2003 will ‘know’ how to open the Office 2007 files. Typically Office 2007 files have the extension xlsx or docx rather than doc or xls so it is easy to identify the files created using the different generations or versions of the MS Office suites. This new extension also ensures it is easy to identify why the document that has been sent to you cannot be opened.

The file format converter program is available to download from the Microsoft website and it only takes a few minutes to install. It may also be necessary to install the latest ‘patch’ to Office 2003 prior to installing the file converter plug-in.

If there are any specific 2007 features used, these will be lost when it is changed using 2003. But in the majority of cases this does not present a problem.

Interface differences between Office 2003 and Office 2007

When most users (who are familiar with Office 2003) look at Office 2007 they do not know where to start; all of the familiar icons seem to have disappeared. Over time everyone will understand the new layout and interface but untill that happens the users will need some guidance.

Microsoft have provide a help file to show the Excel 2007 equivalent commands for Excel 2003 users. You can either Run this interactive help file or save it on your computer (the options may be dependant on your browser and set-up). The original file is on the Microsoft website and is copyright of Microsoft.

Web Directory: (links not yet added)

Features, Articles, Comment Tutorials and Reviews

Feature Image

Email; Keep it all or Delete it all

Different legal statues seem to contradict one another when applied to managing a company’s email. John Hookham highlights the issues and looks at the different options available. Email and the World Wide Web are available to the masses and for many organisations digital media is now the preferred method of communication. Published by Evaluation Centre. Download pdf.

Feature Image

Website Accessibility

For most people access to the Intenet and the information it contains is easy. But for the disabled both accessing and viewing Web sites can present difficulties. John Hookham looks at some of the problems faced by those suffering from 'digital exclusion'. Published in Bulletin - the magazine of the Records Management Society. Download pdf.

Feature Image

Phishing, pharming and other scams

John Hookham looks at the current crop of cons, frauds and tricks floating around the web. Some are old, some are new but they all want one thing: your money. Published in Conspectus - The IT Report for Directors and Decision Makers. Download pdf.

Top Tips and Articles:

ImageExcel Guide One
Part One of a simple but slightly unorthodox guide to using Spreadsheets, specifically MS Excel.

ImageExcel Guide Two
Part One dealt with the Cell Position. Part Two looks at the cell content or more correctly the format of the cell content.

ImageExcel Guide Three
Part Three deals with the different ways of using text within a spreadsheet; as column and row labels or as an alternative to formatted tables in a word processing document.

ImageExcel Guide Four
Part Four looks at helping to solve one major problem with spreadsheets; how do you know if the data that has been entered is correct or at least within some specified parameters, answer; conditional formatting.

Open Source Related Items:

ImageLibreOffice
LibreOffice (formerly OpenOffice) is a popular and functionally rich Open Source office suite with word processing, spreadsheet, presentation graphics etc. The user interface is intuative, installation is easy, and because the software is open source there is no software licence to buy. It can also read and write files in MSOffice formats. And the latest version; 3.4.4 will also read MS Office 2007 files (ie files with the extensions; docx, pptx, xlsx etc) Download at LibreOffice.org

ImageGIMP
To enhance your word processed documents pictures can be added; 'a picture is worth a thousand words'. GIMP is graphic and image processing software and has many of the features contained in commercial programs such as PhotoShop. The main advantage of GIMP is that, like OpenOffice, it is open source software and so it can be downloaded as used without having to purchase a licence. Download at GIMP.org

ImageUbuntu 11.10
The latest verson of desktop Linux is now available and can be downloaded. There is also a choice of user interfaces with the two of the most popular being; GNOME (the default desktop) and KDE. Download at Ubuntu

ImageFrench Police adopt Ubuntu
An interesting paper outlining a multi-stage move to open source applications and operating systems. Read the paper.