Computers: Opening up a world of possibilities: One of the big advantages of spreadsheets is being able to do 'what if' forecasts. Janet Swift looks at the Windows options

IF YOU THINK of the word processor as replacing the typewriter, you can think of a spreadsheet as being the equivalent of a pencil, calculator and the 'back of an envelope'.

Windows, the PC-compatible's graphics-based operating system, has a calculator program for one-off calculations, but when you want to keep track of 'the workings' you need a spreadsheet. This allows you make a note of your starting values, perform some calculations and to see the answers.

The spreadsheet is an ideal way of playing with numbers and comes into its own when calculations are difficult. Most spreadsheets have a wide range of built-in functions, so, for instance, if you want to work out the total return on an investment at a given interest rate over a period of time, you can do so in a single step.

If you want to keep financial records, then consider the spreadsheet as the electronic equivalent of a ledger book where the columns can be automatically totalled and you never need doubt the arithmetic.

But while the spreadsheet has become standard in business, its role at home is less obvious. The typical examples quoted to justify the need for one are keeping track of your bank balance and discovering what your mortgage repayments should be. However, the advent of personal finance programs, such as Microsoft's Money and Intuit's Quicken, means that the spreadsheet is no longer an obvious tool if all you want are answers to standard question.

If, however, you are the sort of person who prefers to work things out for yourself, then a spreadsheet is the tool you need.

The advantage of the spreadsheet is its flexibility. It will help you make sense of information of every type - it handles lists of numbers, dates and words with equal ease. Indeed it is so easy that you can use it for chores that you would otherwise avoid.

For example, if you want to find out which is the bargain buy from a bewildering range of possibilities - say, for instance, competing computer systems all with slightly different specifications - then a spreadsheet can be used to make a list of options complete with prices, discounts and total costs including delivery. You can work out anything you need simply by entering the calculation.

If you change the basic figures - a higher discount or whatever - then the calculations and results are updated instantly. The first time you see this happen it looks like magic - and from the point of view of anybody who would otherwise have had to perform the same task with a pocket calculator, it is magic.

Spreadsheet magic is now better than ever in that programs anticipate what you would previously have had to tell them. For example, in Lotus 1-2-3 for Windows all you have to do to produce a list of the months of the year is to type in just one word. You start 'January'. and it will automatically carry on February, March and so on. You can waste a lot of time just trying to find a sequence that the program cannot predict automatically.

Another role for the spreadsheet is in exploring what might happen given different sets of conditions. This means you can investigate questions like: 'How much will my savings buy me in 10 years time if the interest rate is 8 per cent or 6 per cent or 4 per cent and inflation is 1 per cent, 2 per cent or 5 per cent?'

Tables of figures often seem dry and indigestible. A spreadsheet can give them colour and add impact. You can produce colourful and informative charts with the minimum of bother and can make printed output attractive using different typefaces and graphics.

The most important criteria for home users is ease of use and on the whole spreadsheets are easier to use than to explain. Just five minutes watching someone use one - or following through the simple examples that the programs provide - is all that is needed to get you going. Windows spreadsheets are particularly easy to use because you can use the mouse to point at the data you are interested in.

There are three main Windows spreadsheets. The one with the brand name that means 'spreadsheet' to most users is Lotus 1-2-3. This has a long track record in the pre-Windows era, but until recently this was perhaps more of a disadvantage.

The reason is that starting from an existing product is not the best way to develop something radically new. The latest incarnation, version 4 for Windows, has finally progressed far enough away from its origins as a Dos program - designed to work from the PC's text- based operating system - to be able to resume its position as one of the leading spreadsheets - but competition is tough.

Excel is Microsoft's spreadsheet. It has always been at the forefront of Windows technology - not surprising as the two programs come from the same company - and it has been responsible for introducing some of the ideas that make current spreadsheets so easy to use, such as a 'sum' function that automatically recognises the numbers that you want to total.

Quattro Pro version 5, a sophisticated spreadsheet from Borland, has a smaller share of the market than the other two, but it has just as many good features and to my mind it has the best thought-out structure. Perhaps the only problem is that all Windows spreadsheets are 'full featured'. This is a polite way of saying that you are unlikely to use more than 10 per cent of their capabilities. If you look at what the software manufacturers would claim as key features they go far beyond the everyday requirements of the average business user and are well in excess of the home user's wildest dreams.

For example, Lotus 1-2-3 release 4 makes a selling point of having a 'Version Manager' which allows the sharing of ideas with co-workers on a network. This is good news for merchant bankers, but good news for them may leave the rest of us unmoved.

In addition, all spreadsheets have sophisticated analysis options that most users never explore, let alone use. The main drawback of these surplus features is that they fill up your machine's disk storage and slow down the part of the program that you do use - causing problems if your machine is not powerful enough to cope.

If you want a cut down version of a Windows spreadsheet you might be surprised to discover that there is no such product. The nearest alternative is an all-in-one package such as Microsoft Works for Windows. This gives you almost all the spreadsheet functionality you are likely to need and is not too greedy in its demands for resources.

If you want a full spreadsheet, but not at the corporate price tag they usually command, my recommendation would be Quattro Pro Standard which at its current offer price of about pounds 50 (0800 212727) has to be described as a 'best buy'.

Have you tried new the Independent Digital Edition apps?
Latest stories from i100
  • Get to the point
Have you tried new the Independent Digital Edition apps?
Independent Dating

By clicking 'Search' you
are agreeing to our
Terms of Use.

Day In a Page

Where the spooks get their coffee fix: The busiest Starbucks in the US is also the most secretive

The secret CIA Starbucks

The coffee shop is deep inside the agency's forested Virginia compound
Revealed: How the Establishment closed ranks over fallout from Loch Ness Monster 'sighting'

How the Establishment closed ranks over fallout from Nessie 'sighting'

The Natural History Museum's chief scientist was dismissed for declaring he had found the monster
One million Britons using food banks, according to Trussell Trust

One million Britons using food banks

Huge surge in number of families dependent on emergency food aid
Excavation at Italian cafe to fix rising damp unearths 2,500 years of history in 3,000 amazing objects

2,500 years of history in 3,000 amazing objects

Excavation at Italian cafe to fix rising damp unearths trove
The Hubble Space Telescope's amazing journey, 25 years on

The Hubble Space Telescope's amazing journey 25 years on

The space telescope was seen as a costly flop on its first release
Did Conservative peer Lord Ashcroft quit the House of Lords to become a non-dom?

Did Lord Ashcroft quit the House of Lords to become a non-dom?

A document seen by The Independent shows that a week after he resigned from the Lords he sold 350,000 shares in an American company - netting him $11.2m
Apple's ethnic emojis are being used to make racist comments on social media

Ethnic emojis used in racist comments

They were intended to promote harmony, but have achieved the opposite
Sir Kenneth Branagh interview: 'My bones are in the theatre'

Sir Kenneth Branagh: 'My bones are in the theatre'

The actor-turned-director’s new company will stage five plays from October – including works by Shakespeare and John Osborne
The sloth is now the face (and furry body) of three big advertising campaigns

The sloth is the face of three ad campaigns

Priya Elan discovers why slow and sleepy wins the race for brands in need of a new image
How to run a restaurant: As two newbies discovered, there's more to it than good food

How to run a restaurant

As two newbies discovered, there's more to it than good food
Record Store Day: Remembering an era when buying and selling discs were labours of love

Record Store Day: The vinyl countdown

For Lois Pryce, working in a record shop was a dream job - until the bean counters ruined it
Usher, Mary J Blige and to give free concert as part of the Global Poverty Project

Mary J Blige and to give free concert

The concert in Washington is part of the Global Citizen project, which aims to encourage young people to donate to charity
10 best tote bags

Accessorise with a stylish shopper this spring: 10 best tote bags

We find carriers with room for all your essentials (and a bit more)
Paul Scholes column: I hear Manchester City are closing on Pep Guardiola for next summer – but I'd also love to see Jürgen Klopp managing in England

Paul Scholes column

I hear Manchester City are closing on Pep Guardiola for next summer – but I'd also love to see Jürgen Klopp managing in England
Jessica Ennis-Hill: 'I just want to give it my best shot'

Jessica Ennis-Hill: 'I just want to give it my best shot'

The heptathlete has gone from the toast of the nation to being a sleep-deprived mum - but she’s ready to compete again. She just doesn't know how well she'll do...