learning manuals

T

Tim Maroni

Im trying to build stat. and average workbooks for
baseball and football. My question is can I find training
manuals and/or examples of functions for excel 97. Looking
for examples of formulas,a way to freeze a row and a
collom at the same time, or anything that will help me
learn to take full use of excel.
Thank you for any help you can give,
Tim Maroni
 
H

Harald Staff

Hi Tim

Select the first cell you want to move (If you want to freeze A and B and rows 1 and 2,
then C3 is the first moving cell) and go meny Window > Freeze panes.

Software doesn't come with manuals anymore, so visit a bookstore. Don't buy any computer
book thinner than 800 pages. The basic Excel things have changed little since Excel97, so
a book for 2000 or XP is at least 95% relevant for you.

Examples and functions; you're right here. The newsgroups provide hundreds of great
solutions every day. Sposts spreadsheets are a little special, but the archive
http://groups.google.com/advanced_group_search
is a good place to look .

HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.
 
N

Norman Harker

Hi Tim!

For examples of formulas and functions probably the best text is John
Walkenbach's Excel 2002 Formulas although I'll have to admit to
potential bias as I did assist in the area of financial formulas in
the 2002 version. Don't be put off by the Excel version numbering of
texts as the differences between versions are very clearly marked. But
for comprehensive listings of what's currently available in text see
the currently available booklist at:

Debra Dalgleish
http://contextures.com/tiptech.html

Also as a general resource on formulas and functions, I don't think
that you can beat a search of the newsgroups and to facilitate this
I'd recommend downloading the free addin and user guide Google Search
5.0 from:

Ron de Bruin:
http://www.rondebruin.nl/Google.htm

Just type in the name of the function that you are after assistance on
and you'll surely get plenty of examples of use in different contexts.

Then as a general functions reference file there's:

Peter Nonely:
http://homepage.ntlworld.com/noneley/

And there's a complete listing of all Excel functions, source,
descriptions, syntax, classifications and arguments available by
direct request to me (see below).
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 22nd July: Gambia (Liberation Day),
Poland (National Liberation Day), Slovenia (People's Uprising Day),
Swaziland (Birthday King Sobhuza II)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
K

Ken Wright

Personal opinion only, but given the OPs text, I think he would be better off with Johns Excel
Bible 2000 (Not 2002). It is more general in nature, and I think would probably suit the OP
better in this instance. The examples on the CD would also be beneficial to him. The formulas
book would then be a logical next step from that one in my mind.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top