Creating a complicated excell file

[Graham]

I want to create an excell file to simplify? proceedings at my club.
The requirements are

Day book (list of members present each day)
this includes payments in and out

Two simple checklists

A stock check, updated(at days end) by sales made in the daybook.

The ability to print ( again at days end) two sheets, one of the daybook and another of current stock levels.

First question, is excell capable of this sort of thing.

Secondly can I get options to save typing, eg just type the first couple of letters and get autocomplete, or select from a dropdown?

Third and most significant, if excell can do this, what book should I get to help?

I probably have bitten off more than I can chew, but it would be a challenge.

<FONT COLOR="magenta"><FONT size="5">G</FONT c></FONT s>

[Maxwell T]

Excel can certainly do all those things (97 and up, for sure) - but you might find Access is better at it (if you have it). As far as a book goes - The Microsoft series o books they sell aftermarket are very thorough. The default installation should have included a couple of sample files for each package (Excel and Access) check them out, I found them to be a great "as you go" tutorial in learning the software.